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

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

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

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);

相关文章

微信公众号

最新文章

更多