Update a cell in looped row

Help
,
21

It works !
Thank you! :slight_smile:

22

@aksh1yadav

Is there any way to increment like A1,B1 ,C1

23

Yes, you can iterate through each datacolumn in the datatable.

Use a for each activity and change the ArgumentType to System.Data.Datacolumn. Supply the datatable as the object. The following code would change the value of A1, B1, C1, etc for however many columns in the datatable. Make sure you paste the datatable back into excel once you are finished with the for each loop

For each col in dt1
Assign dt1.row(0).item(col.ColumnName) = "Whatever you want here"
24

Hey @RachelN

Here find an attached sample for your reference.
Increment Of Cell Character_Aksh.Yadav.xaml (6.2 KB)

image
image753×187 2.19 KB

Note - In case you will not be able to understand it. Feel free to shout :slight_smile:

Regards…!!
Aksh

1 Like
25

Thanks a lot @aksh1yadav

Now only i got the idea and output

Really Helpful… Thank you!!!