How to add header name to excel sheet

[mironb]

Hello

I read from result excel and I want to add him a column header

How Can I do that ?

Thanks for the help

[Anil_G (Anil Gorthi)]

@mironb

What while reading you want to read header as well and use first row as header?

If so check the box header in read range

Cheers

[mironb]

@Anil_G

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @mironb ,
You want to add new column?
You can use add data column then write to excel

Regards,
LNV

[Anil_G (Anil Gorthi)]

@mironb

Is it not able to read those characters?

Cheers

[mironb]

@Nguyen_Van_Luong1

I want to add only the header that in red rectangle to the excel

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

This is your expect output
that’s right?
can you share your input?
normal is you can use write cell with text

[mironb]

@Nguyen_Van_Luong1

What I need to insert in the ‘Column’ ?

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

I want to see your input?
if insert column, you use insert column as I said above
best, show me your expected input and output
I will code for you

[mironb]

@Nguyen_Van_Luong1

Yes - This is the result excel I am writting into it
And I want to Add the header which is marked with a red square

[mironb]

Before

After

[Usha_Jyothi]

You can use add data column activity
or you can use write cell activity

Ignore error marks I wanted to make you understand

Hope it helps

Reards,
Usha

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @mironb ,
I created file to test my code as your requirements
my input

my output

my step

my code
test.xaml (18.8 KB)
you can try
hope it help you
Regards,
LNV

[mironb]

@Nguyen_Van_Luong1

This is the result (the A column shift after the column we inserted)

[mironb]

@Usha_Jyothi

The correct way with Write Cell Workbook
thanks