![]() If collection2 has got less rows and if I want to insert rows i am actually getting the number of rows to add and trying to select the cell and using Insert action. Logic used: if collection1 rows are empty no need to write values, if collection1 has values then get number of rows to paste & check whether need to insert additional rows.Ĩ. saving the row difference between table 1 & Table 2 in a data item (RowDiff)ħ. with these counters i can get the row difference. Looping the collection 2 to get the row number of Table 1 & Table 2 so I have the counter values which specifies the exact starting row number for table 1 & table 2. Get Worksheet has collection (sheet2)-Collection 2Ħ. So I have got 36 collections to paste it in 36 tables in Sheet2.ĥ. Filter for specific criteria and save it to a final Collection. Get worksheet has collection (Sheet1) - Collection1Ĥ. So i am using the action select and insert.ģ. In certain cases, during run time I have to insert additional rows to the tables in Sheet2. In each table I have to paste values( which I filtered from Sheet1). The second sheet(Sheet2) has 36 different sub tables with diff number of rows and column. ![]() ![]() I have to filter for specific record from the Sheet1, check for duplicates and I have to paste in sheet2. I am trying to insert dynamic rows to excel.
0 Comments
Leave a Reply. |