Class PaneCollection

PaneCollection class

Represents all Pane objects shown in the specified window.

public class PaneCollection

Properties

NameDescription
AcitvePaneType { get; set; }Gets and sets the active pane.
FirstVisibleColumnOfRightPane { get; set; }Gets and sets the first visible column of the right pane.
FirstVisibleRowOfBottomPane { get; set; }Gets and sets the first visible row of the bottom pane.

Examples

// Called: PaneCollection panes = sheet.GetPanes();
[Test]
        public void Type_PaneCollection()
        {
            Workbook workbook = new Workbook(Constants.sourcePath + "CellsNet14240.xls");
            Worksheet sheet = workbook.Worksheets["MonSumSheet1"];
            PaneCollection panes = sheet.GetPanes();
            panes.FirstVisibleRowOfBottomPane = 5;
            panes.FirstVisibleColumnOfRightPane = 1;
            workbook = Util.ReSave(workbook, SaveFormat.Excel97To2003);//.Save(Constants.destPath + "CellsNet14240.xls");
        }

See Also