Examples of org.apache.poi.ss.usermodel.Sheet.groupColumn()

org.apache.poi.ss.usermodel.Sheet.groupColumn()
Create an outline for the provided column range. @param fromColumn beginning of the column range. @param toColumn end of the column range.


  sheet1.groupRow( 5, 14 );
  sheet1.groupRow( 7, 14 );
  sheet1.groupRow( 16, 19 );


  sheet1.groupColumn( (short)4, (short)7 );
  sheet1.groupColumn( (short)9, (short)12 );
  sheet1.groupColumn( (short)10, (short)11 );


  FileOutputStream fileOut = new FileOutputStream("outlining.xlsx");
  wb.write(fileOut);

View Full Code Here

  sheet1.groupRow( 5, 14 );
  sheet1.groupRow( 7, 14 );
  sheet1.groupRow( 16, 19 );


  sheet1.groupColumn( (short)4, (short)7 );
  sheet1.groupColumn( (short)9, (short)12 );
  sheet1.groupColumn( (short)10, (short)11 );


  FileOutputStream fileOut = new FileOutputStream("outlining.xlsx");
  wb.write(fileOut);
  fileOut.close();

View Full Code Here

  sheet1.groupRow( 7, 14 );
  sheet1.groupRow( 16, 19 );


  sheet1.groupColumn( (short)4, (short)7 );
  sheet1.groupColumn( (short)9, (short)12 );
  sheet1.groupColumn( (short)10, (short)11 );


  FileOutputStream fileOut = new FileOutputStream("outlining.xlsx");
  wb.write(fileOut);
  fileOut.close();

View Full Code Here

  Sheet sheet2 = wb2.createSheet("new sheet");
  sheet2.groupRow( 5, 14 );
  sheet2.groupRow( 7, 14 );
  sheet2.groupRow( 16, 19 );


  sheet2.groupColumn( (short)4, (short)7 );
  sheet2.groupColumn( (short)9, (short)12 );
  sheet2.groupColumn( (short)10, (short)11 );
  
  
  sheet2.setRowGroupCollapsed( 7, true );

View Full Code Here

  sheet2.groupRow( 5, 14 );
  sheet2.groupRow( 7, 14 );
  sheet2.groupRow( 16, 19 );


  sheet2.groupColumn( (short)4, (short)7 );
  sheet2.groupColumn( (short)9, (short)12 );
  sheet2.groupColumn( (short)10, (short)11 );
  
  
  sheet2.setRowGroupCollapsed( 7, true );
  //sheet1.setRowGroupCollapsed(7,false);

View Full Code Here

  sheet2.groupRow( 7, 14 );
  sheet2.groupRow( 16, 19 );


  sheet2.groupColumn( (short)4, (short)7 );
  sheet2.groupColumn( (short)9, (short)12 );
  sheet2.groupColumn( (short)10, (short)11 );
  
  
  sheet2.setRowGroupCollapsed( 7, true );
  //sheet1.setRowGroupCollapsed(7,false);

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.