MarketplaceStudioActivityDatatable SetOrdinal

Create your first automation in just a few minutes.Try Studio Web

Datatable SetOrdinal

Datatable SetOrdinal

by Internal Labs

StarStar

1

Activity

Downloads

5.9k

Hi Mateus Cruz,

How to add header coloums in the middle of the excel coloums. Just assume (3,5,9,12) position we need to add header coloums.

Mateus Cruz
Posted 5 years ago ago

Hello! This activity just changes the order of the columns. 

To add a new column, please use the "Add Data Column" or "Insert Column" activities,depending on your case.

Lahiru Fernando
Posted 5 years ago

Hi Mateus,

It's a great actvity. However It would be great if you could add the output property for the new datatable returned. It would help to retain the orginial datatable and have a new one with the change. This is required for some scenarios. 

Would you be able to do it in the next release?

Mateus Cruz
Posted 5 years ago ago

Hello!

Yes, I believe that could be included in a future release.

Thank you for the suggestion! 

As a workaround for the time being, please consider using the Copy() method of the DataTable class to create a copy of the table before using this activity.

Publisher

Internal Labs

Visit publisher's page

License & Privacy

License Agreement

Privacy Terms

Technical

Version

2.0.0

Updated

July 21, 2021

Works with

Studio: 21.10 - 22.10

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support