Package org.apache.poi.ss.usermodel

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

331
332
333
334
335
336
337
338
339
340
341
        Workbook wb = new XSSFWorkbook();
        Sheet sheet = wb.createSheet("sheet123");

        sheet.groupRow(1, 4);
        sheet.groupRow(2, 5);
        sheet.groupRow(3, 6);
       
        sheet.setRowGroupCollapsed(1, true);
        sheet.setRowGroupCollapsed(2, false);
        sheet.setRowGroupCollapsed(3, false);
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
    private void groupRowColumn() throws Exception{
  Workbook wb = new XSSFWorkbook();
  Sheet sheet1 = wb.createSheet("new sheet");

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

  sheet1.groupColumn( (short)4, (short)7 );
  sheet1.groupColumn( (short)9, (short)12 );
View Full Code Here
35
36
37
38
39
40
41
42
43
44
45
    private void groupRowColumn() throws Exception{
  Workbook wb = new XSSFWorkbook();
  Sheet sheet1 = wb.createSheet("new sheet");

  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 );
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
  Workbook wb = new XSSFWorkbook();
  Sheet sheet1 = wb.createSheet("new sheet");

  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 );
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
    }

    private void collapseExpandRowColumn()throws Exception{
  Workbook wb2 = new XSSFWorkbook();
  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 );
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
    private void collapseExpandRowColumn()throws Exception{
  Workbook wb2 = new XSSFWorkbook();
  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 );
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
    private void collapseExpandRowColumn()throws Exception{
  Workbook wb2 = new XSSFWorkbook();
  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 );
 
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.