EPPlus 5

Features and technical overview

Split panes

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