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

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

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

HSSFWorkbook.getInternalWorkbook介绍

暂无

代码示例

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

  1. public static void writeToFile(OutputStream fos, InputStream xlsWorkbook, boolean excludeWorkbookRecords, String[] params) throws IOException {
  2. HSSFWorkbook workbook = new HSSFWorkbook(xlsWorkbook);
  3. InternalWorkbook internalWorkbook = workbook.getInternalWorkbook();
  4. DrawingGroupRecord r = (DrawingGroupRecord) internalWorkbook.findFirstRecordBySid(DrawingGroupRecord.sid);
  5. StringBuilder builder = new StringBuilder();
  6. builder.append("<workbook>\n");
  7. String tab = "\t";
  8. if (!excludeWorkbookRecords && r != null) {
  9. r.decode();
  10. List<EscherRecord> escherRecords = r.getEscherRecords();
  11. for (EscherRecord record : escherRecords) {
  12. builder.append(record.toXml(tab));
  13. }
  14. }
  15. List<Integer> sheets = getSheetsIndexes(params, workbook);
  16. for (Integer i : sheets) {
  17. HSSFPatriarch p = workbook.getSheetAt(i).getDrawingPatriarch();
  18. if(p != null ) {
  19. builder.append(tab).append("<sheet").append(i).append(">\n");
  20. builder.append(p.getBoundAggregate().toXml(tab + "\t"));
  21. builder.append(tab).append("</sheet").append(i).append(">\n");
  22. }
  23. }
  24. builder.append("</workbook>\n");
  25. fos.write(builder.toString().getBytes(StringUtil.UTF8));
  26. fos.close();
  27. workbook.close();
  28. }

代码示例来源:origin: ZuInnoTe/hadoopoffice

  1. InternalWorkbook intWb = ((HSSFWorkbook)this.currentWorkbook).getInternalWorkbook();

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

  1. public static void writeToFile(OutputStream fos, InputStream xlsWorkbook, boolean excludeWorkbookRecords, String[] params) throws IOException {
  2. HSSFWorkbook workbook = new HSSFWorkbook(xlsWorkbook);
  3. InternalWorkbook internalWorkbook = workbook.getInternalWorkbook();
  4. DrawingGroupRecord r = (DrawingGroupRecord) internalWorkbook.findFirstRecordBySid(DrawingGroupRecord.sid);
  5. StringBuilder builder = new StringBuilder();
  6. builder.append("<workbook>\n");
  7. String tab = "\t";
  8. if (!excludeWorkbookRecords && r != null) {
  9. r.decode();
  10. List<EscherRecord> escherRecords = r.getEscherRecords();
  11. for (EscherRecord record : escherRecords) {
  12. builder.append(record.toXml(tab));
  13. }
  14. }
  15. List<Integer> sheets = getSheetsIndexes(params, workbook);
  16. for (Integer i : sheets) {
  17. HSSFPatriarch p = workbook.getSheetAt(i).getDrawingPatriarch();
  18. if(p != null ) {
  19. builder.append(tab).append("<sheet").append(i).append(">\n");
  20. builder.append(p.getBoundAggregate().toXml(tab + "\t"));
  21. builder.append(tab).append("</sheet").append(i).append(">\n");
  22. }
  23. }
  24. builder.append("</workbook>\n");
  25. fos.write(builder.toString().getBytes(StringUtil.UTF8));
  26. fos.close();
  27. workbook.close();
  28. }

代码示例来源:origin: openl-tablets/openl-tablets

  1. @Override
  2. public boolean isUse1904Windowing() throws ExcelParseException {
  3. try {
  4. initializeWorkbook();
  5. if (workbook instanceof XSSFWorkbook) {
  6. return ((XSSFWorkbook) workbook).isDate1904();
  7. } else if (workbook instanceof HSSFWorkbook) {
  8. return ((HSSFWorkbook) workbook).getInternalWorkbook().isUsing1904DateWindowing();
  9. }
  10. throw new UnsupportedOperationException("Unsupported workbook type");
  11. } catch (IOException e) {
  12. throw new ExcelParseException(e);
  13. }
  14. }

代码示例来源:origin: docbleach/DocBleach

  1. protected static void cleanupAndSaveExcel97(POIFSFileSystem fs, OutputStream outputStream)
  2. throws IOException {
  3. Workbook wb = WorkbookFactory.create(fs);
  4. if (wb instanceof HSSFWorkbook) {
  5. HSSFWorkbook hwb = (HSSFWorkbook) wb;
  6. InternalWorkbook internal = hwb.getInternalWorkbook();
  7. if (internal != null) {
  8. LOGGER.trace("# of Records: {}", internal.getNumRecords());
  9. removeObProjRecord(internal.getRecords());
  10. LOGGER.trace("# of Records: {}", internal.getNumRecords());
  11. }
  12. }
  13. wb.write(outputStream);
  14. }

相关文章

HSSFWorkbook类方法