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();

Reply via email to