java打印Excel表格

这里用servlet简单介绍一下java打印报表

1.无合并行/列

package weaver.xhyy.servlet;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import jxl.Workbook;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.Colour;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

import weaver.general.BaseBean;
import weaver.general.Util;
import weaver.hrm.HrmUserVarify;
import weaver.hrm.User;
import weaver.xhyy.sap.SearchYhdzxx;

/**
 * 打印银行对账信息
 * 
 * @author Yuk
 * 
 */
public class GetYhdzxxExcelServlet extends HttpServlet {
    protected void service(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {

        BaseBean log = new BaseBean();
        log.writeLog("开始导出院外来款查询");
        User user = HrmUserVarify.getUser (request , response) ;
        String beginDate = Util.null2String(request.getSession().getAttribute("beginDate"));
        String endDate = Util.null2String(request.getSession().getAttribute("endDate"));

        Map<String, String> otherparams = new HashMap<String, String>();
        otherparams.put("beginDate", beginDate);
        otherparams.put("endDate", endDate);
        // 调用【获取银行对账信息】
        SearchYhdzxx search = new SearchYhdzxx();
        List<Map<String, String>> list = search.getYhdzxx(user, otherparams, request, response);


        request.setCharacterEncoding("utf-8");
        response.setContentType("application/vnd.ms-excel;charset=utf-8");

        String context = "院外来款查询";

        response.setHeader("Content-Disposition", "attachment; filename=\""
                + URLEncoder.encode(context, "utf-8") + ".xls\"");

        // 新建EXCEL文件
        File downloadFile = new File(request.getSession().getServletContext()
                .getRealPath(