Do you have the poi lib in the app server classpath? Sent via BlackBerry by AT&T
-----Original Message----- From: "Subhakar Gummadi" <[EMAIL PROTECTED]> Date: Wed, 2 Apr 2008 12:20:26 To:"POI Users List" <[email protected]> Subject: Re: HSSFCell.setCellValue() Problem Hi, Here is the Runtime error.................. --------------------------------------------------- java.lang.NoSuchMethodError: setCellValue at com.pfizer.ac.service.eventchange.EventCancelSubmitEmail_Service.createExcelFile(EventCancelSubmitEmail_Service.java:378) at com.pfizer.ac.service.eventchange.EventCancelSubmitEmail_Service.submitCancelEvent(EventCancelSubmitEmail_Service.java:182) at com.pfizer.ac.action.eventchange.EventCancelSubmitEmail_Action.submit(EventCancelSubmitEmail_Action.java:129) at jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source) at java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown Source) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170) at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58) at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67) at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51) at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304) at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:225) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:127) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3214) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:1983) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:1890) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1344) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209) ------------------------------------------------------------------------------------------------------ Here is the Code Block that is referred in the Error Message ------------------------------------------------------------------------------------------------------ Line 371: cell = row.createCell((short)colCnt); Line 372: sheet.addMergedRegion(new Region(rowCnt, (short)colCnt, rowCnt, (short)(colCnt+3))); Line 374: cell.setCellType(HSSFCell.CELL_TYPE_STRING); Line 375: cell.setCellStyle(evtDetailsDataCellStyle); Line 377: HSSFRichTextString hrts1 = new HSSFRichTextString((String)evtEntity.getEvt_lname()); Line 378: cell.setCellValue(hrts1); ------------------------------------------------------------------------------------------------------ Please let me know if you need more information from me. Thanks, Subhakar. On Wed, Apr 2, 2008 at 12:07 PM, J Keller <[EMAIL PROTECTED]> wrote: > That code looks fine to me (but I'm no expert). > > Can you post what error you are getting? What line causes it? > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
