Page number in Excel

[Daniel]

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

 

[Boyan Dimitrov]

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