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 チェックボックス 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 列名, activate the Include column headers チェックボックス.|
|3.||Select from the Substitution for NULL-values ドロップダウンリスト 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 ドロップダウンリスト.|
(C) 2019 Altova GmbH