I cannot seem to write the next row in excel even with a counter variable.
Could someone please review my general process and help me understand why I am overwriting row 1 and not iterating to the next blank row?
Here is my process
- Excel application scope > Read range to read a workbook
- Create an output data table
- For each row in the data table I assign variable for the rows I need to extract
- I think use an excel application scope within the for each row in data table activity to write the values to a new excel file
Can you check idx variable in details? Is it set at ForEachRow or variable panel? etc.
idx = int32 and is applied to the entire project. There is no default value.
Did you set the idx at Index property of ForEachRow activity or increment at other place?
Instead of Idx variable, Declare a variable in Index property of For Each row activity
Index will start with 0 so you can place IndexVariable+2
Hope this may help you
A small change would help you resolve this
Provided you have only the headers in that new excel sheet SENDER
In your write cell activity mention like this
If the datatable itself has only column or exactly the same column structure then try with APPEND RANGE activity in Israel of write cell
Your solution worked for me.
I appreciate your support on this forum. I have learned a lot from your suggestions on other posts!