Adding header

[Gokul_Murali]

hello guys, I have a blank excel and I want to add below image as a header.

Please suggest a solution.

[Anil_G (Anil Gorthi)]

@Gokul_Murali

1. If blank best to keep it as template and have the header already
2. If you want to write from automation only then just use build datatable and add column name as you need then use write range with headers

cheers

[Gokul_Murali]

@Anil_G

I have done that also before (second option)

Iam using a write range activity to create an excel in the same excel i have given build data table activity output also but its coming as blank.

[Anil_G (Anil Gorthi)]

@Gokul_Murali

you mean its coming empty?

then in build datatable either add a dummy empty row

or remove add headers and in build datatable add the header names as first row and then write from A1

cheers

[Gokul_Murali]

@Anil_G

Already i have created a build data table and writing in excel but its not working.

[Anil_G (Anil Gorthi)]

@Gokul_Murali

as mentioned

add a blank row in build datatable..as of now no rows are there

with blank row

or instead of adding names in header add them as first row and write without add headers option

second way and remove add headers in write

cheers