I can't find a way of programatically setting a header row to repeat on every printed page? This seams to be a missing feature of the Excel's PrintOptions class, or am I missing something? I'm using version 2008 vol 2.
I too am looking for this in the .printoptions class as this is an important attribute to set for a full printable excel spreadsheet directly from code.
It seems the only 3 properties that CANNOT be set from the printoptions class are:
Print Area: StartRow,StartCol, EndRow, EndCol
Rows To Repeat at top: StartRow,EndRow
Columns to repeat at left: StartCol, EndCol
It's such a good interface, I couldn't believe it, when I could not find these.
Hope they are added soon. I posted a dev/feature request for it today.
This functionality is still NOT available as of release 2010.1 Infragistics3.Excel.v10.1
Worksheet.PrintOptions.RowsToRepeatAtTop <\-- no such option.
It's frustrating that this option is missing, it's the only option that causes the excel spreadsheets I generate from code from being complete printer ready.
I put a dev request for this functionality on 2009-07-15.