org.apache.poi.ss.usermodel.Sheet.setRowGroupCollapsed()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(1.5k)|赞(0)|评价(0)|浏览(239)

本文整理了Java中org.apache.poi.ss.usermodel.Sheet.setRowGroupCollapsed()方法的一些代码示例,展示了Sheet.setRowGroupCollapsed()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Sheet.setRowGroupCollapsed()方法的具体详情如下:
包路径:org.apache.poi.ss.usermodel.Sheet
类名称:Sheet
方法名:setRowGroupCollapsed

Sheet.setRowGroupCollapsed介绍

[英]Set view state of a grouped range of rows
[中]设置分组行范围的视图状态

代码示例

代码示例来源:origin: net.sf.jxls/jxls-core

private void groupRows(int startRowNum, int endRowNum) {
    Sheet hssfSheet = tagContext.getSheet().getPoiSheet();
    hssfSheet.groupRow( startRowNum, endRowNum );
    hssfSheet.setRowGroupCollapsed( startRowNum, !detail);
  }
}

代码示例来源:origin: SheetJS/jxls

private void groupRows(int startRowNum, int endRowNum) {
    Sheet hssfSheet = tagContext.getSheet().getPoiSheet();
    hssfSheet.groupRow( startRowNum, endRowNum );
    hssfSheet.setRowGroupCollapsed( startRowNum, !detail);
  }
}

代码示例来源:origin: org.apache.poi/poi-examples

private void collapseExpandRowColumn() throws IOException {
    try (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);

      sheet2.setRowGroupCollapsed(7, true);
      //sheet1.setRowGroupCollapsed(7,false);

      sheet2.setColumnGroupCollapsed((short) 4, true);
      sheet2.setColumnGroupCollapsed((short) 4, false);

      try (OutputStream fileOut = new FileOutputStream("outlining_collapsed.xlsx")) {
        wb2.write(fileOut);
      }
    }
  }
}

相关文章

微信公众号

最新文章

更多