jacob 向excel里赋值时报错

Question

代码：

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)

Answer 1

公司的老框架

Answer 2

操作个Excel有POI不用，用这玩意，不是自己给自己找麻烦么