Microsoft Excel .XLS, .XLSX files contain data and retain some cell formatting in Strater. Some information, such as formulas, is ignored. Excel files can preserve all formatting information available in the Golden Software worksheet.
When creating a table from an Excel file with the File | Open or File | Open Multiple Data Files command, the table name depends on the number of sheets in the Excel file. When an Excel file contains only one sheet, the table is named after the Excel file. When the Excel file contains multiple sheets, the table is named after the specific sheet used to create the table.
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 files are Microsoft Excel 2007/2010 XML spreadsheets. Worksheet cell data and 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 files are Microsoft Excel 2007/2010 XML spreadsheets. XLSM files can contain macros and VBA scripts. Worksheet cell data and cell formatting are retained with this format. Other types of information, such as formulas, are ignored.
Excel .XLSM format files are not saved in Strater.
A file can be saved in an Excel format from Strater worksheet, but only one worksheet can be saved with the File | Export Data | Worksheet command. Strater 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 Strater 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.
To save multiple worksheet views to a new XLSX file, click the File | Export Data | Multi-Sheet XLSX command. You can select which sheets should be saved to a new workbook using this command.
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, Strater substitutes a reasonable representation so the value displayed in the cell looks similar to what was displayed in Excel.
Import Options Dialog
See Excel XLS Import Options Dialog and Excel XLSX Import Options Dialog
Export Options
See Excel Export Options Dialog.
See Also