Moving collumns

[Atharv_Madne]

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?

[ashwin.ashok ((TheCodingTheory))]

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?

Kind Regards,
Ashwin A.K

[Gokul001 (Gokul Balaji)]

HI @Atharv_Madne

Have a look on the thread

Move specific column to a specifed location in an Excel sheet

Here is the reference formula for set ordinal dt.Columns(column to be moved).SetOrdinal(column number to which the column to be moved)

Regards
Gokul

[Atharv_Madne]

Its the writing that takes time not the reading

[Atharv_Madne]

This thread is for moving between the same excel. I’m trying to move it between two different excels

[Sudharsan_Ka]

HI @Atharv_Madne

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

Regards
Sudharsan

[Gokul001 (Gokul Balaji)]

@Atharv_Madne

I’m trying to move collumns from one sheet to another

Your Question is to move column from one sheet to another for that above post will be the solution.

@Atharv_Madne

This thread is for moving between the same excel.

You have new query here?

Regards
Gokul

[Atharv_Madne]

My apologies I meant between two completely different excels. Not two different sheets

[Atharv_Madne]

The write range feature is taking very long to execute

[Sudharsan_Ka]

How many rows do you have in the excel? @Atharv_Madne

[Sudharsan_Ka]

And also can you elaborate a bit more about your task? @Atharv_Madne

[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

[Gokul001 (Gokul Balaji)]

Hi @Atharv_Madne

@Atharv_Madne

write range feature is taking very long to execute

How much time it is taking to write the data?

How many line do you have in the excel?

Look into the thread

Copy selected columns from one Excel file to another

Hey, how can I copy out only the columns that are relevant to me from an existing Excel file and then paste them into a new Excel file? Sorry if the question has already been answered, but I just started using UiPath and couldn’t find an adequate solution. Thanks a lot.

How to copy a column from one excel file to another excel file?

Hi community, i have ran into another wall, i am trying to copy the contents of column A from one Excel file and paste that content into another Excel file into column A, how can i do that? Note: it must select all cells that have content and selection must be dynamic, since one day it might have 100 names in column A and the next day it might have 300 names in column A, so the Robot needs to be able to automatically detect the amount of range it needs to copy, I have tried selecting “A:A” but …

Regards
Gokul

[Sudharsan_Ka]

HI @Atharv_Madne

Okay then you can try with this

How to copy data from one excel workbook to another excel workbook

Hi @yushinchan, You can use the “Copy To WorkBook”. Generally it copies the sheet one workbook to another workbook. [image] Here is the package link : Another way you can use “Copy ToClipboard” and “Paste Clipboard” activity from this [image] Regards Balamurugan.S

Regards
Sudharsan

[supermanPunch (Arpan)]

@Atharv_Madne

Its the writing that takes time not the reading

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.