Function Names
excel list tablesDescription
This function identifies all named Excel tables inside the Microsoft Excel workbook (Open Office format) and returns them in a set containing strings.
This information may be necessary in order to load the right table in the Excel file afterwards. Pivot tables and named ranges are not included here.
Attention: Encrypted, binary and proprietary legacy file types (e.g. .xlsb, .xls) cannot be processed.
Call as: function
Restrictions
Indirect parameter passing is disabled
Parameter count
1
Parameters
| No. | Type | Description |
|---|---|---|
| 1 input |
string | name of Excel file name It must be an Excel file in Open Office format, e.g. with file type .xlsx, .xlsm, .xlst.
|
Return value
| Type | Description |
|---|---|
| set | Table names List of all table names. |
Examples
sheets[] = excel list sheets( "Examples\Football Membership List.xlsx" );
echo("The sheets are: ", sheets[] ); Output
The sheets are: {'Tabelle1'}