Unable to write headers to excel

Help
1

I have data table with only headers or column names .When im trying to write these headers to the excel , unable to add hears to the excel sheet. I have also enabled add headers check box but it dint work. Anyone please suggest what can we do

Continuing the discussion from How to write the headers from a DataTable just once into an Excel log file?:

image
image1359×691 53.4 KB

image
image1366×698 57.7 KB

2

Hi @prathusha,test12.xaml (6.8 KB)

I have attached the workflow with the column headers adding to the excel
i hope this helps

3

Hi,
i want to extract the generated code from the webpage. How can i?
Reply me as soon as possible.

4

Hi @prathusha,

I see that you don’t have any data defined in ‘Build datatable’ activity and you are not adding any row using ‘add data row’ activity.

image

Write range with Add headers checked will not write any data to excel if datatable does not have rows in it in this case.

Regards,
Rahamtullah

5

I dont want to add data row to my excel or data table. I only want headers. Is it possible.

image
image1086×447 44.6 KB

I mean this should be the data table in your example.

image
image743×416 10.1 KB

6

Hey
I have created a code by filling a form on web and i want to send the code into excel file. This code is in popup window. Can anyone help me?

7

Hi Prathusha,
Add a empty row in your datatable as below and then write to the excel.Only Header will be present in your generated Excel .

image
image1166×375 8.56 KB

1 Like