Skip to main content
A
Anonymous
November 25, 2006
Answered

cfx_ExcelQuery

  • November 25, 2006
  • 1 reply
  • 1234 views
Does anyone have any experience using the cfx_ExcelQuery custom tag which is part of the OpenXCF project?

I installed the tag and wrote a simple program to test the functionality.

If I call the custom tag w/ no arguments <cfx_ExcelQuery> CF throws an error indicating missing attributes, well & good.
But when I pass the attributes - I get a JRun Servlet Error

500 org/apache/poi/poifs/filesystem/POIFSFileSystem
org/apache/poi/poifs/filesystem/POIFSFileSystem

The error text appears to be coming from within the tag itself as I am running on a Windows server and what appears to be a directory path isn't related to anything on that server.

I originally tried passing the entire directory path to the file I'm trying to read, then moved that file to the same directory containing the test program, but same results either way.

Thanks in advance for any insights,
Ken
This topic has been closed for replies.
Correct answer cf_dev2
quote:
Originally posted by: MikerRoo
Download and install the Apache POI windows zip file.
Extract the "final" jar and place it in the CF lib folder.

You do not declare a CFX for POI but you do need to restart CF.


Yes cfx_excelQuery uses POI so the POI jar must also be installed somewhere in CF's classpath. We've been using poi-2.5.1-final-20040804.jar. I think its the latest stable version.

http://jakarta.apache.org/poi/

1 reply

A
Anonymous
November 25, 2006
Download and install the Apache POI windows zip file.
Extract the "final" jar and place it in the CF lib folder.

You do not declare a CFX for POI but you do need to restart CF.

Finally, You will probably need to specify the full path to the excel file.
EG. "C:\temp\38018_NOLAN.xls".
C
cf_dev2Correct answer
Inspiring
November 26, 2006
quote:
Originally posted by: MikerRoo
Download and install the Apache POI windows zip file.
Extract the "final" jar and place it in the CF lib folder.

You do not declare a CFX for POI but you do need to restart CF.


Yes cfx_excelQuery uses POI so the POI jar must also be installed somewhere in CF's classpath. We've been using poi-2.5.1-final-20040804.jar. I think its the latest stable version.

http://jakarta.apache.org/poi/
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices