list输出为xls 随笔

最新推荐文章于 2022-03-06 15:44:27 发布

原创最新推荐文章于 2022-03-06 15:44:27 发布 · 144 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Excel #J# #工作

本文介绍了一个Java方法，用于将查询结果导出为Excel文件。该方法接收用户会话信息及查询参数，从数据库中获取数据并将其转换为Excel格式，以便用户下载。涉及文件创建、工作表生成及数据读取等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public ActionForward expResultForExcel(ActionMapping mapping, ActionForm form,
                                       HttpServletRequest request,
                                       HttpServletResponse response) {
        String user_dm = authenticator.getUserDM(request.getSession());
        String actid = request.getParameter("actid") != null ?
                       request.getParameter("actid") : "";
        String sid = sort.getSchool_id(user_dm);
        List list = sort.getSortInfoForExcel(actid);
        try {
            File file=new File(System.currentTimeMillis()+".xls");
            WritableWorkbook wwb = Workbook.createWorkbook(file); //此处建立路径
            jxl.write.WritableSheet ws = wwb.createSheet("Sheet1", 0); //建立工作簿
            for (int i = 0; i < list.size(); i++) { //代表行
                Map map=(Map)list.get(i);
                Set set=map.keySet();
                Iterator iterator = set.iterator();
                int j = 0; //j代表列
                while (iterator.hasNext()) {
                    Object test = (Object) iterator.next();
                    String str="";
                    try{
                        str=map.get(test).toString();
                    }catch(Exception e){
                    }
                    jxl.write.Label label1 = new jxl.write.Label(j, i,
                            str); //建立第一列
                    ws.addCell(label1); //放入工作簿
                    j++;
                }
            }
            //写入Exel工作表
            wwb.write();
            //关闭Excel工作薄对象
            wwb.close();
            response.setHeader("Content-disposition","attachment; filename=result.xls");
            response.setContentType("application/msexcel");
            InputStream in=new FileInputStream(file);
            OutputStream out=response.getOutputStream();

            int bytesRead = 0;
            byte[] buffer = new byte[8192]; //设置缓冲大小
            while ((bytesRead = in.read(buffer, 0, 8192)) != -1) {
                out.write(buffer, 0, bytesRead);
            }
            out.close();
            file.delete();
            return null;
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
    }