EPPlus 5

Split panes

Two new methods to split the worksheet window into panes has been added to the ExcelWorksheetView class.

• SplitPanes - Splits the window using row/column parameters
• SplitPanesPixel - Splits the window using x/y coordinates

For example:

            
//Will split the panes on the top-left corner of cell D5
ws.View.SplitPanes(4, 3);
                
            

For more details see this wiki page: Freeze and Split Panes