When exporting an empty file users still want to see headers using excelExportService

State See Verified Answer
Replies 3 replies
Subscribers 7 subscribers
Views 1063334 views
Users 0 members are here

excelExportService

610

Jeff Kelso posted over 4 years ago

Hi,

I'm using the excelExportService.ExportData and when there's an empty source an empty file gets created without headers. I'd create an Excel sheet that contains the column hearders to be produced even if there is not data. Is this possible?

Thanks,

Top Replies

1080

Offline Martin Asenov posted over 4 years ago +1 verified
Hi Jeff, Thank you for posting in our community. You can define an array that holds rows with empty fields and export it using the exportData method...view reply »

1080

Offline Martin Asenov posted over 4 years ago in reply to Jeff Kelso

I am glad that you find my suggestions helpful.

Thank you for using Infragistics components.
Cancel
Reply

Cancel
610

Offline Jeff Kelso posted over 4 years ago in reply to Martin Asenov

Thanks so much Martin! This works perfectly.

JK
Cancel
Reply

Cancel
1080

Verified Answer
Offline Martin Asenov posted over 4 years ago

Hi Jeff,

Thank you for posting in our community.

You can define an array that holds rows with empty fields and export it using the exportData method or have a hidden igxGrid with rows with empty fields that are exported using the export method.

I have created a small sample in StackBlitz demonstrating this behavior. Please test it on your side and let me know whether it helps you achieve your requirement.
Cancel
Reply

Reject Answer

Cancel