Skip to main content
October 21, 2009
Question

<cfspreadsheet> in ColdFusion 9 failing

  • October 21, 2009
  • 2 replies
  • 2373 views

Running CF 9 Standard v. 9,0,0,251028 (release version, not beta) on Windows Server 2003.  When executing a simple

     <cfspreadsheet action="read" src="#ExpandPath('incoming\test.xls')#" name="qSheet">

the template fails so badly that not even the debug information is displayed on the screen.  However, the application.log and exception.log files record the error each time (see excerpt below).  I've tried different .xls files with no success.  Do I need MS Excel installed on the server running CF?  Thanks.

"Error","jrpp-20","10/21/09","11:32:45",,"org.apache.poi.poifs.filesystem.POIFSFileSystem.hasPOIFSHeader(Ljava/io/InputStream;)Z The specific sequence of files included or processed is: C:\Inetpub\Internal\DBStatementImport\test.cfm, line: 114 "

java.lang.NoSuchMethodError: org.apache.poi.poifs.filesystem.POIFSFileSystem.hasPOIFSHeader(Ljava/io/InputStream;)Z

at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:59)

at coldfusion.excel.Excel.createNewWorkbook(Excel.java:132)

at coldfusion.excel.Excel.<init>(Excel.java:92)

at coldfusion.tagext.lang.SpreadSheetTag.saveToVar(SpreadSheetTag.java:274)

at coldfusion.tagext.lang.SpreadSheetTag.doStartTag(SpreadSheetTag.java:117)

at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)

at cftest2ecfm1163361770.runPage(C:\Inetpub\Internal\DBStatementImport\test.cfm:114)

at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)

at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)

at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)

at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363)

at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)

at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)

at coldfusion.filter.PathFilter.invoke(PathFilter.java:87)

at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)

at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)

at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)

at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)

at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)

at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)

at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)

at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53)

at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126)

at coldfusion.CfmServlet.service(CfmServlet.java:200)

at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)

at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)

at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)

at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)

at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)

at jrun.servlet.FilterChain.service(FilterChain.java:101)

at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)

at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)

at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)

at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)

at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)

at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)

at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)

at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)

at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

    This topic has been closed for replies.

    2 replies

    Inspiring
    October 18, 2010

    can you try hard coding the src path instead of using expandpath and see what happens.

    Inspiring
    October 21, 2009

    What JVM are you using?

    --

    Adam

    October 21, 2009

    JVM 14.0-b16, Java version 1.6.0_14.  The Windows server had CF 8 installed when CF 9 was installed, if that's an issue and/or helpful to know.  Thanks.

    Participant
    October 17, 2010

    what is your web root path pointing to  CF8 or CF9