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

Introduction

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

Prototype

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

Source Link

Usage

From source file:demo.poi.Outlines.java

License:Apache License

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

    sheet1.groupRow(5, 14);//from ww w .  j a v a  2s  .c om
    sheet1.groupRow(7, 10);
    sheet1.setRowGroupCollapsed(7, true);

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

---

From source file:demo.poi.Outlines.java

License:Apache License

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

    sheet1.groupRow(5, 14);/* www  . ja  va  2 s .c om*/
    sheet1.groupRow(7, 10);
    sheet1.setRowGroupCollapsed(7, true);
    sheet1.setRowGroupCollapsed(5, true);

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

---

From source file:demo.poi.Outlines.java

License:Apache License

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

    sheet1.groupRow(5, 14);/* www  .  j av a  2 s. c  om*/
    sheet1.groupRow(7, 10);
    sheet1.setRowGroupCollapsed(7, true);
    sheet1.setRowGroupCollapsed(5, true);
    sheet1.setRowGroupCollapsed(8, false);

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

---

From source file:demo.poi.Outlines.java

License:Apache License

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

    sheet1.groupRow(5, 14);/*from  ww w  . ja  va2  s .c o  m*/
    sheet1.groupRow(7, 10);
    sheet1.setRowGroupCollapsed(7, true);
    sheet1.setRowGroupCollapsed(5, true);
    sheet1.setRowGroupCollapsed(8, false);
    sheet1.setRowGroupCollapsed(14, false);

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

---

From source file:demo.poi.Outlines.java

License:Apache License

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

    sheet1.groupRow(5, 14);//from  w  w  w  .  j  a v  a2 s .c o m
    sheet1.groupRow(7, 14);
    sheet1.setRowGroupCollapsed(7, true);
    sheet1.setRowGroupCollapsed(5, true);
    sheet1.setRowGroupCollapsed(6, false);

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

---

From source file:teamdash.wbs.excel.WBSExcelWriter.java

License:Open Source License

private int writeDataForNodes(HSSFSheet sheet, int rowNum, WBSNode node, TableColumnModel columns) {
    HSSFRow row = sheet.createRow(rowNum);
    writeCellForNodeName(node, row);/*from  ww  w .  j ava 2 s  . c  o  m*/
    writeCellsForNodeData(row, node, columns);

    WBSNode[] children = wbs.getChildren(node);
    if (children.length == 0)
        return rowNum;

    int childRowPos = rowNum;
    for (WBSNode child : children) {
        childRowPos = writeDataForNodes(sheet, childRowPos + 1, child, columns);
    }

    sheet.groupRow(rowNum + 1, childRowPos);
    if (!node.isExpanded())
        sheet.setRowGroupCollapsed(rowNum + 1, true);

    return childRowPos;
}

---