I need help!i want to rearrange columns

Help Studio
, ,
1

I need help!i want to rearrange columns , how do i do it without data getting manipulated
help me get solution

2

Hey @Ferdi7110

Kindly refer below link

Also in addition u can use default view too

1 Like
3

Hi @Ferdi7110

=> Read the excel
=> Use Filter Datatable Activity in output column tab add all the columns in the order you want
=> Get the output and Write the datatable back to the same excel

Or

you can checkout this thread too. It will help you.
Use invoke method with SetOrdinal

And pss the datatable and the index in prameters where you want the column

Check this for screenshots of how it looks if stuck.

Regards

4

thanks i used the link, helpful

5

Ohh, there are plenty

6

@Ferdi7110

The below link will help you then.

Regards

7

thank you , i got answer

8

Hi @Ferdi7110

If you find the solution please do mark as solution to close the loop.

Happy Automation!!

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.