Add new column in excel by giving some name

Help Activities
, ,
1

Hi

How to add new column in excel after some specific column by giving some name to that column.

Thanks,
Riya

2

you mean like this ???
e.g. insert new column after Col3
before
image

after
image

3

Hi @Riya1 Check this out

4

@jack.chan Yes

5

refer to this
Excel.xaml (9.7 KB)

update newColumnName and insertAfter values
image

before:
image

after
image

1 Like
6

Hi @Riya1

U can add the column by using Add Data column with the name and for the position you need u can use filter data table activity and in the output columns add the column names in the format u needed
Main.xaml (9.6 KB)

1 Like
7

use add column activity

surround with try catch because sometimes if column is already present flow wont termnate

1 Like
8

@jack.chan , I have to create 2 column name. How can I do that?

9

use this xaml
Excel.xaml (12.2 KB)

just repeat the code
image

10

@jack.chan ,
Which activity you have used at last?
image

11

Hi @Riya1

image

Please mark @jack.chan post as solution if that helped you

12

uipath.excel.activities

image
image904×614 56.8 KB

13

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