[cfaussie] Re: Read an Excel spreadsheet...
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, > > 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 > <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 &
[cfaussie] Re: Enable Global Script Protection in CF8 server setup warning
Rob, The list of tags can be found in your neo-security.xml (CFInstallDirectory\lib\) <InvalidTag Pragnesh On May 6, 11:09 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hi People, > > Just a heads up, we have a lovely new server here and while setting it > up we decided to enable the "Enable Global Script Protection" in > CFADMIN8 you can never be too careful when you work in the mean > streets of education. > > Well the teachers started to complain that they could no longer embed > youtube videos into their online units (serious this in the end of the > world!) .. We thought it may have been our implementation of fckEditor > (2.6 pretty hot) , our theory was, fckie was changing the object and > embed tag to "invalidtag" on form post which sounds like a typical > wysiwyg black magic trick. However after reading ever single line of > fckeditor's config looking for a blacklist of tags, dumping the form > scope and finding fckeditor was behaving itself, we thought we would > just try and disable the Enable Global Script Protection in cfadmin. > We restarted the server and it worked! Teachers and Students can now > embed their movies! Thank god PEACE! > > I mean i can see how it would be useful if your users are punks, but > in this web2.0 time i cant see much use for a blanket ban on all cross > site stuff, would be more useful if you could choose tags to disable. > > Just thought i would share... > > Rob. --~--~-~--~~~---~--~~ 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 To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CF8 free upgrade (buy cfmx7 now or wait?)
Clue maybe something is happening next week. http://www.coldfusionjedi.com/index.cfm/2007/7/27/More-on-ColdFusion-8-Server-Alerts --~--~-~--~~~---~--~~ 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 To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: List of Aussie Coldfusion sites hosted in the US.
Robin, This is to give them a better price range for their hosting needs. Have to show advantages against their PHP quote :-). Pragnesh --~--~-~--~~~---~--~~ 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 To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] List of Aussie Coldfusion sites hosted in the US.
Hi All, A client of mine is nervous about moving their hosting to the US. If you could please just ping back with a list of Aussie Coldfusion sites that are hosted in the US it will be greatly appreciated. Thanking in advance. Pragnesh --~--~-~--~~~---~--~~ 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 To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFAussie Community Head Count
ping --~--~-~--~~~---~--~~ 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 To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Restarting the CFAPP from the URL
onRequestStart() structClear(application); structClear(session); onApplicationStart(); --~--~-~--~~~---~--~~ 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 To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Cold Fusion Tutor - hourly rate
Hi Pete, I live on the GC. Feel free to send me any questions to my gmail. --~--~-~--~~~---~--~~ 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 To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
