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

Introduction

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

Prototype

@Override
public void setColumnGroupCollapsed(int columnNumber, boolean collapsed) 

Source Link

Document

Expands or collapses a column group.

Usage

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);/*from   w  ww .j  a  va 2s .  co m*/
    sheet1.groupColumn(4, 7);
    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);/*  w w w. j av  a 2  s. c  om*/
    sheet1.groupColumn(4, 7);
    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);/* w  ww.  j  a v a 2  s .  co  m*/
    sheet1.groupColumn(4, 7);
    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);/* w  w  w  . j  a va2 s .  c om*/
    sheet1.groupColumn(4, 7);
    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);//from w w  w. j a  v  a 2 s . c  o m
    sheet1.groupColumn(4, 10);
    sheet1.setColumnGroupCollapsed(4, true);
    sheet1.setColumnGroupCollapsed(2, true);

    sheet1.setColumnGroupCollapsed(3, false);

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

---