4. Overview Excel Files

BIFF (Binary Interchange File Format) is the data format for the Microsoft Excel spreadsheet program. BIFF files normally carry the file name extension .xls. UniPlot can import Excel Versions 2.1 to 12.0 (Excel 2007). Check the user manual of the program you created your data with to see if it can write BIFF files (Excel files). It is easier for UniPlot to import Excel files than ASCII files.

The standard file name extension of Excel 2007 files is .xlsx. Excel 2007 binary format (.xlsb) can only be read.

	Reading Excel Files
excel_close	excel_close closes an Excel document opened with excel_open or excel_create.
excel_get_sheetnames	excel_get_sheetnames returns a string vector with the sheet names of an Excel file.
excel_open	excel_open opens an Excel file for reading.
excel_sheet_close	excel_sheet_close closes a sheet and frees all memory associated with the sheet object.
excel_sheet_get_row_num	excel_sheet_get_row_num returns a real data matrix with the values of a section of a Excel sheet.
excel_sheet_get_row_str	excel_sheet_get_row_str returns a string data matrix with the values of a section of an Excel sheet.
excel_sheet_get_row_style	excel_sheet_get_row_style returns a real data matrix with the style indizes of an Excel 2007 sheet .xlsx. For Excel 2003 and older Excel versions the function returns a matrix with all elements set to 1.
excel_sheet_get_row_type	excel_sheet_get_row_type returns a real matrix with the data types of a section of an Excel sheet.
excel_sheet_get_row_type2	excel_sheet_get_row_type2 returns a real matrix with the data types of a section of an Excel sheet.
excel_sheet_get_rows	excel_sheet_get_rows reads the specified number of rows starting at the current position. The current position is updated by the number of rows read. To fetch the data use excel_sheet_get_row_num, excel_sheet_get_row_str and excel_sheet_get_row_str.
excel_sheet_get_size	excel_sheet_get_size returns the number of rows and columns of an Excel sheet.
excel_sheet_open	excel_sheet_open opens an Excel sheet.

	Writing Excel Files
excel_close	excel_close closes an Excel document opened with excel_open or excel_create.
excel_create	excel_create creates a Excel file in the Biff 12 format (Excel 2007 or newer with the extension .xlsx).
excel_get_style_index	excel_get_style_index returns the index of cell style.
excel_get_style_map	excel_get_style_map returns a map with style names.
excel_sheet_close	excel_sheet_close closes a sheet and frees all memory associated with the sheet object.
excel_sheet_create	excel_sheet_create creates a new Excel sheet.
excel_sheet_put_rows	excel_sheet_put_rows writes data starting at the current position to an Excel sheet in the Biff 12 format (Excel 2007, Extension .xlsx).

	Excel Files
IsFileExcel	IsFileExcel checks if the given file is an Excel file (.xls, .xlsx, …).
IsFileExcelUTX	IsFileExcelUTX checks if the given file is an Excel file (.XLS).
ExcelGetSheetNames	ExcelGetSheetNames returns the sheet names of an Excel 5.0 file or higher.
ExcelRead	The ExcelRead function reads MS-Excel formatted files.
ExcelRead2	The ExcelRead2 function reads MS-Excel formatted files.
ExcelRead3	ExcelRead3 reads MS-Excel files (.xls).
ExcelWrite	The ExcelWrite function saves data in an Excel file format.
ExcelWriteEx	The ExcelWriteEx function saves data in an Excel file in the XLSX format.

See also

Overview Files, Overview UniPlot Data Files, Overview Binary and Text Files, UniScript Functions Overview

_id-1062068