Select the File Format to use when exporting in
the Excel Data Export Options dialog.
Strater can export Excel .XLS and .XLSX files by clicking the File | Export Data | Worksheet command. The Export command exports only a single sheet .XLS or .XLSX file. To export multiple sheets, click the File | Export Data | Multi-Sheet XLSX command.
The Excel Data Export Options dialog allows you to specify if the Excel file will be written in Excel 97 or Excel 95 format.
Select the File Format
to use when exporting in
the Excel Data
Export Options dialog.
Files can be saved in either Excel 97 (BIFF 8) or Excel 95 (BIFF 5) formats.
A file can be saved in an Excel format from the Strater worksheet, but only one worksheet can be saved. 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. Use the File | Export Data | Multi-Sheet XLSX command to create a multiple sheet XLSX file.
See Also
Excel XLS Import Options Dialog