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.
Can you show the example project or something?
I tested it with sample data and looks like all is working.
@Pablito Hi vikas is mentioned about empty datatable with only headers, no data in it.
@vikaskulhari is right .its not working at my end also.
Sequence.xaml (6.5 KB)
I just run your file:
Which excel version do you have?
Please guys check also if you are using the newest Excel activity package. 2.6.2 in my case. This might be the solution.
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
Please try it with newest version and let’s see.
sure i will do and let you know
Hope your issue resolved
Try using write range activity from with excel application scope as the workbook write range activity doesn’t allow writing the empty DataTable
Yes. It worked. Though I believe this activity should be compatible with all versions of Excel. Should be a BUG