I’m trying to move collumns from one sheet to another. Only solution I have found to this is the read range followed by write range feature but it seems to be very slow. Is there any other solution to this?
Hi @Atharv_Madne ,
You could try reading the entire datatable and select those columns you want before writing it to the other sheet like so:
Dt.DefaultView().ToTable(False, "Column1", "Column2"...)
Would that help?
Have a look on the thread
Its the writing that takes time not the reading
This thread is for moving between the same excel. I’m trying to move it between two different excels
You can try with filter Datatable activity
- Use the Read Range activity
- Filter Datatable and in filter wizard goto Output column and add the column you want by clicking plus in the wizard and save them in another DT (It will store only those columns which you gave)
- And Now you can use write range to write those column
Your Question is to move column from one sheet to another for that above post will be the solution.
You have new query here?
My apologies I meant between two completely different excels. Not two different sheets
The write range feature is taking very long to execute
How many rows do you have in the excel? @Atharv_Madne
And also can you elaborate a bit more about your task? @Atharv_Madne
The number of rows is undefined as it is a monthly process and could vary so I need to select the entire collumn
How much time it is taking to write the data?
How many line do you have in the excel?
Look into the thread
Okay then you can try with this
Hi @Atharv_Madne ,
We would need you provide Details of Approximately How many Rows and Columns of Data are we dealing with for Each Process Run.
Also what is the time taken for Completion of Process When using the Write Range for the current numbers of Rows and Column of Data.
Based on this we can interpret and decide on a Suggestion.