jacob 向excel里赋值时报错?报错
代码：
excelBean.OpenExcel(util.GetSessionValue("ROOT")+"temp/order/test.xlsx", false);
String attachmentPdfName=util.GetOnlyID()+".pdf";
//System.out.print("\n attachmentPdfName="+attachmentPdfName);
excelBean.setValue("aaa", "bbbbb");－－－这句报错
excelBean.SaveToPDF(attachmentRootPath+attachmentPdfName);//把excel另存为pdf
报错内容：
com.jacob.com.ComFailException: Invoke of: Range
Source:Description:
at com.jacob.com.Dispatch.invokev(Native Method)
at com.jacob.com.Dispatch.invokev(Dispatch.java:945)
at com.jacob.com.Dispatch.invoke(Dispatch.java:604)
at com.care.lims6.ExcelBean.setValue(ExcelBean.java:339)
at org.apache.jsp.pdm.web.printOrderAttachment_jsp._jspService(printOrderAttachment_jsp.java:139)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
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:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
写回答
-
https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIBsetValue方法和网上的一样，这报错不科学
publicvoidsetValue(Stringposition,Objectvalue)
/* */ {
/*338*/ this.currentSheet=getCurrentSheet();
/*339*/ Dispatchcell=Dispatch.invoke(this.currentSheet,"Range",
/*340*/ 2,newObject[]{position},newint[1])
/*341*/ .toDispatch();
/*342*/ Dispatch.put(cell,"Value",value);
/* */ }
操作个Excel有POI不用，用这玩意，不是自己给自己找麻烦么公司的老框架2020-06-08 19:53:32赞同 展开评论 打赏
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
