Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
From: bugzilla@apache.org
To: dev@poi.apache.org
Subject: DO NOT REPLY [Bug 48654] New: Not able to read Excel (xls) file
 having drawing objects
Message-ID: <bug-48654-47293@https.issues.apache.org/bugzilla/>
Auto-Submitted: auto-generated
Content-Type: text/plain; charset="UTF-8"
MIME-Version: 1.0
Date: Mon,  1 Feb 2010 22:58:31 -0800 (PST)

https://issues.apache.org/bugzilla/show_bug.cgi?id=48654

           Summary: Not able to read Excel (xls) file having drawing
                    objects
           Product: POI
           Version: 3.6
          Platform: PC
        OS/Version: Windows Vista
            Status: NEW
          Severity: critical
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: rakesh.ranjan@zsassociates.com


Hi all,

I am new to this library and am trying to use HSSF for reading an excel file
and then writing the output to one of its Sheet. Currently I am facing this
issue:

My excel file contains some of the drawing objects. That causes HSSF throw this
error when I try to create a workbook for the input file,


org.apache.poi.hssf.record.RecordFormatException: Unable to construct record
instance
        at
org.apache.poi.hssf.record.RecordFactory$ReflectionRecordCreator.create(RecordFactory.java:64)
        at
org.apache.poi.hssf.record.RecordFactory.createSingleRecord(RecordFactory.java:263)
        at
org.apache.poi.hssf.record.RecordFactoryInputStream.readNextRecord(RecordFactoryInputStream.java:270)
        at
org.apache.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:236)
        at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:392)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:276)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:201)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:317)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:298)


However, when I remove all the drawing objects from the input excel it reads
the excel file without any issues. 
I tried to search for some workbooksetting object, which could allow me to
disable(in Java) the drawing objects of the excel while reading it, or some
option with which I can read the excel file even if it has the drawing objects(
as the objects are critical to the project, I can not remove them).But could
not find any such setting with HSSF.

Please let me know about any such option/setting if it exists in POI library.Or
let me know the way to read such excel files having drawing objects.

Thanks in Advance,

Regards,

Rakesh

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org