We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Need to remove PrintTitleRows from the last page or after pagebreak in excelsheet

Hi Team,

We have a requirement to remove title rows set by PrintTitleRows set by below code:-
PageSetup pageSetup = sheet.getPageSetup();
pageSetup.setPrintTitleRows( “$0:$8” );

We need to remove the title rows in below scenarios:
1. From the last page of the excel sheet
2. After inserting page break in the sheet.

We are not able to find any method to remove PrintTitleRows.

Applications is using JDK1.4 and have Aspose 2.2

Regards,
Uttam K.

Hi,


Well, to remove Rows to repeat at top setting, you may try using the following sample code:
e.g
Sample code:

pageSetup.setPrintTitleRows("");


Regarding your specific queries 1) and 2), how could you do this in MS Excel manually. I mean how could you specify or remove print title rows options for only the last page the sheet or after inserting page breaks accordingly. For your information, Rows to repeat at top setting is applied to the whole sheet (pages) and not for some part of the sheet or pages. If you think otherwise, kindly provide us a sample Excel file with your desired settings, you may create your desired file in MS Excel manually, we will check how to do it via Aspose.Cells APIs.

Thank you.