Hii,
Below is the error tab
Below is the code
Excel Sheet
How to sole this
Thanks and Regards,
Supriya
Hii,
Below is the error tab
Below is the code
Excel Sheet
How to sole this
Thanks and Regards,
Supriya
Hi,
Where is the datatable test coming from?
are you just declaring it or reading it from somewhere
So thats the error, You need to declare the data table with the number of columns that you are inserting, Or else you will get a null reference exception. Just use build data table with those number of column names.(before doing the add datarow)
Thankyou.
one more query every time in a loop if I add datarow it will add to a new row?
How to updatee a single column of an excel in a loop
Thanks and Regards,
Supriya
Yes, you can use the add data column activity to update a single column.
Thankyou:smiley:
Happy learning
Hii,
I m using for each row so for the first row I have to update a column of that row itself in the excel
but using add datarow it is entering the value to next row of that column
Thanks and Regards,
Supriya
WHile using for each row, If you want to input value to that column do → row(“Columnname”)=“Value”
Hii
I have a if condition so if that is true then for each row starts where i have to update an excel say test but if the if condition is false also i have to enter the data in same excel test
so do I have to use 2 write range because if I use write range in for each then other condition is not satisfied…
Thanks and Regards,
Supriya
dont use write range in that. Use assign and atlast after the foreach put write range
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.