本文整理了Java中org.apache.poi.ss.usermodel.Sheet.groupRow()
方法的一些代码示例,展示了Sheet.groupRow()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Sheet.groupRow()
方法的具体详情如下:
包路径:org.apache.poi.ss.usermodel.Sheet
类名称:Sheet
方法名:groupRow
[英]Tie a range of rows together so that they can be collapsed or expanded
[中]将一系列行绑在一起,以便折叠或展开它们
代码示例来源:origin: org.apache.poi/poi-examples
private void groupRowColumn() throws IOException {
try (Workbook wb = new XSSFWorkbook()) {
Sheet sheet1 = wb.createSheet("new sheet");
sheet1.groupRow(5, 14);
sheet1.groupRow(7, 14);
sheet1.groupRow(16, 19);
sheet1.groupColumn((short) 4, (short) 7);
sheet1.groupColumn((short) 9, (short) 12);
sheet1.groupColumn((short) 10, (short) 11);
try (OutputStream fileOut = new FileOutputStream("outlining.xlsx")) {
wb.write(fileOut);
}
}
}
代码示例来源:origin: net.sf.jxls/jxls-core
/**
* Outlines all required collections in a sheet
*
* @param sheet - {@link Sheet} where to outline collections
*/
void groupRows(Sheet sheet) {
for (Iterator iterator = groupedCollections.iterator(); iterator.hasNext();) {
String collectionName = (String) iterator.next();
if (sheet.getListRanges().containsKey(collectionName)) {
ListRange listRange = (ListRange) sheet.getListRanges().get(collectionName);
sheet.getPoiSheet().groupRow(listRange.getFirstRowNum(), listRange.getLastRowNum());
}
}
}
代码示例来源:origin: SheetJS/jxls
/**
* Outlines all required collections in a sheet
*
* @param sheet - {@link Sheet} where to outline collections
*/
void groupRows(Sheet sheet) {
for (Iterator iterator = groupedCollections.iterator(); iterator.hasNext();) {
String collectionName = (String) iterator.next();
if (sheet.getListRanges().containsKey(collectionName)) {
ListRange listRange = (ListRange) sheet.getListRanges().get(collectionName);
sheet.getPoiSheet().groupRow(listRange.getFirstRowNum(), listRange.getLastRowNum());
}
}
}
代码示例来源: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);
}
}
}
}
代码示例来源:origin: SheetJS/jxls
private void groupRows(int startRowNum, int endRowNum) {
Sheet hssfSheet = tagContext.getSheet().getPoiSheet();
hssfSheet.groupRow( startRowNum, endRowNum );
hssfSheet.setRowGroupCollapsed( startRowNum, !detail);
}
}
代码示例来源: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: org.apache.poi/poi-examples
sheet.groupRow(4, 6);
sheet.groupRow(9, 13);
sheet.groupRow(16, 18);
内容来源于网络,如有侵权,请联系作者删除!