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 don't know and I make no judgement on who is right and who is wrong in terms of whether or not these (I assume) non-standard format excel files should be readable. My guess is that POI is written to the 'standard' so the files are rejected but since M$ wrote the standard they have a more flexible interpretation of it and have been well known to treat standards as guidelines before. At this stage I have had to send it back to the client to find out if we can have the excel file delivered without the offending 'extra' lines and columns. At least now I know a lot more about POI than I did before... B) On Sun, Aug 1, 2010 at 2:43 PM, Barry Beattie <barry.beat...@gmail.com>wrote: > " 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 > formatted documents while POI is more strict and correct. > > just a bored Sunday thought. > > -- > 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. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
