"Rows to repeat at top" option

Aspose.Cells Product Family
1

Excel has an option in the page setup dialog called, "Rows to repeat at top"

How do I set this option using Aspose.Cells? I can't find the function in the API documentation.

Thanks,
Scott

2

Hi Scott,

Well the APIs are there, you may use PageSetup.PrintTitleRows property for your need.

Sample code:

Aspose.Cells.PageSetup pagesetup = worksheet.PageSetup;

// first five rows are repeated in each page ... can be seen in print preview.

pagesetup.PrintTitleRows = "$1:$5";

And the documentation is also there, please check the wiki documentation:

Thank you.

3

Oh, I was looking for something with a name similar to what excel calls it.

Thanks, it works perfectly.
Scott