[cfaussie] Re: Read an Excel spreadsheet...

2010-07-27 Thread Andrew
I have successfully used cfHSSF - http://cfhssf.riaforge.org/ - on CF8 and am still using it on CF9 (haven't tried cfspreadsheet because cfHSSF is still doing what I need). I did have to hack it a bit to get it working. If you would like me to send you my version of the CFC let me know. Andy. O

Re: [cfaussie] Read an Excel spreadsheet...

2010-07-27 Thread Paul Kukiel
The Apache POI project could help aswell here is a good demo from Ben Nadel: http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Read-And-Write-Excel-Files.htm Paul. On 27/07/2010 7:07 PM, Andrew Scott wrote: If you have the ColdFusion .Net extender installed you could alw

[cfaussie] Re: Read an Excel spreadsheet...

2010-07-27 Thread Pragnesh Vaghela
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" wrote: > Thanks Zac,

RE: [cfaussie] Read an Excel spreadsheet...

2010-07-27 Thread charlie arehart
Brett, by referring to me (in the original message in the thread) I suppose you may be pointing to my list of alternatives for processing Excel files in CF (http://www.carehart.org/cf411/#excel). Are you saying you've tried them all? Just checking to know what options you've considered. Back to

RE: [cfaussie] Read an Excel spreadsheet...

2010-07-27 Thread Andrew Scott
If you have the ColdFusion .Net extender installed you could always use .net to open, read and do what you need. Regards, Andrew Scott http://www.andyscott.id.au/ > -Original Message- > From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On > Behalf Of Brett Payne-Rhodes >

Re: [cfaussie] Read an Excel spreadsheet...

2010-07-27 Thread Brett Payne-Rhodes
Thanks Steve, If I had more understanding of the excel version then I might be tempted to go down this track but I can just imagine the fun given I think it is an xls file generated on the fly. And while I have MSSQL for development work I don't have it on the production server - M$ already t

Re: [cfaussie] Read an Excel spreadsheet...

2010-07-27 Thread Brett Payne-Rhodes
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

Re: [cfaussie] Read an Excel spreadsheet...

2010-07-27 Thread Brett Payne-Rhodes
Yep - Windoze... B) Andrew Scott wrote: Is this on a Windows machine? Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Brett Payne-Rhodes Sent: Tuesday, 27 July 2010 1:40 PM To: cfa