Defining Excel Export Options

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Exporting Database Data >

Defining Excel Export Options

For Excel export files, you can only define whether comments and column headers are to exported and specify a substitution for NULL values.

tab_exp-opt-excel

 

To define the extended options for Excel export files:

1.Activate the Include comments check box to include a comment in the Excel code of the exported Excel file that shows the SQL query used to select the data, as well as a list containing one item for each column header in the database table.
2.If the Excel table generated is to include the database column names, activate the Include column headers check box.
3.Select from the Substitution for NULL-values drop-down list or type in the string that should appear in the exported Excel file when there is a NULL value in the data being exported. You can also type in a value that is not contained in the drop-down list.

© 2019 Altova GmbH