How to append range of data in a new Excel Workbook in a single sheet in each iteration.
My used case requires filtering data in one excel application and paste it into another. The Filter parameter is based on date and the result is range of data in each iteration. I have been able to figure out the filtration and export part but every time I import, the old range of data copied in the destination excel sheet gets replaced by the new range. I found counter tool from the tool box as a possible solution to set the cell values for next iteration, but I have not been able to figure out how to make it work for the range of data basically to append in the same worksheet not replacing what I already have.
Does anybody know how to accomplish this?
Accepted Solution
Coforge BPM
US
Grona,
I was able to achieve this by using numericExpression, WorksheetGetUsedRange method and ImportData method.
First I got the rowCount and used the numericExpression to add rowCounts of two excel workbook sheets and then used
the total rowCount as a rowStart in ImportData method. This helped me to set a newRow to Import range in each iteration.
Thanks!
Accepted Solution
Coforge BPM
US
Grona,
I was able to achieve this by using numericExpression, WorksheetGetUsedRange method and ImportData method.
First I got the rowCount and used the numericExpression to add rowCounts of two excel workbook sheets and then used
the total rowCount as a rowStart in ImportData method. This helped me to set a newRow to Import range in each iteration.
Thanks!