Brett,
At work we use jXLS a small and easy-to-use Java library for writing
Excel files using XLS templates and reading data from Excel into Java
objects using XML configuration. http://jxls.sourceforge.net/
Hope it helps.
Pragnesh
On Jul 27, 3:29 am, Brett Payne-Rhodes bret...@gmail.com wrote:
Thanks Zac,
I've looked at POI via Ben Nadal's POIutility.cfc but I couldn't get it to
read the file at all - it generated a Java object error. I also tried CFXL
and managed to get it to read the file but it couldn't read the actual cell
values.
Cheers,
B)
Zac Spitzer wrote:
have a look at apache POI tho the bundled version with CF is out of date
On 27 July 2010 14:03, Andrew Scott andr...@andyscott.id.au
mailto:andr...@andyscott.id.au wrote:
Is this on a Windows machine?
Regards,
Andrew Scott
http://www.andyscott.id.au/
-Original Message-
From: cfaussie@googlegroups.com
mailto:cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com
mailto:cfaussie@googlegroups.com] On
Behalf Of Brett Payne-Rhodes
Sent: Tuesday, 27 July 2010 1:40 PM
To: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com
Subject: Re: [cfaussie] Read an Excel spreadsheet...
Hi Andrew,
Thanks... Excel isn't involved as the file is being delivered via
email. I
need to
read it in and process the contents - sadly other formats are not
available. I
worked out that CFXL could read the file and found the rows but
something
in the format of the file meant that it could not read the cells...
I'm now working on a two step approach to convert the file to CSV
when it
is
delivered and then process the content... Its clunky and I hate
cfexecute
but
it seems I have no choice right now.
B)
Andrew Scott wrote:
Brett,
The most common mistake that people tend to make, and I am
hoping this
is not something that you are doing. Is that ColdFusion can't
load the
spreadsheet with whatever means you are trying, unless you
close the
spreadhseet in Excel.
By the sounds of it this might be what is happening.
Regards,
Andrew Scott
http://www.andyscott.id.au/
-Original Message-
From: cfaussie@googlegroups.com
mailto:cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com
mailto:cfaussie@googlegroups.com]
On
Behalf Of Brett Payne-Rhodes
Sent: Sunday, 25 July 2010 2:50 PM
To: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com
Subject: [cfaussie] Read an Excel spreadsheet...
Hi,
I'm looking at the options to read an excel spreadsheet and
despite
all
the
good stuff I have found from people like Ben Nadal and Charlie
Arehart nothing seems to want to work 'as advertised'. I
headed down
the path of using Java and the POI library via Ben's
POIutility.cfc
but couldn't get
it to read
the file - dunno why, it was a weird java error. I then tried
CFXL by
Jason
Delmore and while I can get that to read the demo excel file
it won't
read
the
one I need it to read.
I know there are a few more options but I was just wondering if
anyone
here
had done this before and could let me know what worked for them...
Many thanks,
Brett
B)
--
Brett Payne-Rhodes
YourSite Web Solutions
w:http://www.yoursite.net.au
e: br...@ehc.net.au mailto:br...@ehc.net.au
t: +61 (0)8 9371-0471
m: +61 (0)414 371 047
--
Brett Payne-Rhodes
YourSite Web Solutions
w:http://www.yoursite.net.au
e: br...@ehc.net.au mailto:br...@ehc.net.au
t: +61 (0)8 9371-0471
m: +61 (0)414 371 047
--
You received this message because you are subscribed to the
Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
mailto:cfaussie@googlegroups.com.
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com
mailto:cfaussie%2bunsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en.
--
You received this message because you are subscribed to the Google
Groups cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
mailto:cfaussie@googlegroups.com.
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com
mailto:cfaussie%2bunsubscr...@googlegroups.com.