I have an excel sheet. Which has around 150 columns.
I want to add new row in this excel. I am adding data using “Add Data Row” Activity
But The Problem is
The data is getting added in starting columns ( like into column1, column2) But I want to add the data in specific columns ( like into column5, column140 )
Is there solution where we can add data using column name.
I know one bad method which is not suitable here. this only ok if we have only few number of columns.
Suppose if we need to value only in last one column ? But in this method we have to insert value in all columns.
@Tech_Guru
Lets assume you can Work on Datatable Base.
With datatablevar.newrow you will get an empty datarow within the structure of the Datatable.
Now you can Set the column values partly on the columns of your choice. Finally you add the row to the Datatable by using add datarow Activity and using the datarow instead of the the datarowarray
As you know write range also need a datatable to insert.
And to make data table we need to use add data row activity.
Yes we can skip starting columns using write range. But we need to enter details into more than 50 columns. And all of them not nearby. They have another column between them.