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