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

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

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

Sheet.getHyperlinkList介绍

[英]Get a list of Hyperlinks in this sheet
[中]获取此工作表中的超链接列表

代码示例

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

/*package*/ static void updateHyperlinks(Sheet sheet, FormulaShifter formulaShifter) {
  int sheetIndex = sheet.getWorkbook().getSheetIndex(sheet);
  List<? extends Hyperlink> hyperlinkList = sheet.getHyperlinkList();
  for (Hyperlink hyperlink : hyperlinkList) {
    XSSFHyperlink xhyperlink = (XSSFHyperlink) hyperlink;
    String cellRef = xhyperlink.getCellRef();
    CellRangeAddress cra = CellRangeAddress.valueOf(cellRef);
    CellRangeAddress shiftedRange = BaseRowColShifter.shiftRange(formulaShifter, cra, sheetIndex);
    if (shiftedRange != null && shiftedRange != cra) {
      // shiftedRange should not be null. If shiftedRange is null, that means
      // that a hyperlink wasn't deleted at the beginning of shiftRows when
      // identifying rows that should be removed because they will be overwritten
      xhyperlink.setCellReference(shiftedRange.formatAsString());
    }
  }
}

代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

/*package*/ static void updateHyperlinks(Sheet sheet, FormulaShifter formulaShifter) {
  int sheetIndex = sheet.getWorkbook().getSheetIndex(sheet);
  List<? extends Hyperlink> hyperlinkList = sheet.getHyperlinkList();
  for (Hyperlink hyperlink : hyperlinkList) {
    XSSFHyperlink xhyperlink = (XSSFHyperlink) hyperlink;
    String cellRef = xhyperlink.getCellRef();
    CellRangeAddress cra = CellRangeAddress.valueOf(cellRef);
    CellRangeAddress shiftedRange = BaseRowColShifter.shiftRange(formulaShifter, cra, sheetIndex);
    if (shiftedRange != null && shiftedRange != cra) {
      // shiftedRange should not be null. If shiftedRange is null, that means
      // that a hyperlink wasn't deleted at the beginning of shiftRows when
      // identifying rows that should be removed because they will be overwritten
      xhyperlink.setCellReference(shiftedRange.formatAsString());
    }
  }
}

相关文章

微信公众号

最新文章

更多