Add column name in an already existing sheet in Excel

Help Activities
, ,
21

prev month.xlsx (14.0 KB)

22

what value should I provide in To field in assign? and Do I need to provide the same value in Write range activity?

23

Hi @ayushi_jain3

In your case Range you given is wrong so that’s why error is came.

Give this
Excel.Sheet(“B”)

image
image651×647 20.6 KB

It is working

image
image799×412 9.96 KB

24

@ayushi_jain3

In add data column activity:
image

25

@ayushi_jain3

I am attaching xaml for your reference

Test Sequence.xaml (8.7 KB)

26

@ayushi_jain3

If you got the solution for your issue. Please mark it as solution to close the loop.

Regards,

27

Hey @ayushi_jain3

U can use this method too
So basically i have build a datatable just with column names
and then i merged it to the input datatable
And then i wrote it into the excel
The addheaders property of Write range workbook should be checked

Test (2).zip (10.3 KB)

Hope it helps you!

28

Thankyou, it worked. I was not using double quotes in the column name !!

29

It is adding the required column name I am providing, nut also also an extra column before that as “Column1”

30

image
image556×664 9.14 KB

31

@ayushi_jain3

You can use this also to add column in datatable

image

32

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