ExcelRead
ExcelRead reads data from an Excel spreadsheet file.
This function supports files that have been created using Microsoft Excel 2007 or later (.xlsx file extension). You do not need to have Excel installed to use this function.
Properties
File path
The file path of the xlsx file to read.
Read type
Read specific ranges
Range information should include enough sheet information to identify the sheet to read the data from. Omitting the sheet name or sheet index will read the data from the first sheet.
Read ranges in all worksheets
Range data will be read from all sheets filtered by the sheet name filter. Range information should not include any sheet names or indexes.
Sheet name filter
This property is only available if Read type is "Read ranges in all worksheets".
It takes a regular expression that filters the sheets that are read e.g. "^invoice" will only read data from sheets that starts with "invoice" - therefore, "invoice123" will be read, but "fooinvoice" will be ignored.
Range
The range property specifies an Name and a Range in the format
Name can be any valid Linx name.
Range is specified using the A1 reference style,
e.g.
When the range-end is unknown, make the range-end effectively "unlimited" by providing a value like "D99999". Linx will only read the rows containing data; thus, if your range-end is "D9999", but you only have 50 rows of data, ExcelRead will stop after 50 rows.
Loop results
Read type = Read specific ranges
This option is available when at least one of the ranges references multiple rows.
If checked, the rows will be returned one at a time in a loop. If more than one range is specified, a separate loop is created for each range.
If not checked, a list containing all the rows will be created. If more than one range is specified, one list for each range will be returned.
Read type = Read ranges in all worksheets
If checked, the sheets are returned one at a time in a loop.
If not checked, a list containing all the sheets is created.