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

2010-08-03 Thread Brett Payne-Rhodes
Yeah, but its just another cfcomponent... B) On Tue, Aug 3, 2010 at 2:02 PM, Barry Beattie wrote: > > At least now I know a lot more about POI than I did before... > > > enough for a quick CFUG presentation? > > -- > You received this message because you are subscribed to the Google Groups > "

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

2010-08-02 Thread Barry Beattie
> At least now I know a lot more about POI than I did before... enough for a quick CFUG presentation? -- 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, s

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

2010-08-02 Thread Brett Payne-Rhodes
I can't quote the forum that I read it on but yes, the problem has been mentioned and was what got me thinking that it was the file that was at fault. Someone said that an excel file they were trying to read was failing but after removing a couple of lines that it could be read without issue. I do

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

2010-07-31 Thread Barry Beattie
" It seems to me that something isn't quite right with the POI library" Ewww... is there any mention anywhere (Java/POI forums) of this? If you're quite right, it could either be a bug or incompatibility in the POI library... ... or Excel and Open Office are a lot more forgiving with sloppy form

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

2010-07-30 Thread Brett Payne-Rhodes
Thanks to everyone who chipped in on this so I thought I would provide a bit of am update... In the end... It was the file itself! It is a dynamically generated excel file so I am unsure of what kind of 'standard' it might be. It can be opened by both excel and Open Office so it would appear t

[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

[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,