Quintiq file version 2.0
|
#parent: #root
|
Method ReadStructure
|
{
|
TextBody:
|
[*
|
tableGroupHandle := TableGroupHandle::Create( this.Name() );
|
tableGroupHandle := XLS::LoadTableGroupFromBinaryData( this.FileBinaryValue().AsBinaryData(), tableGroupHandle, true, this.IsXLSX() );
|
sheets := tableGroupHandle.TableNames();
|
|
traverse ( sheets, Elements, sheetName ) {
|
tableHandle := tableGroupHandle.Table( sheetName );
|
tableXML := TableHandle::ExportXML( tableHandle );
|
|
// info( tableXML.AsQUILL() );
|
|
FinancialSalesReport::XMLImportFinancialSalesReportXMLHeaders( tableXML );
|
xlstable := FinancialSalesReport::XMLImportFinancialSalesReportXML( tableXML );
|
|
xlstable.SyncRows();
|
|
xlstable.Name( sheetName );
|
xlstable.IsImport( true );
|
this.FinancialSalesReport( relinsert, &xlstable );
|
|
Transaction::Transaction().Propagate( attribute( FinancialSalesColumn, Index ) );
|
|
// （导入前）给空值赋予默认值（N/A）,并且删除空行数据和数据校验
|
xlstable.IdentifyNullValues();
|
|
xlstable.ImportVerification();
|
}
|
//导入后处理数据
|
//this.AfterImport();
|
*]
|
}
|
