used this code. FileOutputStream fos = new FileOutputStream(new File ("c://test//uw_output.xls")); POIFSFileSystem pfs = new POIFSFileSystem(new FileInputStream (new File("c://test//UW_Latest.xls"))); // workbook.write(fos); pfs.writeFilesystem(fos); This works well but when i try to save uw_output.xls , excel application crahses.
In addition to this .. When i use the code HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream (new File("c://test//UW_Latest_Without_Macros.xls")),true); FileOutputStream fos = new FileOutputStream(new File ("c://test//uw_output.xls")); // POIFSFileSystem pfs = new POIFSFileSystem(new FileInputStream (new File("c://test//UW_Latest.xls"))); workbook.write(fos); uw_output.xls file is corrupt. I have logged one similar defect but that got lost between my discusstion with Jason. I am attaching UW_Latest_Without_Macros.xls and uw_output.xls.
i have been trying to attach the files since yesterday but it is not working the page just hangs.I can email these files to the developer who will be looking into this bug..
Sorry no attachements. No fix. Jason