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.

id-1062068