Insert column between the two columns

activities

#1

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.


#2

@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.


#3

@sushmithaelluru
check this topic for better understanding


#4

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


#5

Hi @sushmithaelluru,

Take a look

image

Regards
Balamurugan.S


#6

ok. I tried it.


#7

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.


#8

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


#9

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


#10

@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.


#11

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’


#12

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)


#13

Hi,

Try this Sample
bind_u.zip (8.3 KB)


#14

Hi @sushmithaelluru,

It is working try this.

image

image
File :InserColumn.zip (1.5 KB)

Regards
Balamurugan.S


#15

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


#16

Hi @sushmithaelluru,

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

Regards
Balamurugan.S


#17

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


#18

Hi @sushmithaelluru,

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

If not , check this.

Regards
Balamurugan.S


#19

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

Didn’t find that activity…


#20

Hi @sushmithaelluru,

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

Regards
Balamurugan.S