Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error trying to read xlsx into query #59

Open
ghost opened this issue Jul 29, 2014 · 3 comments
Open

Error trying to read xlsx into query #59

ghost opened this issue Jul 29, 2014 · 3 comments

Comments

@ghost
Copy link

ghost commented Jul 29, 2014

I'm running Railo 4.2.1.000 final and I get an error when trying to read an xlsx file into a query:

Run the cfspreadsheet-examples/Read_Spreadsheet_Into_Query.cfm - works great.
Change the filename to read from "someExistingFile.xls" to "someExistingFile.xlsx".
Run again, get this error:

"Could not initialize class org.apache.poi.openxml4j.opc.internal.unmarshallers.PackagePropertiesUnmarshaller"

@xouqoa
Copy link
Contributor

xouqoa commented Jul 30, 2014

I'm not sure you can just rename an .xls file to .xlsx and expect it to work. The underlying file format is completely different. Have you tried actually creating an .xlsx file in Excel (or whatever you have) and then running it against that file?

@ghost
Copy link
Author

ghost commented Jul 30, 2014

I didn't actually rename any files. The examples folder that comes in the download contains the same file in both the .xls and .xlsx format, but none of the samples actually used the .xlsx file. When I changed the Read_Spreadsheet_Into_Query.cfm code to read the other file instead, I get the error. This also happens when I try to read in my own .xlsx file. If I save it as an .xls it works, but not .xlsx format.

@apendrag0n3
Copy link

if you comment out the line in Spreadsheet.cfc that is calling "dom4j.jar" this should all you to read xlsx files.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants