Free Support Forum -

How to get column headings on every page while printing


I have given column headings to the Columns that I created on the designer Excel sheets. I have also used the Page Setup option of “Rows to repeat on Top” on the designer file, since I want to repeat the Column headings on every page when it is to be printed out.

However when I get the output Excel file I do not get this file with the repeated rows on Top.
My question is, whether there is any other way that I can repeat the rows on the top of every page while printing?

In the designer excel file I have also provided Page Setup options like “Printing in landscape”, Adding Page Numbers in the Footer. The output file also gets these settings once it is populated. So I could not understant why the Page Setup option of “Repeating rows on top” fails…


Dear Geeta,

Please email your sample designer file to

Thanks for your cooperation.

How did you fix this problem? I am having the same issue. I am trying to print the column heading per page.


It does not keep the setting when there are multiple sheets



Thanks for your consideration.

I tested it and the result is fine.

Which version of Aspose.Excel are you using? Could you send me your designer file?
I will investigate your problem.

Dear Geeta,

I got your designer file and tested it.

Excel excel = new Excel();
excel.Worksheets[0].Cells[131, 0].PutValue(1234);
excel.Save(“result.xls”, SaveType.OpenInExcel, FileFormatType.Default, this.Response);

In the result file, line 3 is repeated on every page in “print preview”. The Page Setup options are not lost.

Could you send me your code to manipulate the designer file? I will investigate it to see what caused this problem.

Dear Customers,

This bug is fixed. So if you find the same problem, please download the fix 1.5.8.