I read a excel file having one form object and rewrite that again using workbook.write() method.The output file which gets generated looks ok but when you try to save that file you get a excel message that 'document not saved' and then when you try to close the file , you get the visual basic message 'file not found' The strange thing is that output file works fine if you change the name of form to something else.The file which does not work has form named 'frmRROptions' and if you change this form name to something else say 'mytestform' and then execute the attached code , the generated output file behaves ok i.e; you don't get any excel or vb message and file saves. It looks like poi library cannot read or write the form objects properly.. I am attaching the input file required to reproduce this problem and the output file generated.. Here is the code i used. ********* FileInputStream fileInputStream = new FileInputStream(new File ("C://docs/UW_Latest.xls")); HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream,true); FileOutputStream fos1 = new FileOutputStream(new File ("c://docs//uw_output.xls")); workbook.write(fos1); fos1.close(); I am attaching the input and output file.
Created attachment 13271 [details] input file to reproduce this problem
Created attachment 13272 [details] output file generated by this.
Please have a look at this defect..It is very for the my assignment.
guys...help please...
Ashish, This is open source, so you'll have to live with the fact that other people's schedules wont match yours :( However, can I ask, have you tried to re-write the file with either ver 2.0, or latest CVS HEAD?
Works as of 12Jan2007, Testcase added. http://issues.apache.org/bugzilla/show_bug.cgi?id=41366