Write Range Activity doesn't allow empty DT to add headers in the Excel

Team, I think this functionality should be there.

Problem: Write Range Activity doesn’t add headers in the excel sheet if datatable is empty even if Add header is checked. It simply creates a blank sheet. I know there are a various ways through which we can add headers however that increases number of activities and efforts.

Thanks,
Vikas Kulhari

Hi @vikaskulhari,
Can you show the example project or something?
I tested it with sample data and looks like all is working.
image

@Pablito Hi vikas is mentioned about empty datatable with only headers, no data in it.

This is working as well:


image

2 Likes

Hello @Pablito
@vikaskulhari is right .its not working at my end also.

Sequence.xaml (6.5 KB)

Thanks

Interesting :smiley:
I just run your file:
image
Which excel version do you have?

Edit:
Please guys check also if you are using the newest Excel activity package. 2.6.2 in my case. This might be the solution.

2 Likes

i am using Excel 2016

yes you right might be new excel activity package is solution
i ma using 2.5.1 excel activity package

Thanks

Please try it with newest version and let’s see. :slight_smile:

3 Likes

sure i will do and let you know

2 Likes

Yes Its working

Thanks

3 Likes

Hello @vikaskulhari
Hope your issue resolved

Thanks

3 Likes