For Excel export files, you can only define whether comments and column headers are to exported and specify a substitution for NULL values.
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