Excel .XLS Export Options Dialog

Grapher can export .XLS files. 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.

File Format

Files can be saved in either Excel 97 (BIFF 8) or Excel 95 (BIFF 5) formats.

Use Caution when Saving Excel Files!

Use the File | Save To Multi-Sheet Excel File command to save multiple worksheets in a single Excel document. Note that this command only saves Excel files in the XLSX format.

A file can be saved in an Excel format from Grapher worksheet, but only one worksheet can be saved when using the File | Save or File | Save As command. If a multi-worksheet Excel file is opened and saved as an .XLS or .XLSX file from the Grapher 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.

See Also

Excel Import Options Dialog

Excel Export Automation Options

Excel File Description