Add column name using Data table

[Gokul_Murali]

Heloo guys,

how can i add a column name on a specific column index using Data Table activity instead of write cell

since the excel is having large data it is taking more time while using Write cell

[vrdabberu (Varunraj Dabberu)]

Hi @Gokul_Murali

Check the below thread

Insert empty column in output filter

Hi @Stef_99 Remove that double quotes in Filter Data Table activity and save the wizard. After Filter Data Table activity use the below code in Invoke Code: dt_Result1.Columns.Add("").SetOrdinal(6) Invoke Arguments: [image] [image] Write dt_Result1 back to excel using Write Range Workbook activity Hope it helps!!

Syntax:

dt_Result1.Columns.Add("").SetOrdinal(6)

Change the number accordin to yours and within doubke quotes give your column name.

Let me know if you have any issues

Regards

[supermanPunch (Arpan)]

Hi @Gokul_Murali ,

Could you maybe check with the below post :

ADD SERAIL NUMBER (S/N) INTO A DATATABLE

Hi @Ahmad_Rais , For a Datatable Manipulation, take a Look at the below post using the SetOrdinal Method : An Alternate would be to use the Add Data Column Activity and then use Filter Datatable to arrange the Columns in the Proper order, this would require you to have the prior knowledge of the all the column names. or using the DefaultView.ToTable method and using the Column names required to be present in the datatable in the order that is required like below : DT.DefaultView.ToTable(fal…

When using SetOrdinal method, first add the column to the Datatable using Add Data Column activity and then use the SetOrdinal method.

We could also re-arrange the columns if we do know the column arrangements and all the columns required for the output using the DefaultView.ToTable() method.

[Gokul_Murali]

This is the error iam getting and the datatable is declared in the scope itself

[vrdabberu (Varunraj Dabberu)]

Hi @Gokul_Murali

Count the number where BO15 comes so it is 67.

Give 67 instead of BO15

Regards

[Gokul_Murali]

It is showing like this

[vrdabberu (Varunraj Dabberu)]

Hi @Gokul_Murali

Did you map the arguments by clicking on Edit Arguments.

Regards

[Gokul_Murali]

Now iam getting error like this

[vrdabberu (Varunraj Dabberu)]

Hi @Gokul_Murali

Give the argument as In/Out not on In.

Regards

[Gokul_Murali]

still the same

[vrdabberu (Varunraj Dabberu)]

Hi @Gokul_Murali

Can you share the entire flow.

Regards

[vrdabberu (Varunraj Dabberu)]

Hi @Gokul_Murali

Or share the excel file.

Regards

[Gokul_Murali]

Test case.zip (8.9 KB)

[vrdabberu (Varunraj Dabberu)]

Hi @Gokul_Murali

Please check the below zip file.

FLOW:

CODE:
dt_PR.Columns.Add("GOC").SetOrdinal(66)

INVOKED ARGUMENTS:

ZIP FILE:
Add column to datatable.zip (47.8 KB)

Let me know if you have any issues.

Regards

[Gokul_Murali]

Bro iam getting the same error.

[vrdabberu (Varunraj Dabberu)]

Hi @Gokul_Murali

Bro check that I have change the code in Invoke Code.

dt_PR.Columns.Add("GOC").SetOrdinal(66)

If this doesn’t work please update UiPath.System.Activities to the latest version.

Regards

[Gokul_Murali]

Same case bro

even i updates the package version to the latest version

[vrdabberu (Varunraj Dabberu)]

Hi @Gokul_Murali

Check that i have changed the code:
dt_PR.Columns.Add("GOC").SetOrdinal(66)

Instead of 67 give 66

Regards

[sandyarpa767]

Hi @Gokul_Murali ,

U can achieve the same by using

syntax :- dt_Result1.Columns.Add("Column name ").SetOrdinal(Columnposition-1)

Regards
Sandy

[Gokul_Murali]

Bro i have tried it but the same case