How to iterate the excel cell to write the data in each cell. Can someone help me with the syntax for this.
- Read the excel file usinh Read Range Activity and store it as a data table in the output
- Use for each row activity to iterate through each row in the data table.
- To write you can use Write Cell activity.
Please check and let me know if it works
1 Like
What is the syntax do i need to write in cell .because I need to iterate below is the image reference
If i check the auto increment, It works right?
You can check the current row info using CurrentRow variable
The For Each Excel Row Activity doen’t produce a index variable
To make it simple, you can use a counter variable starting with 2, write cell and then increment the counter variable by 1.
Could you help me with the intailizing the code.
Please find the solution logic in the attachment. You can get the values of capital, weather and status and replace it in the write cell value parameter.
TEST2.zip (8.4 KB)
Cheers
1 Like
The code you sent is working , but when i trying to do the same its not.
Could you please share your solution or snip ? @Pushpendra_kowthavarapu
1 Like
Main.xaml (21.1 KB)
I am unable to open the file. Please share it as a zip with Project.json or let me know the issue that you are facing in detail so that I can help @Pushpendra_kowthavarapu
@Pushpendra_kowthavarapu , just checked your code. Please give the index variable that you have created in the output of for each row in the Index parameter
Cheers
1 Like
Thanks for the solution gayathri.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.