Spreadsheet cfc problem

I am attempting to use the cfsimplicity cfspreadsheet cfc library to read a
simple spreadsheet into a query.
Using the example code from github I have this:

mypath="file.xls"; spreadsheet=New spreadsheet_cfc.Spreadsheet(); myQuery=spreadsheet.read( src=mypath,format="query" );

I get this error The key [WORKBOOK] does not exist, but there is a similar
key with name [WORKBOOKFROMQUERY] available.
The error occurred on line 870 in file spreadsheet_cfc/Spreadsheet.cfc.

This is on a fresh install of Lucee 10,0,0,0 on Linux
3.10.0-327.18.2.el7.x86_64

Can anyone help? I am new to Lucee and missing something…

Might n ed the full path to the fileOn Thursday, 4 August 2016, Henry Gelstor <@Henry_Gelstor> wrote:

I am attempting to use the cfsimplicity cfspreadsheet cfc library to read
a simple spreadsheet into a query.
Using the example code from github I have this:

mypath="file.xls"; spreadsheet=New spreadsheet_cfc.Spreadsheet(); myQuery=spreadsheet.read( src=mypath,format="query" );

I get this error The key [WORKBOOK] does not exist, but there is a
similar key with name [WORKBOOKFROMQUERY] available.
The error occurred on line 870 in file spreadsheet_cfc/Spreadsheet.cfc.

This is on a fresh install of Lucee 10,0,0,0 on Linux
3.10.0-327.18.2.el7.x86_64

Can anyone help? I am new to Lucee and missing something…


Get 10% off of the regular price for this years CFCamp in Munich, Germany
(Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp. 189€
instead of 210€. Visit
https://ti.to/cfcamp/cfcamp-2016/discount/Lucee@cfcamp

You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com
<javascript:_e(%7B%7D,‘cvml’,‘lucee%2Bunsubscribe@googlegroups.com’);>.
To post to this group, send email to lucee@googlegroups.com
<javascript:_e(%7B%7D,‘cvml’,‘lucee@googlegroups.com’);>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/dbb7efeb-4b4c-4424-8aa6-502734cda04e%40googlegroups.com
https://groups.google.com/d/msgid/lucee/dbb7efeb-4b4c-4424-8aa6-502734cda04e%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

AJ Mercer
<webonix:net strength=“Industrial” /> http://webonix.net | <webonix:org
community=“Open” /> http://webonix.org
http://twitter.com/webonix

Wow! Thanks again for that- No wonder- its over 20 years old! HenryOn 8/4/2016 2:46 PM, Julian Halliwell wrote:

Thanks for sending me the file, Henry.

The problem is that the file was created using an older version of
Excel which isn’t supported by POI, the Java Library that’s used to
provide the spreadsheet functionality.

If you open the file in Excel, do File > Save As… and then choose
“Microsoft Excel 97/2000/XP” as the format, you should find that it
works.

I’ll add a ticket to the Spreadsheet Library repo to improve the error
message to warn that files need to be in this format or later.

Cheers
Julian.

On 4 August 2016 at 15:40, Julian Halliwell wrote:

Sounds like something specific to your XLS file that’s preventing it
from being read as a Spreadsheet object.

I’d be happy to take a look if you’re able to share the file in
question. You can email it to julianhalliwell at gmail dot com.

Julian (aka cfsimplicity).

On 4 August 2016 at 00:45, Henry Gelstor wrote:

I did install the cfspreadsheet extension and got an almost identical error
message. The difference was “Workbook” and “Book” keys. Backtracking to the
extension examples I found they they worked. And the spreadsheet file
included with the demos works with my test page, just not the spreadsheet I
need it to.

Sounds like something specific to your XLS file that’s preventing it
from being read as a Spreadsheet object.

I’d be happy to take a look if you’re able to share the file in
question. You can email it to julianhalliwell at gmail dot com.

Julian (aka cfsimplicity).On 4 August 2016 at 00:45, Henry Gelstor <@Henry_Gelstor> wrote:

I did install the cfspreadsheet extension and got an almost identical error
message. The difference was “Workbook” and “Book” keys. Backtracking to the
extension examples I found they they worked. And the spreadsheet file
included with the demos works with my test page, just not the spreadsheet I
need it to.

still guessing - what version of excel is the file?On 4 August 2016 at 07:45, Henry Gelstor <@Henry_Gelstor> wrote:

Thank You but, nope it definitely finds the xls file. When i change it I
get a file not found error.
I did install the cfspreadsheet extension and got an almost identical
error message. The difference was “Workbook” and “Book” keys. Backtracking
to the extension examples I found they they worked. And the spreadsheet
file included with the demos works with my test page, just not the
spreadsheet I need it to. I did try renaming the worksheet to"Sheet" to no
avail.
i’m going to put the data from mine into a brand new xls… and then maybe
into the demo’s sample sheet… see what happens.
Someone out there knows exactly what this error is-- Thx H.

On Wednesday, August 3, 2016 at 5:20:32 PM UTC-5, AJ Mercer wrote:

Might n ed the full path to the file


Get 10% off of the regular price for this years CFCamp in Munich, Germany
(Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp. 189€
instead of 210€. Visit
https://ti.to/cfcamp/cfcamp-2016/discount/Lucee@cfcamp


You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/ddb49149-d01d-4598-b2bd-bd5fe701d9d1%40googlegroups.com
https://groups.google.com/d/msgid/lucee/ddb49149-d01d-4598-b2bd-bd5fe701d9d1%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

AJ Mercer
<webonix:net strength=“Industrial” /> http://webonix.net | <webonix:org
community=“Open” /> http://webonix.org
http://twitter.com/webonix

Thanks for sending me the file, Henry.

The problem is that the file was created using an older version of
Excel which isn’t supported by POI, the Java Library that’s used to
provide the spreadsheet functionality.

If you open the file in Excel, do File > Save As… and then choose
“Microsoft Excel 97/2000/XP” as the format, you should find that it
works.

I’ll add a ticket to the Spreadsheet Library repo to improve the error
message to warn that files need to be in this format or later.

Cheers
Julian.On 4 August 2016 at 15:40, Julian Halliwell wrote:

Sounds like something specific to your XLS file that’s preventing it
from being read as a Spreadsheet object.

I’d be happy to take a look if you’re able to share the file in
question. You can email it to julianhalliwell at gmail dot com.

Julian (aka cfsimplicity).

On 4 August 2016 at 00:45, Henry Gelstor wrote:

I did install the cfspreadsheet extension and got an almost identical error
message. The difference was “Workbook” and “Book” keys. Backtracking to the
extension examples I found they they worked. And the spreadsheet file
included with the demos works with my test page, just not the spreadsheet I
need it to.

Ah right, there you go.

I’ve fixed the error message now so anyone else running up against the
same issue will get a more helpful explanation:

https://github.com/cfsimplicity/lucee-spreadsheet/issues/88On 4 August 2016 at 21:07, Henry Gelstor <@Henry_Gelstor> wrote:

Wow! Thanks again for that- No wonder- its over 20 years old! Henry