Page number in Excel

2 posts, 0 answers
  1. Daniel
    Daniel avatar
    8 posts
    Member since:
    Sep 2017

    Posted 29 May 2018 Link to this post

    Hello.

    I am using Export to Excel functionality.

    Is there a way of adding page numbers to the excel generated from the grid?

    I have tried the following but it does not work.

    function excelExport(e) {
            var sheet = e.workbook.sheets[0];

            sheet.pageNumber = true;

    }

    Or is there any property which can be set when defining the Excel?

           .Excel(excel => excel
            .FileName("Users.xlsx")
            .Filterable(true)
            .ProxyURL(Url.Action("Excel_Export_Save", "UserAndGroup"))
           )

     

    Thanks

     

  2. Boyan Dimitrov
    Admin
    Boyan Dimitrov avatar
    2062 posts

    Posted 30 May 2018 Link to this post

    Hello,

    In general the excel export exports the data to a single sheet so in theory there are no really pages compared to the PDF export. 

    Just in case if you need to add a separate row to the excel export document indicating the end of each page (from the datasource perspective) you can use the approach demonstrated in the Export the Entire Grid Data to Excel KB article. While iterating the entire data you can add a separate row when the current page ends (for example on 20th, 40th, 60th item and so on) containing some text indicating the end of the current page. 
     

    Regards,
    Boyan Dimitrov
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top