Split Cells in Worksheet

Aspose.Cells - Split Cells in Worksheet

C#

Workbook workbook = new Workbook();

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Set the active cell
workbook.Worksheets[0].ActiveCell = "A10";

// Split the worksheet window
workbook.Worksheets[0].Split();

workbook.Save("output-Split.xls");

NPOI - HSSF XSSF - Split Cells in Worksheet

C#

HSSFWorkbook hssfworkbook = new HSSFWorkbook();

ISheet sheet1 = hssfworkbook.CreateSheet("new sheet");

ISheet sheet2 = hssfworkbook.CreateSheet("second sheet");

// Create a split with the lower‑left side being the active quadrant
sheet2.CreateSplitPane(2000, 2000, 0, 0, PanePosition.LowerLeft);

// Write the stream data of the workbook to the root directory
FileStream file = new FileStream(@"output-Split.xls", FileMode.Create);

hssfworkbook.Write(file);

file.Close();

For more details, visit Working with Worksheets.