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>. > > For more options, visit this group at > > http://groups.google.com/group/cfaussie?hl=en. > > > -- > > Zac Spitzer > > Solution Architect / Director > > Ennoble Consultancy Australia > >http://www.ennoble.com.au > >http://zacster.blogspot.com > > +61 405 847 168 > > > -- > > You received this message because you are subscribed to the Google > > Groups "cfaussie" group. > > To post to this group, send email to cfaus...@googlegroups.com. > > To unsubscribe from this group, send email to > > cfaussie+unsubscr...@googlegroups.com. > > For more options, visit this group at > >http://groups.google.com/group/cfaussie?hl=en. > > -- > Brett Payne-Rhodes > YourSite Web Solutions > w:http://www.yoursite.net.au > e: 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 cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
