using Infragistics.Documents.Excel;
Creating a new Excel 2007 file.
What is the command to Freeze (aka want to fix a header so I can Scroll without losing the headers).
What is the command to Split?
In Excel -> Windows Split / Freeze. I am not certain of the commands required to do this in infragistics.
OK,
sheet.DisplayOptions.FrozenPaneSettings /
sheet.DisplayOptions.PanesAreFrozen solves the Freezing so only need to know how to split.
The FrozenPaneSettings class has properties named FrozenColumns and FrozenRows. There are ingeters which represents the number of frozen columns/rows. If you want two rows frozen at the top of the worksheet, set sheet.DisplayOptions.FrozenPaneSettings.FrozenRows to 2.