import java.io.FileOutputStream; import java.io.IOException; import org.apache.poi.ss.usermodel.CreationHelper; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; public class XmlSplitPane { public static void main(String args[]) throws IOException { Workbook wb = new XSSFWorkbook(); CreationHelper createHelper = wb.getCreationHelper(); Sheet sheet1 = wb.createSheet("new sheet"); Row row = sheet1.createRow((short) 0); // Create a cell and put a value in it. row.createCell(0).setCellValue( createHelper.createRichTextString("THIS IS FREEZED ROW")); for (int i = 1; i < 20; i++) { row = sheet1.createRow((short) i); row .createCell(0) .setCellValue( createHelper .createRichTextString("This is the Moving Row")); } sheet1.createSplitPane(2000, 2000, 0, 0, Sheet.PANE_LOWER_LEFT); FileOutputStream fileOut = new FileOutputStream( "xlsx/SplitWorkbook.xlsx"); wb.write(fileOut); fileOut.close(); } }