The type of file to output.
"excel" - Excel file
"csv" - CSV file
●If the file type is CSV, you can set the detailed format by concatenating the following strings after "csv" with "_" as the separator.
example)
"csv"
"csv_header1"
"csv_header1_date[reporttitledateformat]"
"csv_date['%Y/%m/%d %[H+1]:00:00']"
・header1
Adds a header. The header name is created based on the field name.
・header2
Adds a header. The header name is created based on the report header.
・date[summarymaster]
The text in the time column is determined according to the ReportTitleDateFormat in the Summary Master File.
・date['%Y/%m/%d %[H+1]:00:00']
・date['@DATETIME']
The characters in the time column will be determined according to the specified format. '%Y/%m/%d You can freely specify the part %[H+1]:00:00'.
For information on the formats that can be specified, please refer to the ReportTitleDateFormat property of the Summary Master.
・locale[ja-JP]
Specify the locale. You can specify the ja-JP part freely. If not specified, the locale will follow the OS locale on which the server is running.
●If the file type is Excel, you can set the detailed format by concatenating the following strings after "excel" with "_".
example)
"excel"
"excel_date['@[%mmonth%d(%a)]']"
"excel_date['@[%mmonth%d(%a)]']_locale[ja-JP]"
"excel_date['@DATETIME.%md.[(%a)]]']_locale[de]"
・date[summarymaster]
The text in the time column is determined according to the ReportTitleDateFormat in the Summary Master File.
・date['@DATETIME']
The characters in the time column will be determined according to the specified format. You can freely specify the '@DATETIME' part.
For information on the formats that can be specified, please refer to the ReportTitleDateFormat property of the Summary Master.
・locale[ja-JP]
Specify the locale. You can specify the ja-JP part freely. If not specified, the locale will follow the OS locale on which the server is running.
When you specify a locale, if there is a report master file "layoutmaster.xls" with the locale character added to the end (e.g. "layoutmaster_ja-JP.xls"), that file will be used. You can separate report master files for each language.
|