Opening and saving files: Text *.zip archives

GS-Calc can now both load and save multiple text files in one zip file. The corresponding "Files of Type" filter name in the "(File) Open" dialog box is:

Text | Text Archive (*.txt;*.csv;*.tsv;*.tab;*.zip)

To save such a zip for the first time using "Save As", you just need to select this filter and enter both the file name and the ".zip" extension.

The advantages of this functionality include:

To open a *.zip file containing a number of text files

Use the File > Open command and choose Text | Text Archive from the File of type list.

Text *.zip archives must contain text files with the *.txt, *.csv, *.tsv, *.tab extensions (optionally in zip's subfolders which will be retained in the imported workbook)

The text file options (separators, encoding, parsing data, formatting etc.) are specified as follows:

The *.xml files must use the following construction:

<?xml version="1.0" encoding="UTF-8"?>

    separator="tab"		// comma | tab | point | semicolon | space | any char.
    quoting-symbol="&quot;"	// any char.

    escape-symbol="&quot;"	// any char.

    fixed-width=""		// 10 | 20,40,30

    formula-conversion="none"	// none | 3.x-6.x | 7.x-16.x

    text-to-numbers="true"		// e.g. "123.45" -> 123.45

    text-to-formatted-numbers="true"    // e.g. "($123.45)" -> 123.45

    text-to-dates="false"		// "6/1/2017" -> a serial date number

    keep-styles="false"		// after parsing a formatted date/number retain its style

    encoding="utf-8"		// utf-8 | utf-16 | ansi

    iso-code-page="Default Ansi code page"/>
				// a code page name as in the "Open Text File" dialog box
				// "Default ANSI code page" ... "ISO 8859-15 Latin 9"

If a given text file is to be opened entirely as text (with no numbers and formulas parsing), all worksheet columns created from that file are automatically formatted using the "Text" style. To delete the "Text" file from a given column, click its header and either press Del then "Formatting" or choose the "Default style" on the formatting toolbar.

To save a text *.zip archive file contaning all worksheets:

Use the File > Save As command, choose Text | Text Archive from the File of type list and after specifying the file name, add the ".zip" extension to it.

The File > Save As command causes displaying the Save Text File dialog box to let you specify the text file options. Subsequent File > Save commands reuses these settings, skipping this dialog box.

Text *.zip archives are saved with one [zip-archive-name].xml file in this zip archive with text file options for all included text files.

To resize columns in the opened text file automatically

Select either the Auto-fit column widths checkbox in the Open Text File dialog boc on in the Settings > Options > General dialog box.
(See Settings)

To resize columns in the opened text file manually

Related Topics

GS-Calc *.gsc and ODF *.ods files
Excel (*.xlsx, *.xml, *.xls) files
PDF files
Text files (*.csv, *.txt, *.tab ...)
Text *.zip archives
dBase/Clipper/FoxPro files
MySQL (*.sql) files
SQlite (*.db) files