Excelmetadata
The Excelmetadata() function returns metadata from an Excel workbook. Currently, it can return an array containing the names of all worksheets in the file.
Syntax:
ExcelMetaData(Filepath, Information)- In the Quintessence Editor (Studio) using Python language, use:
Qx.Excelmetadata
ⓘ See parameter descriptions
| Filepath | The full file path of the Excel workbook. |
| Information | Specifies the type of metadata to return. Currently supported: • worksheets – returns the list of worksheet names. |
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Retrieve the names of worksheets in an Excel workbook
Formula:
return := Excelmetadata("C:\workinvoices.xlsx", "worksheets"); Result:
| List |
| Addresses |
| History |