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> 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: 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:cfaus...@googlegroups.com] > > On > > >> Behalf Of Brett Payne-Rhodes > > >> Sent: Sunday, 25 July 2010 2:50 PM > > >> To: 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 > > >> 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 > > 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<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 cfaus...@googlegroups.com. > To unsubscribe from this group, send email to > cfaussie+unsubscr...@googlegroups.com<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.
