导出EXCEL 方法

/**
* 导出ＥＸＣＥＬ
* 班级，组织，部门,异常数据导出
* @param savepath
* @param request
* @param response
* @param type
* @throws IOException
* @throws WriteException
*/
@RequestMapping("/tpinfoToDocument.do")
public void viewExcel(HttpServletRequest request, HttpServletResponse response) throws IOException, WriteException{

String savepath=request.getParameter("savepath");
Long type=super.toLong(request, "type");

Long sid=super.getSid(request);
if (sid==null){
this.outtime(request);
    }
String pHeader = null;
if (type==1){
pHeader=cfg.getConfig("porgHead");
}else if (type==2) {
pHeader=cfg.getConfig("pdeptHead");
}else if (type==3) {
pHeader=cfg.getConfig("tpinoInitHead");
}else if (type==4) {
pHeader=cfg.getConfig("tpinoBasicHead");
}
//savepath=""   存在服务器上文件的路径
String filename=savepath+"/Books.xls";
File f=new  File(filename);
//如是果文件存在 就删除
if (f.exists()) f.delete();
List list=null;
list=tpinfoService.tpinfoFindById(sid);
if (vExcel.bulidExcel(pHeader, list, f,type)){
OutputStream out = response.getOutputStream();
    response.setContentType("aplication/vnd.ms-excel");
    response.addHeader("Content-Disposition","inline; filename=Books.xls");  //有中文必须转码

    DataInputStream   dis=new   DataInputStream(new   FileInputStream(f));
    byte[]   buf=new   byte[1024];  
    int   left=(int)f.length();  
    int   read=0;  
    while(left>0){
    read=dis.read(buf);  
        left-=read;  
        out.write(buf,0,read);  
    }  
    dis.close();  
    out.close();  
    out.close();    
    //下载成功后，删除服务上的这个文件
    if (f.exists()) f.delete();
   return;    
}
}



/**
     *   导入EXCEL
     * @param header  表头
     * @param list   被导出的列表
     * @param f       文件
     * @param type    类型 1 2 3 4
     * @return
     * @throws IOException
     * @throws WriteException
     */
public boolean bulidExcel(String header,List list,File f,Long type) throws IOException, WriteException{

//File tempFile=new File("d:/temp/output.xls");
WritableWorkbook workbook = Workbook.createWorkbook(f);  
WritableSheet sheet = workbook.createSheet("Books", 0);   
 
//一些临时变量，用于写到excel中  
 
int i;
int counter=0;
String[] title=header.split(",");
        for (i=0;i<title.length;i++){ 
//表头
if(title[i]==null){
          sheet.addCell(new Label(i, 0, "未知"));
          } else{
          sheet.addCell(new Label(i, 0, title[i]));
          }
         }
        TPorg t=null;
        TPinfo tpinfo=null;
        for (i=0;i<list.size();i++){
        counter++;
        if (type==1){
        t=new TPorg();
            t=(TPorg) list.get(i);
        sheet.addCell(new Label(0, counter, t.getCardnum().toString() ));
            sheet.addCell(new Label(1, counter, t.getRealname().toString()));
            sheet.addCell(new Label(2, counter, t.getOrgname().toString()));
            sheet.addCell(new Label(3, counter, t.getDeptname().toString()));
            //sheet.addCell(new Label(4, counter, t.getFlag().toString()));
        }else if(type==2){
        t=new TPorg();
            t=(TPorg) list.get(i);
        sheet.addCell(new Label(0, counter, t.getCardnum().toString() ));
            sheet.addCell(new Label(1, counter, t.getRealname().toString()));
            sheet.addCell(new Label(2, counter, t.getDeptname().toString()));
            //sheet.addCell(new Label(3, counter, t.getFlag().toString()));
        }else if (type==3){
        tpinfo=new TPinfo();
        tpinfo=(TPinfo) list.get(i);
        sheet.addCell(new Label(0, counter, tpinfo.getStudentnum().toString() ));
            sheet.addCell(new Label(1, counter, tpinfo.getRealname().toString()));
            //sheet.addCell(new Label(2, counter, tpinfo.getIdnum() .toString()));
            //sheet.addCell(new Label(3, counter, tpinfo.getFlag().toString()));
        }else if (type==4){
        tpinfo=new TPinfo();
        tpinfo=(TPinfo) list.get(i);
        sheet.addCell(new Label(0, counter, tpinfo.getStudentnum().toString() ));
            sheet.addCell(new Label(1, counter, tpinfo.getRealname().toString()));
            sheet.addCell(new Label(2, counter, tpinfo.getIdnum() .toString()));
            //sheet.addCell(new Label(3, counter, tpinfo.getFlag().toString()));
        }
        }
workbook.write();  
workbook.close();  
return true;
}