2.4 Export XML data to Microsoft Excel
For exporting XML data from a Swift Document to Microsoft Excel (XLS)
format, use the exportXLS action as follows: This command
exports all tables and queries in the Swift Document ‘Data.xdb’
to an Excel spreadsheet ‘Data.xls’.
|
You can specify specific tables and/or queries to export by listing them out on the command line.
|
Please note that if a query has the same name as an existing table, the query will be exported. To have the table of the same name to be exported instead, please prepend the table name with a ^ as follows:
|
By default, existing output files will not be overwritten. To overwrite the output file (‘Data.xls’), use the -w option:
|