You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by su...@wipro.com on 2006/09/18 11:53:40 UTC
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
RE: couldnt able to get workbook object for an excel containingmacros..
Posted by su...@wipro.com.
There I can see many but all contain html api docs instead of classes.
I wanna jar file or zip which has class files.
Thanks & Regards,
________________________________
Sunil Kumar Dhage
Senior Software Engineer
Wipro Technologies, Hyderabad
(O) 040-39180456
(M) 98 66 77 5757
sunilkumar.dhage@wipro.com
"May everyone be happy"
-----Original Message-----
From: Avik Sengupta [mailto:avik.sengupta@itellix.com]
Sent: Monday, September 18, 2006 5:55 PM
To: poi-user@jakarta.apache.org
Subject: RE: couldnt able to get workbook object for an excel
containingmacros..
http://archive.apache.org/dist/jakarta/poi/release/bin/
Quoting sunilkumar.dhage@wipro.com:
>
> Do anybody have poi 2.0.jar with you. If yes share it with me.
> I m in an urgent requirement.
>
> Thanks & Regards,
> ________________________________
>
> Sunil Kumar Dhage
> Senior Software Engineer
> Wipro Technologies, Hyderabad
> (O) 040-39180456
> (M) 98 66 77 5757
> sunilkumar.dhage@wipro.com
>
>
> "May everyone be happy"
>
> -----Original Message-----
> From: Nitesh [mailto:nitesh_baranwal@persistent.co.in]
> 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: <su...@wipro.com>
> To: <po...@jakarta.apache.org>
> 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: poi-user-unsubscribe@jakarta.apache.org
> 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: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
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: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
RE: couldnt able to get workbook object for an excel containing
macros..
Posted by Avik Sengupta <av...@itellix.com>.
http://archive.apache.org/dist/jakarta/poi/release/bin/
Quoting sunilkumar.dhage@wipro.com:
>
> Do anybody have poi 2.0.jar with you. If yes share it with me.
> I m in an urgent requirement.
>
> Thanks & Regards,
> ________________________________
>
> Sunil Kumar Dhage
> Senior Software Engineer
> Wipro Technologies, Hyderabad
> (O) 040-39180456
> (M) 98 66 77 5757
> sunilkumar.dhage@wipro.com
>
>
> "May everyone be happy"
>
> -----Original Message-----
> From: Nitesh [mailto:nitesh_baranwal@persistent.co.in]
> 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: <su...@wipro.com>
> To: <po...@jakarta.apache.org>
> 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: poi-user-unsubscribe@jakarta.apache.org
> 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: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
RE: couldnt able to get workbook object for an excel containing macros..
Posted by su...@wipro.com.
Do anybody have poi 2.0.jar with you. If yes share it with me.
I m in an urgent requirement.
Thanks & Regards,
________________________________
Sunil Kumar Dhage
Senior Software Engineer
Wipro Technologies, Hyderabad
(O) 040-39180456
(M) 98 66 77 5757
sunilkumar.dhage@wipro.com
"May everyone be happy"
-----Original Message-----
From: Nitesh [mailto:nitesh_baranwal@persistent.co.in]
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: <su...@wipro.com>
To: <po...@jakarta.apache.org>
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: poi-user-unsubscribe@jakarta.apache.org
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: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
RE: couldnt able to get workbook object for an excel containing macros..
Posted by su...@wipro.com.
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
sunilkumar.dhage@wipro.com
"May everyone be happy"
-----Original Message-----
From: Nitesh [mailto:nitesh_baranwal@persistent.co.in]
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: <su...@wipro.com>
To: <po...@jakarta.apache.org>
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: poi-user-unsubscribe@jakarta.apache.org
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: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: couldnt able to get workbook object for an excel containing macros..
Posted by Nitesh <ni...@persistent.co.in>.
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: <su...@wipro.com>
To: <po...@jakarta.apache.org>
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: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/