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