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

Feedback Activities
,
1

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

2

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

3

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

4

This is working as well:

image
image953×565 15.3 KB

image

2 Likes
6

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

Sequence.xaml (6.5 KB)

Thanks

1 Like
7

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
8

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

9

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

3 Likes
10

sure i will do and let you know

2 Likes
11

Yes Its working

Thanks

3 Likes
12

Hello @vikaskulhari
Hope your issue resolved

Thanks

3 Likes
14

Try using write range activity from with excel application scope as the workbook write range activity doesn’t allow writing the empty DataTable

2 Likes
15

Yes. It worked. Though I believe this activity should be compatible with all versions of Excel. Should be a BUG

16

A post was split to a new topic: No headers in Excel for an empty DataTable