ExportExcel()
Summary
Reads an Excel workbook (.xls) file and exports one of its sheets to a new table
Changes
Added to Version 5.0.
Syntax
ExportExcel(string excel_file, string class, string new_file, array options)
| Argument | Contents |
|---|---|
| excel_file | Name of the Excel workbook (.xls) file |
| class | Class of new table to create (dBASE, FFA, FFB, CSV, or EXCEL) |
| new_file | Name of the new table file |
| Option | Type | Contents |
|---|---|---|
| Sheet | String | The name of the worksheet in the Excel workbook (.xls) file |
Notes
If the Sheet option is omitted, Maptitude exports the first worksheet.
Example
// Opens an Excel workbook, exports the first worksheet, and creates a dataview
excel_file = ChooseFile({{"Excel Workbook (*.xls)", "*.xls"}},
"Choose an Excel Workbook", )
out_file = "c:\\temp\\temp.bin"
ExportExcel(excel_file, "FFB", out_file, )
OpenTable("Temp", "FFB", {out_file, })
CreateEditor("Temp", "Temp|", , )Error Codes
| Error Type | Meaning |
|---|---|
| NotFound | excel_file was not found |
See Also
| Function | Summary |
|---|---|
| ListExcelSheets() | Lists all the worksheets in an Excel workbook (.xls, .XLSX) file |
| OpenTable() | Opens a table from a file on disk and creates a view |
| ExportSheetsToExcelX() | Export views to an Excel file |