Example usage for org.apache.poi.hssf.usermodel HSSFSheet groupColumn

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFSheet groupColumn.

Prototype

@Override
public void groupColumn(int fromColumn, int toColumn) 

Source Link

Document

Create an outline for the provided column range.

Usage

From source file:demo.poi.Outlines.java

License:Apache License

private static void createCase1(String filename) throws IOException {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet1 = wb.createSheet("new sheet");

    sheet1.groupColumn(4, 7);

    for (int row = 0; row < 200; row++) {
        HSSFRow r = sheet1.createRow(row);
        for (int column = 0; column < 200; column++) {
            HSSFCell c = r.createCell(column);
            c.setCellValue(column);//from  ww w .  j a va  2s  .  c  om
        }
    }

    FileOutputStream fileOut = new FileOutputStream(filename);
    wb.write(fileOut);
    fileOut.close();
}

---

From source file:demo.poi.Outlines.java

License:Apache License

private static void createCase2(String filename) throws IOException {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet1 = wb.createSheet("new sheet");

    sheet1.groupColumn(2, 10);
    sheet1.groupColumn(4, 7);/*from   w w w. java 2s .  c  o m*/
    sheet1.setColumnGroupCollapsed(4, true);

    FileOutputStream fileOut = new FileOutputStream(filename);
    wb.write(fileOut);
    fileOut.close();
}

---

From source file:demo.poi.Outlines.java

License:Apache License

private static void createCase3(String filename) throws IOException {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet1 = wb.createSheet("new sheet");

    sheet1.groupColumn(2, 10);
    sheet1.groupColumn(4, 7);/*from w  w  w  .  ja v  a2  s  .  c o  m*/
    sheet1.setColumnGroupCollapsed(4, true);
    sheet1.setColumnGroupCollapsed(2, true);

    FileOutputStream fileOut = new FileOutputStream(filename);
    wb.write(fileOut);
    fileOut.close();
}

---

From source file:demo.poi.Outlines.java

License:Apache License

private static void createCase4(String filename) throws IOException {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet1 = wb.createSheet("new sheet");

    sheet1.groupColumn(2, 10);
    sheet1.groupColumn(4, 7);/* w  w  w.ja v  a  2  s .co m*/
    sheet1.setColumnGroupCollapsed(4, true);
    sheet1.setColumnGroupCollapsed(2, true);

    sheet1.setColumnGroupCollapsed(4, false);

    FileOutputStream fileOut = new FileOutputStream(filename);
    wb.write(fileOut);
    fileOut.close();
}

---

From source file:demo.poi.Outlines.java

License:Apache License

private static void createCase5(String filename) throws IOException {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet1 = wb.createSheet("new sheet");

    sheet1.groupColumn(2, 10);
    sheet1.groupColumn(4, 7);/*from  ww w .j a va  2  s. com*/
    sheet1.setColumnGroupCollapsed(4, true);
    sheet1.setColumnGroupCollapsed(2, true);

    sheet1.setColumnGroupCollapsed(4, false);
    sheet1.setColumnGroupCollapsed(3, false);

    FileOutputStream fileOut = new FileOutputStream(filename);
    wb.write(fileOut);
    fileOut.close();
}

---

From source file:demo.poi.Outlines.java

License:Apache License

private static void createCase6(String filename) throws IOException {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet1 = wb.createSheet("new sheet");

    sheet1.groupColumn(2, 10);
    sheet1.groupColumn(4, 10);/*from  w w  w.  jav a  2 s .c om*/
    sheet1.setColumnGroupCollapsed(4, true);
    sheet1.setColumnGroupCollapsed(2, true);

    sheet1.setColumnGroupCollapsed(3, false);

    FileOutputStream fileOut = new FileOutputStream(filename);
    wb.write(fileOut);
    fileOut.close();
}

---

From source file:demo.poi.Outlines.java

License:Apache License

private static void createCase13(String filename) throws IOException {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet1 = wb.createSheet("new sheet");

    sheet1.groupRow(5, 14);/*from  ww  w  .  ja  va 2s. com*/
    sheet1.groupRow(7, 14);
    sheet1.groupRow(16, 19);

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

    FileOutputStream fileOut = new FileOutputStream(filename);
    wb.write(fileOut);
    fileOut.close();
}

---