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