Forums Ignite UI for Angular
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Jeff Kelso
610
When exporting an empty file users still want to see headers using excelExportService
posted

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,

JK

Parents
  • 1080
    Verified Answer
    Offline posted

    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.

Reply Children