本文整理了Java中org.apache.poi.ss.usermodel.Sheet.setRowGroupCollapsed()
方法的一些代码示例,展示了Sheet.setRowGroupCollapsed()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Sheet.setRowGroupCollapsed()
方法的具体详情如下:
包路径:org.apache.poi.ss.usermodel.Sheet
类名称: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);
}
}
}
}
内容来源于网络,如有侵权,请联系作者删除!