244245246247248249250251252253254
HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet1 = wb.createSheet("new sheet"); sheet1.groupRow(5, 14); sheet1.groupRow(7, 14); sheet1.groupRow(16, 19); sheet1.groupColumn(4, 7); sheet1.groupColumn(9, 12); sheet1.groupColumn(10, 11);
157158159160161162163164165166167
private static void createCase7(String filename) throws IOException { HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet1 = wb.createSheet("new sheet"); sheet1.groupRow(5, 14); sheet1.groupRow(7, 10); FileOutputStream fileOut = new FileOutputStream(filename); wb.write(fileOut); fileOut.close();
158159160161162163164165166167168
private static void createCase7(String filename) throws IOException { HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet1 = wb.createSheet("new sheet"); sheet1.groupRow(5, 14); sheet1.groupRow(7, 10); FileOutputStream fileOut = new FileOutputStream(filename); wb.write(fileOut); fileOut.close(); }
169170171172173174175176177178179
private static void createCase8(String filename) throws IOException { HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet1 = wb.createSheet("new sheet"); sheet1.groupRow(5, 14); sheet1.groupRow(7, 10); sheet1.setRowGroupCollapsed(7, true); FileOutputStream fileOut = new FileOutputStream(filename); wb.write(fileOut);
170171172173174175176177178179180
private static void createCase8(String filename) throws IOException { HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet1 = wb.createSheet("new sheet"); sheet1.groupRow(5, 14); sheet1.groupRow(7, 10); sheet1.setRowGroupCollapsed(7, true); FileOutputStream fileOut = new FileOutputStream(filename); wb.write(fileOut); fileOut.close();