Excel Data File Description

Microsoft Excel .XLS, .XLSX, and .XLSM files contain data and retain some cell formatting in . Some information, such as formulas, is ignored. Excel files can preserve all formatting information available in the Golden Software worksheet.

supports the import of .XLS, .XLSX, and .XLSM Excel files. supports the export of .XLS and .XLSX files.

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 worksheet, but only one worksheet can be saved. does not allow for saving multiple worksheets in a single Excel document. If a multi-worksheet Excel file is opened and saved as an .XLS or .XLSX file from the worksheet, be aware that only the single worksheet is saved in the document. If the existing file is overwritten, all the unused worksheets are destroyed. In this case, a warning message is issued. The message reads: Saving this worksheet will destroy all but one of the sheets in the existing *.xls, *.xlsx file. To overwrite the file, click OK. To choose a different file name, click Cancel.

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, substitutes a reasonable representation so the value displayed in the cell will look similar to what was displayed in Excel.

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

Data File Formats

Excel Export Options Dialog

Excel XLS Import Options Dialog

Excel XLSX Import Options Dialog

Export Automation Options String

File Format Chart

Import Automation Options String

Opening Worksheet Files

Saving Worksheet Files

Special XLS Characters