org.apache.poi.xssf.usermodel.XSSFSheet.getRelations()方法的使用及代码示例

x33g5p2x  于2022-02-02 转载在 其他  
字(12.3k)|赞(0)|评价(0)|浏览(1662)

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

XSSFSheet.getRelations介绍

暂无

代码示例

代码示例来源：origin: looly/hutool

/**
 * 获取XLSX工作簿指定sheet中图片列表
 * 
 * @param workbook 工作簿{@link Workbook}
 * @param sheetIndex sheet的索引
 * @return 图片映射，键格式：行_列，值：{@link PictureData}
 */
private static Map<String, PictureData> getPicMapXlsx(XSSFWorkbook workbook, int sheetIndex) {
  final Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
  final XSSFSheet sheet = workbook.getSheetAt(sheetIndex);
  XSSFDrawing drawing;
  for (POIXMLDocumentPart dr : sheet.getRelations()) {
    if (dr instanceof XSSFDrawing) {
      drawing = (XSSFDrawing) dr;
      final List<XSSFShape> shapes = drawing.getShapes();
      XSSFPicture pic;
      CTMarker ctMarker;
      for (XSSFShape shape : shapes) {
        pic = (XSSFPicture) shape;
        ctMarker = pic.getPreferredSize().getFrom();
        sheetIndexPicMap.put(StrUtil.format("{}_{}", ctMarker.getRow(), ctMarker.getCol()), pic.getPictureData());
      }
    }
  }
  return sheetIndexPicMap;
}
// -------------------------------------------------------------------------------------------------------------- Private method end

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

/**
 * @return the list of Single Xml Cells that provide a map rule to this mapping.
 */
public List<XSSFSingleXmlCell> getRelatedSingleXMLCell() {
  List<XSSFSingleXmlCell> relatedSimpleXmlCells = new ArrayList<>();
  int sheetNumber = mapInfo.getWorkbook().getNumberOfSheets();
  for (int i = 0; i < sheetNumber; i++) {
    XSSFSheet sheet = mapInfo.getWorkbook().getSheetAt(i);
    for (POIXMLDocumentPart p : sheet.getRelations()) {
      if (p instanceof SingleXmlCells) {
        SingleXmlCells singleXMLCells = (SingleXmlCells) p;
        for (XSSFSingleXmlCell cell : singleXMLCells.getAllSimpleXmlCell()) {
          if (cell.getMapId() == ctMap.getID()) {
            relatedSimpleXmlCells.add(cell);
          }
        }
      }
    }
  }
  return relatedSimpleXmlCells;
}

代码示例来源：origin: looly/hutool

/**
 * 获取XLSX工作簿指定sheet中图片列表
 * 
 * @param workbook 工作簿{@link Workbook}
 * @param sheetIndex sheet的索引
 * @return 图片映射，键格式：行_列，值：{@link PictureData}
 */
private static Map<String, PictureData> getPicMapXlsx(XSSFWorkbook workbook, int sheetIndex) {
  final Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
  final XSSFSheet sheet = workbook.getSheetAt(sheetIndex);
  XSSFDrawing drawing;
  for (POIXMLDocumentPart dr : sheet.getRelations()) {
    if (dr instanceof XSSFDrawing) {
      drawing = (XSSFDrawing) dr;
      final List<XSSFShape> shapes = drawing.getShapes();
      XSSFPicture pic;
      CTMarker ctMarker;
      for (XSSFShape shape : shapes) {
        pic = (XSSFPicture) shape;
        ctMarker = pic.getPreferredSize().getFrom();
        sheetIndexPicMap.put(StrUtil.format("{}_{}", ctMarker.getRow(), ctMarker.getCol()), pic.getPictureData());
      }
    }
  }
  return sheetIndexPicMap;
}
// -------------------------------------------------------------------------------------------------------------- Private method end

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

List<POIXMLDocumentPart> rels = _wb.getSheetAt(sheetIndex).getRelations();
for (POIXMLDocumentPart r : rels) {
  if (r instanceof XSSFDrawing) {

代码示例来源：origin: jbaliuka/x4j-analytic

private String tableParts(XLXContext context) {
  StringBuilder tableParts = new StringBuilder();
  if(!context.getTables().isEmpty()){
    tableParts.append(String.format("<tableParts count=\"%d\">" ,context.getTables().size()));
    for (POIXMLDocumentPart next : getSheet().getRelations()) {
      tableParts.append( table(next) );
    }
    tableParts.append("</tableParts>");
  }
  return tableParts.toString();
}

代码示例来源：origin: GZWgssmart/zywork

/**
 * 获取指定工作表里的所有图片数据，只能处理xlsx文档
 * @param sheet 工作表
 * @return 工作表里所有图片Picture对象组成的列表
 */
public List<Picture> getXlsxPictures(Sheet sheet) {
  XSSFSheet xssfSheet = (XSSFSheet) sheet;
  List<POIXMLDocumentPart> documentPartList = xssfSheet.getRelations();
  List<Picture> pictureList = new ArrayList<>();
  for (POIXMLDocumentPart documentPart : documentPartList) {
    if (documentPart instanceof XSSFDrawing) {
      XSSFDrawing drawing = (XSSFDrawing) documentPart;
      List<XSSFShape> shapeList = drawing.getShapes();
      for (XSSFShape shape : shapeList) {
        if (shape instanceof XSSFPicture) {
          Picture picture = (XSSFPicture) shape;
          pictureList.add(picture);
        }
      }
    }
  }
  return pictureList;
}

代码示例来源：origin: org.openl.rules/org.openl.lib.poi.dev

/**
 * Gets all pictures from the Workbook.
 *
 * @return the list of pictures (a list of {@link XSSFPictureData} objects.)
 * @see #addPicture(byte[], int)
 */
public List<XSSFPictureData> getAllPictures() {
  if(pictures == null) {
    //In OOXML pictures are referred to in sheets,
    //dive into sheet's relations, select drawings and their images
    pictures = new ArrayList<XSSFPictureData>();
    for(XSSFSheet sh : sheets){
      for(POIXMLDocumentPart dr : sh.getRelations()){
        if(dr instanceof XSSFDrawing){
          for(POIXMLDocumentPart img : dr.getRelations()){
            if(img instanceof XSSFPictureData){
              pictures.add((XSSFPictureData)img);
            }
          }
        }
      }
    }
  }
  return pictures;
}

代码示例来源：origin: jbaliuka/x4j-analytic

public static List<Picture> getSheetPictures(XSSFSheet sheet) throws Exception {
    ArrayList<Picture> pictures = new ArrayList<Picture>();
    for (POIXMLDocumentPart relation : sheet.getRelations()) {
      if (relation instanceof XSSFDrawing) {
        for (POIXMLDocumentPart img : relation.getRelations()) {
          if (img instanceof XSSFPictureData) {
            pictures.add(parsePicture((XSSFPictureData) img));
          }
        }
      }
    }
    return pictures;
  }
}

代码示例来源：origin: jbaliuka/x4j-analytic

private void collectTables() {
  for (POIXMLDocumentPart p : sheet.getRelations()) {
    if (p.getPackageRelationship().getRelationshipType().equals(XSSFRelation.TABLE.getRelation())) {
      Table table = (Table) p;
      tables.add(table);                
    }
  }
}

代码示例来源：origin: jbaliuka/x4j-analytic

private void collectPivots() {
  for (POIXMLDocumentPart p : sheet.getRelations()) {
    if (p.getPackageRelationship().getRelationshipType().equals(XLSXFactory.PIVOT.getRelation())) {
      PivotTable table = (PivotTable) p;
      pivotTables.add(table);                
    }
  }
}

代码示例来源：origin: jbaliuka/x4j-analytic

private void savePivots(XSSFSheet sheet, XLXContext context, List<String> savedParts) throws Exception {
  for (POIXMLDocumentPart p : sheet.getRelations()) {
    if (p.getPackageRelationship().getRelationshipType().equals(XLSXFactory.PIVOT.getRelation())) {
      savePivotTable(context, savedParts, p);
    }
  }
}

代码示例来源：origin: jbaliuka/x4j-analytic

private POIXMLDocumentPart findLegacyDrawingPart(XSSFSheet sheet) {
  CTLegacyDrawing legacyDrawingHF = sheet.getCTWorksheet().getLegacyDrawingHF();
  if (legacyDrawingHF != null) {
    String id = legacyDrawingHF.getId();
    for (POIXMLDocumentPart relation : sheet.getRelations()) {
      if (relation instanceof XSSFVMLDrawing && relation.getPackageRelationship().getId().equals(id)) {
        return relation;
      }
    }
  }
  return null;
}

代码示例来源：origin: org.jeecg/easypoi-base

/**
 * 获取Excel2007图片
 * 
 * @param sheet
 *            当前sheet对象
 * @param workbook
 *            工作簿对象
 * @return Map key:图片单元格索引（1_1）String，value:图片流PictureData
 */
public static Map<String, PictureData> getSheetPictrues07(XSSFSheet sheet,
                             XSSFWorkbook workbook) {
  Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
  for (POIXMLDocumentPart dr : sheet.getRelations()) {
    if (dr instanceof XSSFDrawing) {
      XSSFDrawing drawing = (XSSFDrawing) dr;
      List<XSSFShape> shapes = drawing.getShapes();
      for (XSSFShape shape : shapes) {
        XSSFPicture pic = (XSSFPicture) shape;
        XSSFClientAnchor anchor = pic.getPreferredSize();
        CTMarker ctMarker = anchor.getFrom();
        String picIndex = ctMarker.getRow() + "_" + ctMarker.getCol();
        sheetIndexPicMap.put(picIndex, pic.getPictureData());
      }
    }
  }
  return sheetIndexPicMap;
}

代码示例来源：origin: zhangdaiscott/jeasypoi

/**
 * 获取Excel2007图片
 * 
 * @param sheet
 *            当前sheet对象
 * @param workbook
 *            工作簿对象
 * @return Map key:图片单元格索引（1_1）String，value:图片流PictureData
 */
public static Map<String, PictureData> getSheetPictrues07(XSSFSheet sheet, XSSFWorkbook workbook) {
  Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
  for (POIXMLDocumentPart dr : sheet.getRelations()) {
    if (dr instanceof XSSFDrawing) {
      XSSFDrawing drawing = (XSSFDrawing) dr;
      List<XSSFShape> shapes = drawing.getShapes();
      for (XSSFShape shape : shapes) {
        XSSFPicture pic = (XSSFPicture) shape;
        XSSFClientAnchor anchor = pic.getPreferredSize();
        CTMarker ctMarker = anchor.getFrom();
        String picIndex = ctMarker.getRow() + "_" + ctMarker.getCol();
        sheetIndexPicMap.put(picIndex, pic.getPictureData());
      }
    }
  }
  return sheetIndexPicMap;
}

代码示例来源：origin: cn.afterturn/easypoi-base

/**
 * 获取Excel2007图片
 *
 * @param sheet
 *            当前sheet对象
 * @param workbook
 *            工作簿对象
 * @return Map key:图片单元格索引（1_1）String，value:图片流PictureData
 */
public static Map<String, PictureData> getSheetPictrues07(XSSFSheet sheet,
                             XSSFWorkbook workbook) {
  Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
  for (POIXMLDocumentPart dr : sheet.getRelations()) {
    if (dr instanceof XSSFDrawing) {
      XSSFDrawing drawing = (XSSFDrawing) dr;
      List<XSSFShape> shapes = drawing.getShapes();
      for (XSSFShape shape : shapes) {
        if (shape instanceof XSSFPicture) {
          XSSFPicture pic = (XSSFPicture) shape;
          XSSFClientAnchor anchor = pic.getPreferredSize();
          CTMarker ctMarker = anchor.getFrom();
          String picIndex = ctMarker.getRow() + "_" + ctMarker.getCol();
          sheetIndexPicMap.put(picIndex, pic.getPictureData());
        }
      }
    }
  }
  return sheetIndexPicMap;
}

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

/**
 * @return the list of Single Xml Cells that provide a map rule to this mapping.
 */
public List<XSSFSingleXmlCell> getRelatedSingleXMLCell() {
  List<XSSFSingleXmlCell> relatedSimpleXmlCells = new ArrayList<>();
  int sheetNumber = mapInfo.getWorkbook().getNumberOfSheets();
  for (int i = 0; i < sheetNumber; i++) {
    XSSFSheet sheet = mapInfo.getWorkbook().getSheetAt(i);
    for (POIXMLDocumentPart p : sheet.getRelations()) {
      if (p instanceof SingleXmlCells) {
        SingleXmlCells singleXMLCells = (SingleXmlCells) p;
        for (XSSFSingleXmlCell cell : singleXMLCells.getAllSimpleXmlCell()) {
          if (cell.getMapId() == ctMap.getID()) {
            relatedSimpleXmlCells.add(cell);
          }
        }
      }
    }
  }
  return relatedSimpleXmlCells;
}

代码示例来源：origin: org.openl.rules/org.openl.lib.poi.dev

/**
 * @return the list of Single Xml Cells that provide a map rule to this mapping.
 */
public List<XSSFSingleXmlCell> getRelatedSingleXMLCell() {
  List<XSSFSingleXmlCell> relatedSimpleXmlCells = new Vector<XSSFSingleXmlCell>();
  int sheetNumber = mapInfo.getWorkbook().getNumberOfSheets();
  for (int i = 0; i < sheetNumber; i++) {
    XSSFSheet sheet = mapInfo.getWorkbook().getSheetAt(i);
    for (POIXMLDocumentPart p : sheet.getRelations()) {
      if (p instanceof SingleXmlCells) {
        SingleXmlCells singleXMLCells = (SingleXmlCells) p;
        for (XSSFSingleXmlCell cell : singleXMLCells.getAllSimpleXmlCell()) {
          if (cell.getMapId() == ctMap.getID()) {
            relatedSimpleXmlCells.add(cell);
          }
        }
      }
    }
  }
  return relatedSimpleXmlCells;
}

代码示例来源：origin: org.openl.rules/org.openl.lib.poi.dev

/**
   * @return the list of all Tables that provide a map rule to this mapping
   */
  public List<XSSFTable> getRelatedTables() {

    List<XSSFTable> tables = new Vector<XSSFTable>();
    int sheetNumber = mapInfo.getWorkbook().getNumberOfSheets();

    for (int i = 0; i < sheetNumber; i++) {
      XSSFSheet sheet = mapInfo.getWorkbook().getSheetAt(i);
      for (POIXMLDocumentPart p : sheet.getRelations()) {
        if (p.getPackageRelationship().getRelationshipType().equals(XSSFRelation.TABLE.getRelation())) {
          XSSFTable table = (XSSFTable) p;
          if (table.mapsTo(ctMap.getID())) {
            tables.add(table);
          }
        }
      }
    }

    return tables;
  }
}

代码示例来源：origin: cn.hutool/hutool-all

/**
 * 获取XLSX工作簿指定sheet中图片列表
 * 
 * @param workbook 工作簿{@link Workbook}
 * @param sheetIndex sheet的索引
 * @return 图片映射，键格式：行_列，值：{@link PictureData}
 */
private static Map<String, PictureData> getPicMapXlsx(XSSFWorkbook workbook, int sheetIndex) {
  final Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
  final XSSFSheet sheet = workbook.getSheetAt(sheetIndex);
  XSSFDrawing drawing;
  for (POIXMLDocumentPart dr : sheet.getRelations()) {
    if (dr instanceof XSSFDrawing) {
      drawing = (XSSFDrawing) dr;
      final List<XSSFShape> shapes = drawing.getShapes();
      XSSFPicture pic;
      CTMarker ctMarker;
      for (XSSFShape shape : shapes) {
        pic = (XSSFPicture) shape;
        ctMarker = pic.getPreferredSize().getFrom();
        sheetIndexPicMap.put(StrUtil.format("{}_{}", ctMarker.getRow(), ctMarker.getCol()), pic.getPictureData());
      }
    }
  }
  return sheetIndexPicMap;
}
// -------------------------------------------------------------------------------------------------------------- Private method end

代码示例来源：origin: org.openl.rules/org.openl.lib.poi.dev

protected void read(InputStream is) throws IOException {
  try {
    worksheet = WorksheetDocument.Factory.parse(is).getWorksheet();
  } catch (XmlException e){
    throw new POIXMLException(e);
  }
  initRows(worksheet);
  columnHelper = new ColumnHelper(worksheet);
  // Look for bits we're interested in
  for(POIXMLDocumentPart p : getRelations()){
    if(p instanceof CommentsTable) {
      sheetComments = (CommentsTable)p;
      break;
    }
    if(p instanceof XSSFTable) {
      tables.put( p.getPackageRelationship().getId(), (XSSFTable)p );
    }
  }
  
  // Process external hyperlinks for the sheet, if there are any
  initHyperlinks();
}

内容来源于网络，如有侵权，请联系作者删除！

XSSFSheet

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    XSSFSheet类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com