Excel 97-2003 (.xls) Help
Description
Excel 97-2003 file refers to the file format used by Microsoft Excel versions from 1997 to 2003, typically having the .xls extension. This format is a binary file format known as BIFF (Binary Interchange File Format) and was the standard for Excel spreadsheets before the introduction of the newer format in Excel 2007. This version of Excel support 65,536 rows and 256 columns per sheet, as well as various formatting options, formulas, charts, pivot tables, and conditional formatting. This older format included password protection and encryption which has since been improved in the newer version. The Excel 97-2003 .xls remains in uses in environments where legacy systems are in operation or where compatibility with older versions of Excel is necessary.
Upload Settings for Excel97
Click on Upload Settings button to start configuring the import settings for your Excel97 file.
Sheet Name
If your file contains multiple sheets, you can specify which sheet to use by entering the name of the sheet in this field. If you leave this field empty, the first sheet will be used. If you want to export all sheets, you have to enter each sheet name one at a time and export them separately.
Starting Row
Defines the row number where the data reading should begin. Use 0 for the first row.
Last Row
Defines the last row number to read from the sheet.
Use -1 to read until the last available row in the sheet.
Starting Column
Defines the column index where reading should begin. Use 0 for the first column.
Field Names In First Row
If enabled, the system will use the values from the first row of the sheet as the field names (column headers).
If this is disabled, the fields will be named generically as A, B, C, etc., based on their column position.
Skip Empty Rows
If enabled, rows that are completely empty will be ignored during import.
Evaluate Expressions
If enabled, the system will evaluate any formulas present in the Excel cells and import their calculated results.
Use Sheet Column Count
Determines how the number of fields (columns) for each row is calculated:
- If enabled, the field count will be based on the total number of columns in the sheet. Each row will be padded with blank values or trimmed as needed to match the sheet's column count.
- If disabled (default), each row will use its own number of fields based on the number of populated cells in that row. This means rows may contain a different number of fields.
Example: If some rows have missing cells at the end, disabling this option means those rows will have fewer fields. Enabling it will keep the field count consistent across all rows, filling missing cells with blank values.
Once you have configured the settings, click Save Changes to apply them.