Function Names
excel list pivot tablesDescription
This function identifies Excel pivot tables inside the Microsoft Excel workbook (Open Office format) and returns them in a set containing strings.
All pivot table names are returned with preceding sheet names separated wiht a slash '/'. They can be used directly to specify the right pivot
tables in the table load excel file() function. The reason is that the same pivot table name can be used repeatedly ocross different sheets.
Example: Pivot table "PivotTable1" in sheet "Sheet1" is returned as "Sheet1/PivotTable1".
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 | Pivot table names List of all pivot table names. |
Examples
sheets[] = excel list sheets( "Examples\Football Membership List.xlsx" );
echo("The sheets are: ", sheets[] ); Output
The sheets are: {'Tabelle1'}