Opening and saving Excel *.xls workbooks |
To save a database (or the current table) as an Excel *.xls workbook
Use the File > Save Database Copy As command and choose the Excel *.xls format from the File of type list.
In the Save Excel XLS File dialog box specify the following options:
If this option is selected, the first row of each saved Excel sheet will contain the corresponding record field names that will be reused if you open the workbook back in GS-Base.
If this option is selected and if the number of records in one or more of the saved tables exceeds the 65K Excel *.xls limit, GS-Base will split such tables and save multiple *.xls workbooks:
file_name.xls
file_name(1).xls
file_name(2).xls
...
file_name(n).xls
If there are any previously saved files with larger indices (e.g. file_name(n+1).xls and on), they will be deleted.
If you open the file_name.xls file again in GS-Base, the remaining partial workbooks will be automatically (internally)
loaded to form the original GS-Base tables.
If this option is selected and if you created folders in the GS-Base database explorer pane for some tables,
the Excel sheet names will be formed as whole such table tree paths which will enable GS-Base to re-created the original
tree folder structure when you open the saved Excel *.xls workbook back in GS-Base.
As the "\" path separator can not be used in Excel names, it's replaced with ">".
The contents of the above fields will be saved to the
file_name.gsb-bin.zipfile. You need to keep the saved Excel *.xls workbook(s) and that file together. The corresponding sheet cells in the *.xls workbook will contain links to objects in that zip. To access them, unzip it to the
file_name.gsb-bin
folder. Clicking a sheet cell formatted as a hyperlink will open the field contents (e.g. text, image or a folder with multiple images etc.). You can edit/update/delete them and distribute your file_name.xls workbook either with the unzipped or zipped folder:
file_name.gsb-bin
The description include the object names, number, total field size and recent modification date.
Note: After saving a document in a different format you may need to use the File > Reload command to refresh the view.
To open an Excel *.xls workbook
Use the File > Open command and choose the Excel *.xls format from the File of type list.
In the Open Excel XLS File dialog box specify the following options:
If this option is selected, GS-Base will use text labels from the first row of each saved Excel sheet as the corresponding record field names. Otherwise GS-Base will generate automatic names field1, field2,..., fieldn.
See the mirror option described above in the "Save" dialog box.
See the mirror option described above in the "Save" dialog box.
Related Topics