"Rows to repeat at top" option


#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: http://www.aspose.com/wiki/default.aspx/Aspose.Cells/SettingPrintOptions.html

Thank you.


#3

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

Thanks, it works perfectly.
Scott