Excel Files

Microsoft Excel .XLS, .XLSX files contain data and retain some cell formatting in Grapher. Some information, such as formulas, is ignored. Excel files can preserve all formatting information available in the Golden Software worksheet. Grapher can import multiple sheets from an Excel file simultaneously.

Grapher supports the import of .XLS, .XLSX, and .XLSM Excel files. Grapher 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/2010 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 Grapher.

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.

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.

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, Grapher substitutes a reasonable representation so the value displayed in the cell looks 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.

Retaining Excel Information

To save all the formatting, formulas, and worksheets in an .XLS, .XLSX file, you can use Excel directly in Grapher. Use File | Open Excel to utilize all of Excel's features, save multi-sheet files, and create graphs in Grapher.

Import Options Dialog

See Excel Import Options Dialog

Import Automation Options

See Import Automation Options String

Export Options

See Excel Export Options Dialog

Export Automation Options

See Export Automation Options

See Also

Data File Formats

Opening Worksheet Files

Saving Worksheet Files

Special XLS Characters