ExcelRead

ExcelRead reads data from an Excel spreadsheet file.

Note:

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":"Range1","Range":"Sheet1!A2:G4"}. Use the Range Editor to edit it. You can also specify multiple ranges.

Name can be any valid Linx name.

Range is specified using the A1 reference style, e.g. 'A1:D3', or 'Sheet3!B3'. You can also reference a sheet using its index e.g. '\1!B3' will reference the first sheet in the workbook.

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.

RangeEditor

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.


Office Open XML file format

Office Support: The A1 reference style