Free Support Forum - aspose.com

How to get column headings on every page while printing

Hi

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…

Thanks
Geeta


Dear Geeta,

Please email your sample designer file to excel@aspose.com.

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.

CM

It does not keep the setting when there are multiple sheets

CM

Hi,

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.Open(“d:\samplefile.xls”);
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.