1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
| Quintiq file version 2.0
| #parent: #root
| StaticMethod FillCells (
| String rowName,
| NamedValueTree rowTree,
| constcontent GeneralExcelImportAndExportDataRows rows,
| NamedValueTree cellTree,
| constcontent GeneralExcelImportAndExportDataCells cells
| )
| {
| TextBody:
| [*
| // rislai Jun-22-2024 (created)
| rowHandel := rowTree.GetHandle( rowName );
| try{
| rowIndex := rowTree.Root().Child( rowHandel ).GetValueAsNumber();
| row := rows.Element( rowIndex );
|
| temp_cells := selectsortedset( row,GeneralExcelImportAndExportDataCell,cell,true,cell.GeneralExcelImportAndExportDataColumn().ColumnIndex() );
| for( i := 0 ; i<temp_cells.Size();i++ ){
| cell := temp_cells.Element( i );
| tempHandle := cellTree.GetHandle( cell.GeneralExcelImportAndExportDataColumn().Name() );
|
| cells.Add( cell );
| cellTree.Root().AddChild( tempHandle,cells.Size() - 1 );
|
| }
| }onerror{}
| *]
| }
|
|
