![]() ![]() I have attached the screenshot of the excel which exactly looks like the one i am working. Make sure the copy and paste areas don't overlap unless they are the same size and shape. So sometimes my insert option works and sometimes its not working and I am getting the below errorĮxception : Failed to delete selection: This selection isn't valid. The challenge here is between table1 and table 2 there is a comment section row which is a merged row. using activate worksheet>Select (Specifying cell refence as 27:37)> Insert (tried using "Shift Up" & Entire Row"> write collection (specifying cell reference as A8" I am trying to select the number of rows to insert extra rows. Row diff is 20, i need to write collection with 30 rows so i have to insert ten extra rows. For eg: The starting cell of table1 & 2 is 8 & 28. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |