XLSheetToArray

 

XLSheetToArray>file_name,sheet_name,array_name

 

Not supported in Macro Scheduler Lite.

 

Imports a sheet from a .xls Excel file (.xls only) into an array.  Note that this function differs from the other XL functions in that it does NOT require Excel to be installed and instead reads the Excel file directly.  Therefore the same degree of compatibility cannot be guaranteed.  If you are using modern .xlsx files, export to .xls first.

 

The array takes the format:

 

arrayname_row_col

arrayname_row_count

arrayname_count

 

E.g. the following sheet will produce the array variables given below:

 

Excel Sheet "Sheet1"

 

ID,Date,Value

1,28/02/2010,50

2,01/03/2010,75

 

Code:

 

XLSheetToArray>file.xls,Sheet1,xlData

 

Array:

 

xlData_1_count=3

xlData_1_1=ID

xlData_1_2=Date

xlData_1_3=Value

xlData_2_count=3

xlData_2_1=1

xlData_2_2=28/02/2010

xlData_2_3=50

xlData_3_count=3

xlData_3_1=2

xlData_3_2=01/03/2010

xlData_3_3=75

xlData_count=3