Quintiq file version 2.0
|
#parent: #root
|
StaticMethod GetIDSTemplate (
|
Number dateNumber
|
) as BinaryValue
|
{
|
Description: 'dateNumber: 设置导出日期的长度'
|
TextBody:
|
[*
|
// Akari May-18-2024 (created)
|
// Akari May-18-2024 (created)
|
// rislai Jan-19-2024 (created)
|
sheetName := "IDS上传模板";
|
xmlTemplate := '<?xml version="1.0" encoding="UTF-16"?><table><name>'+ sheetName +'</name>';
|
|
xmlTemplate := xmlTemplate + "<column><name>产地</name><type>String</type>";
|
// xmlTemplate := xmlTemplate + '<cell value=""/>';
|
xmlTemplate := xmlTemplate + "</column>";
|
|
xmlTemplate := xmlTemplate + "<column><name>车型</name><type>String</type>";
|
// xmlTemplate := xmlTemplate + '<cell value=""/>';
|
xmlTemplate := xmlTemplate + "</column>";
|
|
xmlTemplate := xmlTemplate + "<column><name>发动机号</name><type>String</type>";
|
// xmlTemplate := xmlTemplate + '<cell value=""/>';
|
xmlTemplate := xmlTemplate + "</column>";
|
|
actualDate := Date::ActualDate();
|
|
for( i := 0 ; i < dateNumber ; i++ ){
|
xmlTemplate := xmlTemplate + "<column><name>" + (actualDate + i).Format( "Y/M/D" ) + "</name><type>Number</type>";
|
// xmlTemplate := xmlTemplate + '<cell value=""/>';
|
xmlTemplate := xmlTemplate + "</column>";
|
}
|
|
xmlTemplate := xmlTemplate + "</table>";
|
|
tableHandle := TableHandle::ImportXML( BinaryValue::Construct( xmlTemplate ) );
|
XLS::SaveTable( tableHandle, OS::TempPath() + "template.xlsx" );
|
file := OSFile::Construct();
|
file.Open( OS::TempPath() + "template.xlsx", "Read", true );
|
data := file.ReadBinary();
|
return data;
|
*]
|
}
|
