After using POI 2.0 also I got the same error. Thanks & Regards, ________________________________
Sunil Kumar Dhage Senior Software Engineer Wipro Technologies, Hyderabad (O) 040-39180456 (M) 98 66 77 5757 [EMAIL PROTECTED] "May everyone be happy" -----Original Message----- From: Nitesh [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 3:41 PM To: POI Users List Subject: Re: couldnt able to get workbook object for an excel containing macros.. Hi Sunil, I had faced a similar problem.But when i used POI 2.0, it worked fine. Regards, Nitesh Baranwal ---------------------------------- Member of Technical Staff Persistent Systems Pvt Ltd. Office : +91-20-30235744 ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, September 18, 2006 3:23 PM Subject: couldnt able to get workbook object for an excel containing macros.. Hi all, I could able to read and write into excel named abc.xls and now I have one more file XXX.xls in the same directory where abc.xls is. But XXX.xls contains macros and when I try to create workbook object there itself I am getting recordFormatException saying blah blah blah. I am attaching error message. >From some forum page I came to know that it will work if I use POI 2.0. I have tried with both POI 2.5 and 2.0 [9/18/06 15:05:55:406 IST] 00000098 SystemOut O Excels/PKJ-Sheets.xls [9/18/06 15:05:55:406 IST] 00000098 SystemOut O inside generate method : file name Excels/PKJ-Sheets.xls [9/18/06 15:05:56:453 IST] 00000098 SystemOut O after inputstreamgfgfffg+++++++++++++++++++++ [9/18/06 15:05:58:969 IST] 00000098 SystemOut O error due to Exp org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance, the following exception occured: null [9/18/06 15:05:59:031 IST] 00000098 ServletWrappe A SRVE0242I: [/jsp/XLGen/display.jsp]: Initialization successful. [9/18/06 15:05:59:047 IST] 00000098 PropertyMessa I Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true [9/18/06 15:05:59:094 IST] 00000098 PropertyMessa I Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true [9/18/06 15:05:59:109 IST] 00000098 PropertyMessa I Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true [9/18/06 15:05:57:906 IST] 00000098 SystemErr R [WARNING] Unknown Ptg 3c (60) [9/18/06 15:05:57:906 IST] 00000098 SystemErr R [WARNING] Unknown Ptg 3c (60) [9/18/06 15:05:57:922 IST] 00000098 SystemErr R [WARNING] Unknown Ptg 3c (60) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA ccessorImpl.java(Compiled Code)) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons tructorAccessorImpl.java(Compiled Code)) at java.lang.reflect.Constructor.newInstance(Constructor.java(Compiled Code)) at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java (Compiled Code)) .... Caused by: java.lang.ArrayIndexOutOfBoundsException at java.lang.System.arraycopy(Native Method) at org.apache.poi.hssf.record.UnknownRecord.<init>(UnknownRecord.java:62) at org.apache.poi.hssf.record.Record.<init>(Record.java(Compiled Code)) at org.apache.poi.hssf.record.ObjRecord.<init>(ObjRecord.java:61) ... 32 more Thanks & Regards, ________________________________ Sunil Kumar Dhage Senior Software Engineer The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt. Ltd. does not accept any liability for virus infected mails. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
