Excel エクスポートオプションの定義

www.altova.com このトピックを印刷 前のページ 1つ上のレベル 次のページ

ホーム >  データベースデータのエクスポート >

Excel エクスポートオプションの定義

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 チェックボックス 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