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

Free Support Forum - aspose.com

Need to use setPrintTitleRows() to repeat different group of rows on excel sheet

Hi Team,

We have a requirement to repeat certain group of rows on each page of excel sheet.
I am using setPrintTitleRows() for this purpose.

For eg. setPrintTitleRows("$0:$5") and then setPrintTitleRows("$10:$12"), but its repeating only the last called method i.e. setPrintTitleRows("$10:$12") not both methods.

Pls let me know is there any any to do it.

We are using Aspose for JDK1.4

Uttam K.


Thanks for your query.

Well, you cannot specify two non contiguous ranges of rows as title rows in MS Excel, you may confirm this behavior in Ms Excel, so, it is not an issue with the product. Aspose.Cells would rightly use the latter (i.e., “$10:$12”) as Rows to repeat at top settings for the Worksheet.

Thank you.