Excel Data File Description
Microsoft Excel .XLS, .XLSX, and .XLSM files contain data and retain some cell formatting in
Excel .XLS
Excel .XLS files are Microsoft Excel documents. Worksheet cell data and some cell formatting are retained with this format. Other types of information, such as formulas, are ignored.
Excel .XLS format files can preserve all formatting information available in the Golden Software worksheet. This format has a 65,536-row limit and a 256-column limit in Excel 97 and greater. Therefore, this format cannot be used to store very large data sets.
Excel .XLSX
Excel .XLSX files are Microsoft Excel 2007 XML spreadsheets. Worksheet cell data and some cell formatting are retained with this format. Other types of information, such as formulas, are ignored.
Excel .XLSX format files can preserve all formatting information available in the Golden Software worksheet. This format has a 1,048,576-row limit and a 16,384-column limit in Excel 2007 and greater.
Excel .XLSM
Excel .XLSM files are Microsoft Excel 2007/2010 XML spreadsheets. XLSM files can contain macros and VBA scripts. Worksheet cell data and some cell formatting are retained with this format. Other types of information, such as formulas, are ignored.
Excel .XLSM format files are not saved in
Use Caution when Saving Excel Files!
A file can be saved in an Excel format from
Special Characters Used in Excel Files
There are a number of special characters that can be contained in an Excel file that the worksheet cannot handle in the same way as Excel. For these characters,
Font Color in Excel Files
Font color is maintained when opening XLSX and XLSM files in the worksheet. However XLS files are opened with black font, regardless of font color in the XLS file.
Sheet Names
The sheet name of an Excel file is listed in the gridding report, cross validation report, and data statistics report.
See Also
Excel XLS Import Options Dialog
Excel XLSX Import Options Dialog
Export Automation Options String