Problem Reading Excel File

[Harsh <hu...@nimaya.com>]

Hi the Most Active and Responsive Group,
 
            I have noticed some limitation with POI , while Writing . I
wanted to know , is there any fault with my code 
Or is it limitation of POI itself. I am using POI 1.1.9 Version with
JDK 1.3 on Win'2000.
 
Basically , My aim is 
1.       Read from one excel file
2.       Modify some fields
3.       Create a new excel file and write whole content in new excel
file
 
But Writing fails for Following conditions. I mean I can't open New
generated Excel File. It gives
Can't Read Error.
 
1.       If my original Excel File has COMMENTS
2.       If my original Excel File has AutoShapes (Sqares, Rectangles
drawn using Autoshape Toolbar)
3.       If my original Excel File has Buttons with Macros.
 
Can anybody help me in this.
Thanks,
Harsh Ubriani
Nimaya Technologies, Hyderabad
 
 
 

Re: Problem Reading Excel File

["Andrew C. Oliver" <ac...@apache.org>]

>
>
> 
>Can anybody help me in this.
>
Start by using org.apache.poi.hssf.dev.BiffViewer on the file prior to 
being run under HSSF and again after.  Redirect the output from both to 
files.  Diff the files (I use the unix diff, on windows I use cygwin's 
version of the unix diff). 

It helps to have the "Excel 97 developer's kit" (out of print but still 
available used) and then you can more easily identify the records that 
are "Unknown".

Or if you don't want to do it yourself you can attach the files in 
bugzilla per the "getinvolved.html" page and wait for someone else to do 
it.  Or you can contract one of the vendors whom support POI to do it 
for you.

-Andy

>Thanks,
>Harsh Ubriani
>Nimaya Technologies, Hyderabad
> 
> 
> 
>
>  
>