Insert column between the two columns

[sushmithaelluru (sushmitha)]

Hi all, am trying to insert the column between the columns, but not able to add. The follwoing is the xaml file of it.

Trial.xaml (7.8 KB)

The below is the excel sheet, where I need to add the column between the rows H and I( #ACD and Caregory)

Thanks.

[Manjuts90]

@sushmithaelluru u added column to datatable not excel in ur workflow. Write that datatable to excel then u will get new column in ur excel.

[fmsimoes]

@sushmithaelluru
check this topic for better understanding

How to insert a column in existing excel in the first place?

Hi all, I have an excel sheet with some columns in it. I want to add new col Sr. No. in the 1st place of the excel sheet. I tried with add column method, but that adds col at the end. Does anyone know how this can be done?

[sushmithaelluru (sushmitha)]

Ok @Manjuts90. Thanks. Write that datatable to excel then u will get new column in ur excel – which means should use write range activity!!

[balupad14 (Balamurugan)]

Hi @sushmithaelluru,

Take a look

Insert Column

Regards
Balamurugan.S

[sushmithaelluru (sushmitha)]

ok. I tried it.

[sushmithaelluru (sushmitha)]

Am getting error that “table doesnot exist”, for the below xaml file . Am trying to insert the column between two columns there. Can you once look into xaml file!!
Trial.xaml (10.4 KB)

Thanks.

[balupad14 (Balamurugan)]

Hi @sushmithaelluru,

I tried it . But I am getting confusion with property Table Name. I was excepting that it is datatable. But it is a string variable. Let us see we can get help with our users.

Regards
Balamurugan.S

[sushmithaelluru (sushmitha)]

Ya @balupad14. I too didn’t understand the property “Table Name” in ‘Insert Column’ activity.

[Manjuts90]

@sushmithaelluru I think Table Name is name of the table created in excel. By selecting required number of rows and columns. You search in google for table creation in excel and u try this option, i think it will work.

[Sob (Bindu)]

Hi,

Give the parameter value in the invoke method activity. if you want to insert the column between H and I means.Give the parameter value as ‘8’

[sushmithaelluru (sushmitha)]

Ya Thanks @sob, but am not able to see the column get added in between the columns , sharing the xaml file and excel and the “table is empty after reading the excel sheet”.
Can you once please look into it.

Trial.xaml (9.3 KB)

[Sob (Bindu)]

Hi,

Try this Sample
bind_u.zip (8.3 KB)

[balupad14 (Balamurugan)]

Hi @sushmithaelluru,

It is working try this.

File :InserColumn.zip (1.5 KB)

Regards
Balamurugan.S

[sushmithaelluru (sushmitha)]

Hi @balupad14, am getting the below error for the given xaml file.

[balupad14 (Balamurugan)]

Hi @sushmithaelluru,

You have install the “UiPath Excel Extended Activities” in the studio. Sorry I forgot to mention it.

Regards
Balamurugan.S

[sushmithaelluru (sushmitha)]

I didnot find that one in my packages @balupad14!!

[balupad14 (Balamurugan)]

Hi @sushmithaelluru,

Can you follow the red arrow that you can see the package.

If not , check this.

Regards
Balamurugan.S

[sushmithaelluru (sushmitha)]

Ya @balupad14, can you look into the screenshot once!!

Didn’t find that activity…

[balupad14 (Balamurugan)]

Hi @sushmithaelluru,

You are searching in “Installed” , can you please check in “Available”

Regards
Balamurugan.S