> I will have to have another go. Just ensure you use the latest version (2.0RC1) since a lot of file corruption issues have been fixed recently. We've had reports of usage/have tested many complicated files, but its the nature of products like POI (ie, any file format processor), YMMV is more than just a cliche :)
>The problem I have is that I cannot provide > the actual sheet (confidentiality) Sure. But since there are thousands of ways file corruption may occur, and excel essetially throws the same error message, it impossible to debug without seeing the file. Regards - Avik On Tue, 2003-12-16 at 07:16, Shane Mingins wrote: > Okay. Thanks for the feedback. > > I will have to have another go. The problem I have is that I cannot provide > the actual sheet (confidentiality) so would have to spend time recreating > the problem. For example when I had a test workbook with the sheet I am > updating it worked, but the same code failed when I used entire workbook. > > In the meantime I am using IBM's ExcelAccessor which is a windows only > solution that I have made fit my requirement. > > Because of the time it will take to show the things that did not work with > samples I will have to slot some time in later. But if it should work I > will do that. > > Thanks again > Shane > > > > -----Original Message----- > > From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, 16 December 2003 2:26 p.m. > > To: POI Users List > > Subject: Re: Complex Workbook > > > > No, not really. Show us things that don't work and provide samples. > > -- > > Andrew C. Oliver > > http://www.superlinksoftware.com/poi.jsp > > Custom enhancements and Commercial Implementation for Jakarta POI > > > > http://jakarta.apache.org/poi > > For Java and Excel, Got POI? > > > > The views expressed in this email are those of the author and are almost > > definitely not shared by the Apache Software Foundation, its board or its > > general membership. In fact they probably most definitively disagree with > > everything espoused in the above email. > > > > > From: Shane Mingins <[EMAIL PROTECTED]> > > > Reply-To: "POI Users List" <[EMAIL PROTECTED]> > > > Date: Tue, 16 Dec 2003 14:07:03 +1300 > > > To: [EMAIL PROTECTED] > > > Subject: Complex Workbook > > > > > > Hi > > > > > > The workbook I was using has approx 60 visible worksheets and about 14 > > > hidden ones. It also uses lots of named references (which are not > > > supported, correct?), macros, and complex formulas referencing cells > > etc. > > > > > > FYI, it is used to calculate the price of about 60 unit trusts. > > > > > > From what I have read and tried, it would seem that HSSF does not like > > > writing to extremely large and complex workbooks of this nature. Is > > this > > > understanding correct? > > > > > > Kind regards > > > Shane > > > > > > Shane Mingins > > > Analyst Programmer > > > Assure NZ Ltd > > > Ph 644 494 2522 > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
