复制excel并写入数据

import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Download {
	  //下载模版工具类  
    public void downloadFile(HttpServletRequest request,    
        HttpServletResponse response,String fileName) throws Exception {    
        response.setContentType("text/html;charset=UTF-8");     
        BufferedInputStream in = null;    
        BufferedOutputStream out = null;    
        request.setCharacterEncoding("UTF-8");    
        try {    
        	File f = new File("F:/" + fileName);
            response.setContentType("application/x-excel");    
            response.setCharacterEncoding("UTF-8");    
            response.setHeader("Content-Disposition", "attachment; filename="+new String(fileName.getBytes("gbk"),"iso-8859-1"));    
            response.setHeader("Content-Length",String.valueOf(f.length()));    
            in = new BufferedInputStream(new FileInputStream(f));    
            out = new BufferedOutputStream(response.getOutputStream());    
            byte[] data = new byte[1024];    
            int len = 0;    
            while (-1 != (len=in.read(data, 0, data.length))) {    
                out.write(data, 0, len);    
            }    
        } catch (Exception e) {    
            e.printStackTrace();    
        } finally {    
            if (in != null) {    
                in.close();    
            }    
            if (out != null) {    
                out.close();    
            }    
        }  
    }
}

public void exportLectotype() throws Exception{
		HttpServletRequest request = ServletActionContext.getRequest();
		HttpServletResponse response = ServletActionContext.getResponse();
		
		String LId = request.getParameter("LId");
		//调用查询指定选型记录id的方法
		List<Object> msglist = lectotypeBIZ.LectotypeDetilsService(LId,null);
		LectotypeExcel lectotypeExcel = new LectotypeExcel((Lectotype)msglist.get(0), (Calculate)msglist.get(1));
		//先复制模板
		lectotypeExcel.createNewFile();
		//将数据写入excel
		String excelpath = lectotypeExcel.exportExcel();
		
		Download download = new Download();
		
		download.downloadFile(request, response, excelpath);
		File file = new File("F:/"+excelpath);
		System.out.println(file.exists());
		if (file.exists()) {  
            file.delete();  
        }
	}