Quintiq file version 2.0
|
#parent: #root
|
Method parseTable
|
{
|
TextBody:
|
[*
|
// yypsybs Jul-1-2023 (created)
|
tableGroupHandle := TableGroupHandle::Create( this.fileName() );
|
tableGroupHandle := XLS::LoadTableGroupFromBinaryData( this.bytes().AsBinaryData(), tableGroupHandle, true, this.isXlsx() );
|
sheets := tableGroupHandle.TableNames();
|
|
traverse ( sheets, Elements, sheetName, sheetName = "MatAttrSettingAndPlanningStrategy" ) {
|
tableHandle := tableGroupHandle.Table( sheetName );
|
tableXML := TableHandle::ExportXML( tableHandle );
|
MatAttrSettingAndPlanStrategyDataTable::XMLImportMatAttrSettingAndPlanStrategyDataTableXMLHeaders( tableXML );
|
parsedTable := MatAttrSettingAndPlanStrategyDataTable::XMLImportMatAttrSettingAndPlanStrategyDataTableXML( tableXML );
|
parsedTable.parseRows();
|
parsedTable.name( sheetName );
|
this.MatAttrSettingAndPlanStrategyDataTable( relinsert, &parsedTable );
|
}
|
*]
|
}
|
