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

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

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

HSSFWorkbook.close介绍

[英]Closes the underlying POIFSFileSystem from which the Workbook was read, if any.

Once this has been called, no further operations, updates or reads should be performed on the Workbook.
[中]关闭从中读取工作簿的底层文件系统（如果有）。
调用此函数后，不应对工作簿执行进一步的操作、更新或读取。

代码示例

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

  1. public static void main( String[] args ) throws IOException {
  2.     OutputStreamWriter osw = new OutputStreamWriter(System.out, Charset.defaultCharset());
  3.     PrintWriter pw = new PrintWriter(osw);
  4.     POIFSFileSystem fs = new POIFSFileSystem(new File(args[0]));
  5.     HSSFWorkbook wb = new HSSFWorkbook(fs);
  6.     try {
  7.       pw.println( "Drawing group:" );
  8.       wb.dumpDrawingGroupRecords(true);
  9.   
  10.       int i = 1;
  11.       for (Sheet sheet : wb)
  12.       {
  13.         pw.println( "Sheet " + i + "(" + sheet.getSheetName() + "):" );
  14.         ((HSSFSheet) sheet).dumpDrawingRecords(true, pw);
  15.       }
  16.     } finally {
  17.       wb.close();
  18.       fs.close();
  19.     }
  20.   }
  21. }

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

  1. wb.close();
  2. is.close();

代码示例来源：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: org.apache.poi/poi

  1. System.out.println(extractor.getText());
  2. extractor.close();
  3. wb.close();

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

  1. @Override
  2. public void close() throws IOException {
  3.   wb.close();
  4. }

代码示例来源：origin: youseries/ureport

  1. }finally{
  2.   try {
  3.     wb.close();
  4.   } catch (IOException e) {
  5.     e.printStackTrace();

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

  1. public static void main( String[] args ) throws IOException {
  2.     OutputStreamWriter osw = new OutputStreamWriter(System.out, Charset.defaultCharset());
  3.     PrintWriter pw = new PrintWriter(osw);
  4.     POIFSFileSystem fs = new POIFSFileSystem(new File(args[0]));
  5.     HSSFWorkbook wb = new HSSFWorkbook(fs);
  6.     try {
  7.       pw.println( "Drawing group:" );
  8.       wb.dumpDrawingGroupRecords(true);
  9.   
  10.       int i = 1;
  11.       for (Sheet sheet : wb)
  12.       {
  13.         pw.println( "Sheet " + i + "(" + sheet.getSheetName() + "):" );
  14.         ((HSSFSheet) sheet).dumpDrawingRecords(true, pw);
  15.       }
  16.     } finally {
  17.       wb.close();
  18.       fs.close();
  19.     }
  20.   }
  21. }

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

  1. wb.close();
  2. is.close();

代码示例来源：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: com.github.hazendaz/displaytag

  1. /**
  2.  * @see org.displaytag.export.BinaryExportView#doExport(java.io.OutputStream)
  3.  */
  4. @Override
  5. public void doExport(OutputStream out) throws IOException, JspException
  6. {
  7.   try
  8.   {
  9.     HSSFWorkbook wb = new HSSFWorkbook();
  10.     getHssfTableWriter(wb).writeTable(this.model, "-1");
  11.     wb.write(out);
  12.     wb.close();
  13.   }
  14.   catch (Exception e)
  15.   {
  16.     throw new HssfGenerationException(e);
  17.   }
  18. }

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

  1. workbook.close();
  2. file.close();

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

  1. /**
  2.  * Converts Excel file (97-2007) into XSL FO file.
  3.  * 
  4.  * @param xlsFile
  5.  *            file to process
  6.  * @return DOM representation of result XSL FO
  7.  */
  8. public static Document process( File xlsFile ) throws Exception
  9. {
  10.   final HSSFWorkbook workbook = AbstractExcelUtils.loadXls( xlsFile );
  11.   try {
  12.     ExcelToFoConverter excelToHtmlConverter = new ExcelToFoConverter(
  13.         XMLHelper.getDocumentBuilderFactory().newDocumentBuilder()
  14.             .newDocument() );
  15.     excelToHtmlConverter.processWorkbook( workbook );
  16.     return excelToHtmlConverter.getDocument();
  17.   } finally {
  18.     workbook.close();
  19.   }
  20. }

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

  1. wb.close();
  2. input.close();

代码示例来源：origin: xjs1919/util

  1. workbook.close();
  2. return out.toByteArray();

代码示例来源：origin: FutureCitiesCatapult/TomboloDigitalConnector

  1. workbook.close();

代码示例来源：origin: FutureCitiesCatapult/TomboloDigitalConnector

  1. workbook.close();

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

  1. embeddedWorkbook.close();
  2. } else if (contentType.equals("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")) {

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

  1. DirectoryNode dn = (DirectoryNode) obj.getDirectory();
  2.   HSSFWorkbook embeddedWorkbook = new HSSFWorkbook(dn, false);
  3.   embeddedWorkbook.close();
  4. } else if (oleName.equals("Document")) {
  5.   DirectoryNode dn = (DirectoryNode) obj.getDirectory();

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

  1. System.out.println(extractor.getText());
  2. extractor.close();
  3. wb.close();

代码示例来源：origin: com.github.hazendaz/displaytag

  1. wb.close();

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

HSSFWorkbook

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    HSSFWorkbook类方法

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