You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by Sino Cai <jw...@LONGTOP.COM> on 2009/05/21 10:43:26 UTC

Excel file unreachable content

Hi,
 
 
 
 
The excel originally created by Office2007 and work well.
 
Then I edit the excel by Office2003 and happe the problem that unreachable content when open the excel file
 
  
Below is my code
 
  String inputExcel="D:\\test_Local.sqls.xls";
  
  POIFSFileSystem fs=new POIFSFileSystem(new FileInputStream(inputExcel));
  FileOutputStream output=new FileOutputStream(inputExcel);  
  HSSFWorkbook rptWorkbook=new HSSFWorkbook(fs);
  rptWorkbook.getSheet("GLOBAL_KEYS").getRow(10).createCell(1).setCellValue(88);
  rptWorkbook.write(output);
  output.close();