jxl 操作excel

public static void modifyExcel(String excelpath){
try {
jxl.Workbook wb =null;  //创建一个workbook对象
try {
InputStream is = new FileInputStream(excelpath); //创建一个文件流，读入Excel文件
wb = Workbook.getWorkbook(is); //将文件流写入到workbook对象
} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
       // jxl.Workbook 对象是只读的，所以如果要修改Excel，需要创建一个可读的副本，副本指向原Excel文件（即下面的new File(excelpath)）
jxl.write.WritableWorkbook wbe= Workbook.createWorkbook(new File(excelpath), wb);//创建workbook的副本
WritableSheet sheet  = wbe.getSheet(0); //获取第一个sheet
WritableCell cell =sheet.getWritableCell(0, 0);//获取第一个单元格
jxl.format.CellFormat cf = cell.getCellFormat();//获取第一个单元格的格式
jxl.write.Label lbl = new jxl.write.Label(0, 0, "修改后的值");//将第一个单元格的值改为“修改後的值”
lbl.setCellFormat(cf);//将修改后的单元格的格式设定成跟原来一样

sheet.addCell(lbl);//将改过的单元格保存到sheet
wbe.write();//将修改保存到workbook --》一定要保存
wbe.close();//关闭workbook，释放内存 ---》一定要释放内存

} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (WriteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}





=============================

//预算编制说明.xls
public ActionForward ysbz(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
OutputStream os = null;
Workbook  book=null;
WritableWorkbook wwb=null;
  try{
  int businessId=Util.formateInt(request.getParameter("businessId"), 0);
  TblBusinessBase tbb=(TblBusinessBase) Util.getBaseDao().listSingleObject("from TblBusinessBase as b where b.businessId=?", new Integer[]{businessId});
  os=response.getOutputStream();  //取得输出流    
      response.reset(); //清空输出流    
      response.setContentType ( "application/ms-excel" ); 
      response.setHeader ("Content-Disposition","attachment;filename="+new String("预算编制说明.xls".getBytes(),"iso-8859-1"));
  String path=request.getRealPath("oa模板\\预算编制说明.xls");
  book=Workbook.getWorkbook(new File(path));
//创建副本
  wwb=Workbook.createWorkbook(os,book);
  WritableSheet sheet=wwb.getSheet(0);
  int cols = sheet.getColumns();// 得到列数
      int rows = sheet.getRows();// 得到行数
  
      WritableCell cell=sheet.getWritableCell(0,1);
      CellFormat cf=cell.getCellFormat();
      Label label=new Label(0,1,"工程名称："+tbb.getBusinessName());
      label.setCellFormat(cf);
      sheet.addCell(label);
      cell=sheet.getWritableCell(2,4);
      cf=cell.getCellFormat();
      label=new Label(2,4,tbb.getBusinessName());
      sheet.addCell(label);
      wwb.write();
      wwb.close();
     
      book.close();
      os.close();
  }catch(Exception ex){
 
  ex.printStackTrace();
  }finally{
 
  wwb.write();
      wwb.close();
     
      book.close();
      os.close(); 
  }
      return null;
     



  //request.setAttribute("tbb", tbb);
// return mapping.findForward("ysbz");
}