Quintiq file version 2.0
|
#parent: #root
|
StaticMethod GetPPATemplate () as BinaryValue
|
{
|
TextBody:
|
[*
|
// Akari May-18-2024 (created)
|
// rislai Jan-19-2024 (created)
|
sheetName := "PPA上传模板";
|
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>";
|
|
actualDate := Date::ActualDate();
|
|
for( i := 1 ; i <= 12 ; i++ ){
|
xmlTemplate := xmlTemplate + "<column><name>" + Date::Construct( actualDate.Year(),i,1 ).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;
|
*]
|
}
|
