ListExcelSheets()
Summary
Lists all the worksheets in an Excel workbook (.xls) file.
Changes
Added to Version 5.0.
Syntax
sheetnames_array = ListExcelSheets(string excel_file)
| Argument | Contents |
|---|---|
| excel_file | Name of the Excel workbook (.xls) file |
Returns
An array of the names of the worksheets in the Excel workbook (.xls) file.
Example
excel_file = ChooseFile({{"Excel Workbook (*.xls)", "*.xls"}},
"Choose an Excel Workbook", )
ShowArray(ListExcelSheets(excel_file ))Error Codes
| Error Type | Meaning |
|---|---|
| NotFound | excel_file was not found |
See Also
| Function | Summary |
|---|---|
| ExportExcel() | Reads an Excel workbook (.xls) file and exports one of its sheets to a new table |
| OpenTable() | Opens a table from a file on disk and creates a view |