Forums Ultimate UI for ASP.NET Web Forms
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
Brickred
230
How to identify page break while exporting an excel from WebGrid?
posted

Please provide some solution to identify the page break, while exporting an excel from webGrid.

Actually the requirement is to display the header on each and every page in excel sheet exported though WebGrid.

Thanks,

IH

  • 44743
    Suggested Answer
    posted

    Page breaks are not currently supported by the Infragistics.Excel library and therefore cannot be added by the WebGrid exporter.

    As for the ability to display headers on each printed page of a worksheet, this is supported by the Infragistics.Excel library, but I don't believe corresponding support has been added to the WebGrid exporter. Therefore, you will need to modify the Workbook object after the export has completed. You can access the Worksheet associated with the exported grid and set its PrintOptions.Header property.