How to show headers on every print page in Aspose excel template

Aspose.Cells Product Family
1

Hi,

Is there any way to show report header (some limited row and columns) on every print page?

Please find the attached template. i need to show headers on every print page.

Please suggest

2

Hi,

Thank you for considering Aspose.

Aspose.Cells allows you to designate row and column headers that you want to have repeated on all pages of your printed worksheet. You may use PrintTitleColumns and PrintTitleRows properties of the PageSetup class as per your need. Please see the following documentation link for further details and sample code:

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/setting-print-options.html

You may also check our online demo as per your requirement:

http://www.aspose.com/demos/.net-components/aspose.cells/csharp/quick-start/page-setup/setting-print-options.aspx

Thank You & Best Regards,