利用POI对EXCEL进行更新操作方法(性能大于WritableWorkbook)

   HSSFWorkbook hssfworkbook = null;  
         File f;  
         FileInputStream is = null;  
         FileOutputStream fileOut = null;  
         is = new FileInputStream(filePath);
           hssfworkbook = new HSSFWorkbook(is); 
     HSSFSheet sheet2 = hssfworkbook.getSheetAt(2);
     HSSFSheet sheet3 = hssfworkbook.getSheetAt(3);
     int rownum2 = sheet2.getLastRowNum();
     int rownum3 = sheet3.getLastRowNum();
     for(int i = 0; i <= rownum2; i++){
     HSSFRow row2 = sheet2.getRow(i);
        row2.getCell(0).setCellValue("");//清空原有的内容
     }
     for(int j = 0; j <= rownum3; j++){
      HSSFRow row3 = sheet3.getRow(j);
      row3.getCell(0).setCellValue("");//清空原有的内容
     }
     List modelList = sparePartsTypeManager.getSparePartsTypesList();//获得集合
     List localList = storeHouseInfoManager.getStoreHouseInfoList();
    if(modelList != null){
    for(int m = 0; m < modelList.size(); m++){
     SparePartsTypes sparePartsType = (SparePartsTypes)modelList.get(m);
     if(sparePartsType != null && !"".equals(sparePartsType)){
     String code = sparePartsType.getCode();
     HSSFRow row2 = sheet2.getRow(m);
     row2.getCell(0).setCellValue(code);
     }
    }
    }
    if(localList != null){
    for(int n = 0; n < localList.size(); n++){
     StoreHouseInfo storeHouseInfo = (StoreHouseInfo)localList.get(n);
     if(storeHouseInfo != null && !"".equals(storeHouseInfo)){
     String name = storeHouseInfo.getName();
     HSSFRow row3 = sheet3.getRow(n);
     row3.getCell(0).setCellValue(name);
     }
    }
    }
     fileOut = new FileOutputStream(filePath);
     hssfworkbook.write(fileOut);
     is.close();
     fileOut.close();

 

代码很简单。是个很常用的更新excel模板的例子