MSB <markbrdsly <at> tiscali.co.uk> writes: > > > The other thought I had today whilst putting an extra keen edge onto an axe > was this; > > 1. Have the Excel workbook file on your PC and try to process that file > using the POI code. > 2. If that works, upload the file to the server and try to process it there > using the same code base. > > If that fails then there has to be a problem with the file which was > introduced by the procees of copying the file to the server and it is one > that POI is not able to circunvent. It seems from the error message you > posted that it is not possible for the POI core code to locate a specific > part of the zip file as it is either unpacking it or as it trying to locate > that part whilst parsing the xml. > > The only other thing I tought that you could do is to look into the file > using a tool such as WinRAR. That way, you will be able to see if the > various files and folders are presnet and in the locations they should > occupy. > > Do not know if this will help at all - and I must admit to being a little > stumpled myself - but as it had been a while since anyone posted in response > to your original message, I wanted to try and keep the discussion going > forward. > > Yours > > Mark B > > Jorge Moya wrote: > > > > I've verified and the file is functional. I'm really clueless, atm. > > > > On Thu, Jun 10, 2010 at 1:53 AM, MSB <markbrdsly <at> tiscali.co.uk> wrote: > > > >> > >> Is it possible that the structure of the file is being mangled somehow? > >> Have > >> you tried to open the file using Excel after it has been ftp'd into the > >> folder on your server? > >> > >> Yours > >> > >> Mark B > >> > >> > >> Jorge Moya wrote: > >> > > >> > I'm sorry for spam, but I menat it breaks when it tries to extract the > >> > info > >> > from the file. > >> > > >> > Thanks in advance. > >> >
Hi, I'm a colleague of Jorge's and as a follow up, I want to share with you all what the result/fix of this issue was. There is already a ticket on bugzilla in the POI project(see https://issues.apache.org/bugzilla/show_bug.cgi?id=49449), but still I want to share the results on this. The problem was indeed with the xerces jars. It looks like the geronimo-stax jar that needs POI to run XLSX files, in a specific webapp in Tomcat 5.5, made conflict with the xerces jar in the endorsed folder. The fix was to move those jars in the endorsed folder to the common lib folder and do not override any Tomcat's XML parser (see http://tomcat.apache.org/tomcat-5.5-doc/RELEASE- NOTES.txt) Thank you all for your help on this issue. Fernando --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
