Opening and Saving Excel Files

1. Saving Excel xlsx Files

Use File → Save As and choose Excel (*.xlsx, *.xml) from the File of type list.

Note:

As of version 20.0, table references defined inside worksheets are not yet supported. Formulas such as:

=Meals[[#This Row],[Budget]] - Meals[[#This Row],[Actual]]

are loaded and saved with their values, but they are not recalculated.

1.1 Save Options (Save Excel XLSX File Dialog)

Excel split options

2. Opening Excel xlsx Files

Use File → Open and choose Excel (*.xlsx) from the File of type list.

2.1 Open Options (Open Excel XLSX File Dialog)

The options available in this dialog box enable you to merge Excel sheets and workbooks split previously by GS-Calc. You can also load a given file as is, which also includes XLSX files with up to 32M rows.

Excel merge options

3. Related Topics

GS-Calc *.gsc and ODF *.ods files
PDF files
Text files (*.csv, *.txt, *.tab ...)
Text *.zip archives
GS-Base (*.gsb) files
dBase/Clipper/FoxPro files
SQLite (*.db) files
MySQL (*.sql) files