Repeat table headers when report runs multiple pages

[shlomit.t]

Hello,

In my application I export grid into excel sheet. the table has too many row. printing the excel requires more then one page.

my question:

Is it possible repeat the table headers? So if the report runs to multiple pages, lines 1-3 repeat.
(line 1-3 contains main page header and table headers)

thanks,

Shlomit

[Amjad_Sahi]

Hi,

Well, sure you may do what you want to achieve. Please see the document for your reference:

http://www.aspose.com/docs/display/cellsnet/Setting+Print+Options

I think you may use PrintTitleRows attribute of PageSetup object for the worksheet.

Sample code:

//Obtaining the reference of the PageSetup of the worksheet

Aspose.Cells.PageSetup pageSetup = workbook.Worksheets[0].PageSetup;
//Defining row numbers 1, 2 & 3 as title rows

pageSetup.PrintTitleRows = “$1:$3”;