相关文章
更多最近更新
更多java jxl 操作excel 时老是这个错误
2019-03-25 13:32|来源: 网路
代码如下：
InputStream iso = new FileInputStream(filepath);//写入到FileInputStream
Workbook wb = Workbook.getWorkbook(iso);//得到工作薄
jxl.Sheet rs = wb.getSheet(0);
执行到此处时就报错了。错误如下：
java.lang.ClassCastException: java.lang.UnsupportedClassVersionError
at com.tempus.base.BaseAction.execute(BaseAction.java:84)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.tempus.base.filter.EncodingFilter.doFilter(EncodingFilter.java:19)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
同样的代码放到myeclipse9.0里面后
执行到：jxl.Sheet rs = wb.getSheet(0);这句报错：
java.lang.ClassCastException: java.lang.OutOfMemoryError cannot be cast to java.lang.Exception
问题补充：
嗯，对的，谢谢
InputStream iso = new FileInputStream(filepath);//写入到FileInputStream
Workbook wb = Workbook.getWorkbook(iso);//得到工作薄
jxl.Sheet rs = wb.getSheet(0);
执行到此处时就报错了。错误如下：
java.lang.ClassCastException: java.lang.UnsupportedClassVersionError
at com.tempus.base.BaseAction.execute(BaseAction.java:84)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.tempus.base.filter.EncodingFilter.doFilter(EncodingFilter.java:19)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
同样的代码放到myeclipse9.0里面后
执行到：jxl.Sheet rs = wb.getSheet(0);这句报错：
java.lang.ClassCastException: java.lang.OutOfMemoryError cannot be cast to java.lang.Exception
问题补充：
lx281 写道
java.lang.ClassCastException: java.lang.UnsupportedClassVersionError
这句话的意思是你现在用的这个jar包编译时用的jdk和你执行代码所用的jdk版本不一致，你目前用的这个jdk版本比那个低
这句话的意思是你现在用的这个jar包编译时用的jdk和你执行代码所用的jdk版本不一致，你目前用的这个jdk版本比那个低
嗯，对的，谢谢
相关问答
更多-
java 使用jxl操作excel，向excel中插入对象[2023-08-01]
应该是不能 对象这个东西Excel根本就没有 你咋加到他上边 就和想把Excel的公式导到MyEclipse里面一样 -
java用jxl操作excel时，excel表格线如何显示？？[2022-02-08]
添加内容的时候不要把模板中的表格对象覆盖掉，最好把你的代码发上来。 -
java jxl生成excel文件如何排序？[2022-03-06]
你在写sql语句的时候就事先通过order by 语句按哪一列或是哪几列排好了，那样导出的EXCEL表格是按你想排的那子了。希望能理解哈。 -
使用jxl进行Excel解析(Excel parsing using jxl)[2022-03-13]
根据javadocs / 2_6_10 / docs / jxl / Cell方法： getContents（）是一个“Quick and dirty函数，用于将此单元格的内容作为字符串返回。” 由于getContents（）不允许完全控制格式，因此您可以定义自己的函数来控制CellType.DATE的格式; 例如： private String getContents(Cell cell) { DateCell dCell=null; if(cell.getType() == CellT ... -
提高虚拟机的可用内存（带-Xms和-Xmx）不是一个选项吗？ Is raising the memory available to the VM (with -Xms and -Xmx) not an option?
-
在jxl中写入Excel(Writing to Excel in jxl)[2022-09-15]
在这里我没有看到问题，因为我们正在处理可能会失败的文件IO，所以会出现异常。 你可以修改下面的代码，它应该适合你。 import java.io.File; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; public class MyClass { public static void main(String[] ar ... -
合并细胞 - 是的 创建图表 - 我不相信。 背景颜色 - 是的 背景颜色与渐变 - 没有 名称表 - 是的 设置工作表的访问权限 - 是 Merging Cells - Yes Creating Graphs - I don't believe so. Background colors - Yes Background colors with gradients - No Name Sheets - Yes Set access rights to sheets - Yes
-
使用jxl api将新列插入到现有的excel文件中(Inserting new column to an already existing excel file using jxl api)[2023-02-15]
可能你使用的api并不是最好的。 我也有这个问题（insertcolumn行的nullpointer异常）并且在我下载jexcelapi之前找不到任何解决方案。 HTH Probably the api you are using is not the best one. I also had this problem (nullpointer exception at the insertcolumn line) and couldnt find any solution until I download ... -
使用以下方法获取特定工作表; 如果它为null，则创建一个新的： Sheet getSheet(String name) use following method to get a specific sheet; if it's null, create a new one: Sheet getSheet(String name)
-
默认情况下，Excel文件使用windows-1255（Cp1255）编码。 因此，当您从excel文件中读取这些字节时，您需要使用该字符集处理它们，然后使用utf8存储它们。 Excel files by default uses windows-1255 (Cp1255) codification. So when you read those bytes from the excel file you need to treat them with that charset and then stor ...