org.apache.poi.hssf.usermodel.HSSFWorkbook.getAllEmbeddedObjects()方法的使用及代码示例

x33g5p2x  于2022-01-20 转载在 其他  
字(5.1k)|赞(0)|评价(0)|浏览(182)

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

HSSFWorkbook.getAllEmbeddedObjects介绍

[英]Gets all embedded OLE2 objects from the Workbook.
[中]从工作簿中获取所有嵌入的OLE2对象。

代码示例

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

  1. /**
  2. * Gets all embedded OLE2 objects from the Workbook.
  3. *
  4. * @return the list of embedded objects (a list of {@link HSSFObjectData} objects.)
  5. */
  6. public List<HSSFObjectData> getAllEmbeddedObjects()
  7. {
  8. List<HSSFObjectData> objects = new ArrayList<>();
  9. for (HSSFSheet sheet : _sheets)
  10. {
  11. getAllEmbeddedObjects(sheet, objects);
  12. }
  13. return Collections.unmodifiableList(objects);
  14. }

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

  1. /**
  2. * Gets all embedded OLE2 objects from the Workbook.
  3. *
  4. * @param sheet embedded object attached to
  5. * @param objects the list of embedded objects to populate.
  6. */
  7. private void getAllEmbeddedObjects(HSSFSheet sheet, List<HSSFObjectData> objects)
  8. {
  9. HSSFPatriarch patriarch = sheet.getDrawingPatriarch();
  10. if (null == patriarch){
  11. return;
  12. }
  13. getAllEmbeddedObjects(patriarch, objects);
  14. }
  15. /**

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

  1. /**
  2. * Recursively iterates a shape container to get all embedded objects.
  3. *
  4. * @param parent the parent.
  5. * @param objects the list of embedded objects to populate.
  6. */
  7. private void getAllEmbeddedObjects(HSSFShapeContainer parent, List<HSSFObjectData> objects)
  8. {
  9. for (HSSFShape shape : parent.getChildren()) {
  10. if (shape instanceof HSSFObjectData) {
  11. objects.add((HSSFObjectData) shape);
  12. } else if (shape instanceof HSSFShapeContainer) {
  13. getAllEmbeddedObjects((HSSFShapeContainer) shape, objects);
  14. }
  15. }
  16. }
  17. @Override

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

  1. /**
  2. * Gets all embedded OLE2 objects from the Workbook.
  3. *
  4. * @return the list of embedded objects (a list of {@link HSSFObjectData} objects.)
  5. */
  6. public List<HSSFObjectData> getAllEmbeddedObjects()
  7. {
  8. List<HSSFObjectData> objects = new ArrayList<>();
  9. for (HSSFSheet sheet : _sheets)
  10. {
  11. getAllEmbeddedObjects(sheet, objects);
  12. }
  13. return Collections.unmodifiableList(objects);
  14. }

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

  1. /**
  2. * Gets all embedded OLE2 objects from the Workbook.
  3. *
  4. * @param sheet embedded object attached to
  5. * @param objects the list of embedded objects to populate.
  6. */
  7. private void getAllEmbeddedObjects(HSSFSheet sheet, List<HSSFObjectData> objects)
  8. {
  9. HSSFPatriarch patriarch = sheet.getDrawingPatriarch();
  10. if (null == patriarch){
  11. return;
  12. }
  13. getAllEmbeddedObjects(patriarch, objects);
  14. }
  15. /**

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

  1. /**
  2. * Recursively iterates a shape container to get all embedded objects.
  3. *
  4. * @param parent the parent.
  5. * @param objects the list of embedded objects to populate.
  6. */
  7. private void getAllEmbeddedObjects(HSSFShapeContainer parent, List<HSSFObjectData> objects)
  8. {
  9. for (HSSFShape shape : parent.getChildren()) {
  10. if (shape instanceof HSSFObjectData) {
  11. objects.add((HSSFObjectData) shape);
  12. } else if (shape instanceof HSSFShapeContainer) {
  13. getAllEmbeddedObjects((HSSFShapeContainer) shape, objects);
  14. }
  15. }
  16. }
  17. @Override

代码示例来源:origin: com.haulmont.thirdparty/poi

  1. /**
  2. * Gets all embedded OLE2 objects from the Workbook.
  3. *
  4. * @return the list of embedded objects (a list of {@link HSSFObjectData} objects.)
  5. */
  6. public List<HSSFObjectData> getAllEmbeddedObjects()
  7. {
  8. List<HSSFObjectData> objects = new ArrayList<HSSFObjectData>();
  9. for (int i = 0; i < getNumberOfSheets(); i++)
  10. {
  11. getAllEmbeddedObjects(getSheetAt(i), objects);
  12. }
  13. return objects;
  14. }

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

  1. /**
  2. * Gets all embedded OLE2 objects from the Workbook.
  3. *
  4. * @return the list of embedded objects (a list of {@link HSSFObjectData} objects.)
  5. */
  6. public List<HSSFObjectData> getAllEmbeddedObjects()
  7. {
  8. List<HSSFObjectData> objects = new ArrayList<HSSFObjectData>();
  9. for (int i = 0; i < getNumberOfSheets(); i++)
  10. {
  11. getAllEmbeddedObjects(getSheetAt(i).getSheet().getRecords(), objects);
  12. }
  13. return objects;
  14. }

代码示例来源:origin: stackoverflow.com

  1. import java.io.*;
  2. import java.net.URL;
  3. import org.apache.poi.hssf.usermodel.*;
  4. import org.apache.poi.poifs.filesystem.*;
  5. import org.apache.poi.util.IOUtils;
  6. public class EmbeddedPdfInExcel {
  7. public static void main(String[] args) throws Exception {
  8. NPOIFSFileSystem fs = new NPOIFSFileSystem(new URL("http://jamesshaji.com/sample.xls").openStream());
  9. HSSFWorkbook wb = new HSSFWorkbook(fs.getRoot(), true);
  10. for (HSSFObjectData obj : wb.getAllEmbeddedObjects()) {
  11. String oleName = obj.getOLE2ClassName();
  12. DirectoryNode dn = (DirectoryNode)obj.getDirectory();
  13. if(oleName.contains("Acro") && dn.hasEntry("CONTENTS")){
  14. InputStream is = dn.createDocumentInputStream("CONTENTS");
  15. FileOutputStream fos = new FileOutputStream(obj.getDirectory().getName()+".pdf");
  16. IOUtils.copy(is, fos);
  17. fos.close();
  18. is.close();
  19. }
  20. }
  21. fs.close();
  22. }
  23. }

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

  1. POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(args[0]));
  2. try (HSSFWorkbook workbook = new HSSFWorkbook(fs)) {
  3. for (HSSFObjectData obj : workbook.getAllEmbeddedObjects()) {

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

  1. public static void loadEmbedded(HSSFWorkbook workbook) throws IOException {
  2. for (HSSFObjectData obj : workbook.getAllEmbeddedObjects()) {

相关文章

HSSFWorkbook类方法