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
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.