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