Example usage for org.apache.poi.xssf.streaming SXSSFSheet setRowGroupCollapsed

Introduction

In this page you can find the example usage for org.apache.poi.xssf.streaming SXSSFSheet setRowGroupCollapsed.

Prototype

@Override
public void setRowGroupCollapsed(int row, boolean collapse) 

Source Link

Document

Set view state of a grouped range of rows.

Usage

From source file:poi.xssf.streaming.examples.Outlining.java

License:Apache License

private void collapseRow() throws Exception {
    SXSSFWorkbook wb2 = new SXSSFWorkbook(100);
    SXSSFSheet sheet2 = (SXSSFSheet) wb2.createSheet("new sheet");

    int rowCount = 20;
    for (int i = 0; i < rowCount; i++) {
        sheet2.createRow(i);// ww w. j  a  v  a  2 s  .  com
    }

    sheet2.groupRow(4, 9);
    sheet2.groupRow(11, 19);

    sheet2.setRowGroupCollapsed(4, true);

    FileOutputStream fileOut = new FileOutputStream("outlining_collapsed.xlsx");
    wb2.write(fileOut);
    fileOut.close();
    wb2.dispose();
}

---