Import and Export

Summary

Starting with version 1.2, it is possible to import / export data from QuSheet using the clipboard and XML.

Clipboard Copy/Paste is possible from all Display Table tab pages. Cells from the tables are copied by row and column, using whatever columns are displayed at the time. Cells are pasted in in the same way, but with the necessary cross-referencing and validation taking place.

It is possible to use the clipboard to easily switch field contents around by doing a Copy, then moving or removing a Column, then Paste.

If pasting data from the clipboard results in an invalid value for any particular column then the whole paste operation is aborted.

An XML interface is supported by QuSheet using the Import/Export menu entries under File.

Exporting must precede Importing so that QuSheet can write out a Schema Definition file first. It is this file which governs the structure of the data which will be exported and imported by QuSheet (file name project.data.XSD).

Microsoft Excel knows these XSD files as Map files. With these map files it is possible to set up tables within Excels spreadsheets to hold the data which is imported or exported from QuSheet.

A: It is best to format Excel tables as Text to stop Excel converting Dates back into numbers when you export/import.

Data is imported / exported using the file project.data.XML. Again, QuSheet will need to validate some of this data and cross-reference. Should any part of the validation fail the whole Importing operation is aborted.

Both the Past and the Import operations support an Add (at end) function and a Replace. Note that when Importing, the only tables Replaced are the ones which have new data in the import file.

Starting with version 1.2, it is possible to import / export data from QuSheet using the clipboard and XML.

It is possible to use the clipboard to easily switch field contents around by doing a Copy, then moving or removing a Column, then Paste.

If pasting data from the clipboard results in an invalid value for any particular column then the whole paste operation is aborted.

An XML interface is supported by QuSheet using the Import/Export menu entries under File.

Microsoft Excel knows these XSD files as Map files. With these map files it is possible to set up tables within Excels spreadsheets to hold the data which is imported or exported from QuSheet.

A: It is best to format Excel tables as Text to stop Excel converting Dates back into numbers when you export/import.

Both the Past and the Import operations support an Add (at end) function and a Replace. Note that when Importing, the only tables Replaced are the ones which have new data in the import file.