使用 apache poi 读取 .xlsx 文件在 linux 机器上给出 org.apache.poi.POIXMLException [英] Reading .xlsx file using apache poi gives org.apache.poi.POIXMLException on linux machine
问题描述
我有一个应用程序可以读取 .xlsx 文件并向用户显示内容.该应用程序在 Windows 环境中运行良好.
I have an application which reads an .xlsx file and displays the content to the user. The application works fine on a windows environment.
我在 ubuntu 服务器上的 tomcat6 上部署了这个 Web 应用程序的 .war 文件.我也在服务器上复制了 .xlsx 文件.
I deployed the .war file of this web app on tomcat6 on a ubuntu server. I also copied the .xlsx files on the server.
代码中文件路径正确.
但是线
FileInputStream file = new FileInputStream(new File(FileName));
XSSFWorkbook workbook = new XSSFWorkbook(file);
报错
java.lang.reflect.InvocationTargetException
org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:62)
org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:403)
org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:155)
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:207)
com.qm.action.GetProjectNames.execute(GetProjectNames.java:107)
我已检查变量 FileName 是否包含服务器上文件的正确路径和文件名 (/usr/local/Metrics/MetricFiles/FY2013_Q2_GIT_Review_Metrics_by_LSS-GC.xlsx)
I have checked that the variable FileName contains the correct path and filename of the files on server(/usr/local/Metrics/MetricFiles/FY2013_Q2_GIT_Review_Metrics_by_LSS-GC.xlsx)
由于 ubunut 服务器是虚拟机，所以我使用 WinSCP 复制了 .xlsx 文件.文件的大小也是正确的.
Since the ubunut server is a VM, I had copied the .xlsx files using WinSCP. The size of the files is also correct.
为什么在linux平台上会出现这个错误?
Why is this error occurring on linux platform?
添加额外的异常跟踪
Caused by: java.lang.reflect.InvocationTargetException at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at
java.lang.reflect.Constructor.newInstance(Constructor.java:525) at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:60) ... 68 more
Caused by: java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOfRange(Arrays.java:2694) at java.lang.String.<init>(String.java:203) at
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseCdataLiteral(PiccoloLexer.java:3027) at
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseQuotedTagValue(PiccoloLexer.java:2936) at
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseAttributesNS(PiccoloLexer.java:1754) at
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseOpenTagNS(PiccoloLexer.java:1521) at
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseTagNS(PiccoloLexer.java:1362) at
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.yylex(PiccoloLexer.java:4678) at
org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yylex(Piccolo.java:1290) at
org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yyparse(Piccolo.java:1400) at
org.apache.xmlbeans.impl.piccolo.xml.Piccolo.parse(Piccolo.java:714) at
org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3439) at
org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1270) at
org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1257) at
org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:345) at
org.openxmlformats.schemas.spreadsheetml.x2006.main.StyleSheetDocument$Factory.parse(Unknown Source) at
org.apache.poi.xssf.model.StylesTable.readFrom(StylesTable.java:121) at
org.apache.poi.xssf.model.StylesTable.<init>(StylesTable.java:92) at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at
java.lang.reflect.Constructor.newInstance(Constructor.java:525) at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:60) at
org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:403) at
org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:155) at
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:207) at
com.qm.action.GetProjectNames.execute(GetProjectNames.java:107) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at
java.lang.reflect.Method.invoke(Method.java:601) at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)
推荐答案
提升对答案的评论...
Promoting a comment to an answer...
堆栈跟踪的关键部分是:
The key part of your stacktrace, which explains what has broken and why, is:
Caused by: java.lang.OutOfMemoryError: Java heap space at
java.util.Arrays.copyOfRange(Arrays.java:2694)
这告诉我们 Java 没有分配足够的内存来存储处理文件所需的所有数据
This is telling us that Java didn't have enough memory allocated to it to store all of the data that processing your file entails
如果您在增加 JVM 堆大小方面需要帮助，我建议您查看 上一个问题 或 这个，它们都会告诉你全部.
If you need help with increasing your JVM heap size, I would suggest you review this previous question or this one, which both talk you through it all.
这篇关于使用 apache poi 读取 .xlsx 文件在 linux 机器上给出 org.apache.poi.POIXMLException的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
