yypsybs
2023-09-08 be9f3270a50b9f5318beff37bd4d70fa5632657a
_Main/BL/Type_MatAttrSettingAndPlanStrategyInputSource/Method_parseTable.qbl
@@ -1,15 +1,16 @@
Quintiq file version 2.0
#parent: #root
Method parseTable
Method ParseTable
{
  TextBody:
  [*
    // yypsybs Jul-1-2023 (created)
    tableGroupHandle := TableGroupHandle::Create( this.fileName() );
    tableGroupHandle := XLS::LoadTableGroupFromBinaryData( this.bytes().AsBinaryData(), tableGroupHandle, true, this.isXlsx() );
    tableGroupHandle := TableGroupHandle::Create( this.FileName() );
    tableGroupHandle := XLS::LoadTableGroupFromBinaryData( BinaryData::FromBase64EncodedString( this.Base64Str() ), tableGroupHandle, true, this.IsXlsx() );
    sheets := tableGroupHandle.TableNames();
    
    traverse ( sheets, Elements, sheetName, sheetName = "MatAttrSettingAndPlanningStrategy" ) {
    traverse ( sheets, Elements, sheetName, sheetName = "MatAttrSettingAndPlanStrategy" ) {
      tableHandle := tableGroupHandle.Table( sheetName );
      tableXML := TableHandle::ExportXML( tableHandle );
      MatAttrSettingAndPlanStrategyDataTable::XMLImportMatAttrSettingAndPlanStrategyDataTableXMLHeaders(  tableXML );