Hello,
I am trying to fill the Data in Excel file from second row in A Column till last used row which already filled in D Column.
I am able to get the last used cell number but without datatable not able to put the data in one go.
Ex.
Below is my worksheet Where have data in “D” column from row 2nd to 5th. I want to fill Column B also with the same range and data will be “123”.
Your Steps Could be as follows below!
Read Range the excel!
For Each Row in read Dt!
Assign
CurrentRow(“COMP_ID”) =CurrentRow(“ITEM”).ToString
Then Write range the same Dt Out side the body of the loop!
Regards
Hello,
thnx for reply. I want to update different data into Column B like below.
I have 123 data assigned into one variable (which is not data table) and same I want to fill in entire range.
Instead of Column name try to pass the variable!
CurrentRow(“COMP_ID”) =YourVar
similarly for other empty columns!
Regards
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
