Yes Davis, I had the same problems with my complicated excels...
I've made many attempts, even just open the file and write it without
modifying anything...POI produces a file a little bit larger and
corrupt for MS Excel...But with open office the content was valid and it
opens normally... I think that the problem is the large number of
complicated formulas in the sheet, if I delete some of them the file
works correctly.
But I also think that excel writes an history in some part of file, of
any edit operations. I was able to have 2 excel file with the same
number of cell, the same number of formulas with the same values, after
the POI processing one works correctly, the other was wrong... With a
binary comparator I checked the two files and even if they had the same
Excel contents, they were different...
FYI I've also tried open office UNO classes to read excel but It's a
more complicated system...
So I switched to VB Script to reproduce the excel file :(
Any informations of the standar Open Document format????
Regards
Davis Varkey Koottala wrote:
Hi All,
Thanks for your attempt to help me.
David, I have tried with POI3 RC1, it gives the same problem. I have
attached the generated excel, I agree that, its veri complicated excel
cross referencing between sheets. Don't know if that is the cause.
Marian, the sheet does exist.
Any of your further is greatly appreciated..
Regards,
Davis
David Fisher <[EMAIL PROTECTED]>
03/15/2007 08:32 PM
Please respond to
"POI Users List" <[email protected]>
To
"POI Users List" <[email protected]>
cc
Subject
Re: Unable to open created excel file
Try POI3 RC1.
On Mar 15, 2007, at 7:10 AM, Simone Caldon wrote:
Oh no Marian, in case of complicated excel file POI outputs
corrupted files, there's some bug reported in bugzilla...
Marian Roman wrote:
Hi Davies,
I see no errors in Your code, I tried it, there can be a problem
only if You
want to remove a non-existing sheet, You get
java.lang.IndexOutOfBoundsException.
Marian
On 3/15/07, Davis Varkey Koottala <[EMAIL PROTECTED]> wrote:
Hi All,
I am unable to open the excel file which is created
programatically. This
is what I am doing :
fileIn = new FileInputStream("test.xls");
POIFSFileSystem fs = new POIFSFileSystem(fileIn);
HSSFWorkbook test = new HSSFWorkbook(fs);
test.removeSheetAt(2);
fileOut = new FileOutputStream("D:\\Workshop\\poi\\excel
Utility\\workbookout.xls");
test.write(fileOut);
After writing the file, when I open it, it just open the file
poping up
the microsoft standard error dialog.
Your help is much appreciated.
Regards,
Davis
---------------------------------------------------------------------
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/
---------------------------------------------------------------------
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/
Chiacchiera con i tuoi amici in tempo reale!
http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.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/
