Skip to content

README.md

Latest commit

 

History

History
22 lines (18 loc) · 781 Bytes

README.md

File metadata and controls

22 lines (18 loc) · 781 Bytes

ExcelToArray

Read excel data to AHK array

Usage

arr := ExcelToArray(FileName, nSheet, last_row, last_column)

  • FileName - The excel file path.
  • nSheet - (Optional) Sheet number. Default is 1.
  • last_row - (Optional) Last row number.
  • last_column - (Optional) Last column number.

Example of output array:

[
  ["a1", "b1", "c1"],
  ["a2", "b2", "c2"]
]

Note: This function uses sheet.Range(cell_begin, cell_end).FormulaR1C1 (instead of .Value) to read the data, it can avoids the numbers such as 1.2 converted into 1.200000. But if the cell contains formula, the formula code itself will be read, not the actual value.

Related Function