S2SH 导出excel

来源：互联网发布：统计建立数据库 spss 编辑：程序博客网时间：2024/06/05 16:40

首先需要导入 jxl.jar

jsp页面代码：

<a href="downToExcel.action">导出到Excel</a>

就为了跳转到action。

action代码：

这里我有一个用户实体集合userList

public String downToExcel() throws Exception {        HttpServletResponse response = ServletActionContext.getResponse();        response.reset();        response.setCharacterEncoding("UTF-8");        response.setContentType("application/vnd.ms-excel");        response.setHeader("Content-Disposition","attachment;filename=user.xls"); filename 为导出的excel的名称        OutputStream out = response.getOutputStream();        //从数据库读取数据        userList = new ArrayList<User>();        userList = userService.getAllUser();                try{            WritableWorkbook workbook = Workbook.createWorkbook(out);//构建工作薄对象            WritableSheet ws = workbook.createSheet("SheetName",0);//构建工作表            WritableFont wf = new WritableFont(WritableFont.TIMES,10,WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE,            jxl.format.Colour.BLACK);//设置字体格式                       WritableCellFormat wcf = new WritableCellFormat(wf);//创建格式化对象实例            wcf.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//垂直居中            wcf.setAlignment(Alignment.CENTRE);//水平居中            //工作表标题行(new Label(列,行,内容,格式))            ws.addCell(new Label(0,0,"userId",wcf));            ws.addCell(new Label(1,0,"userAccount",wcf));            ws.addCell(new Label(2,0,"password",wcf));            ws.addCell(new Label(3,0,"userName",wcf));            ws.addCell(new Label(4,0,"telephone",wcf));            ws.addCell(new Label(5,0,"email",wcf));            ws.addCell(new Label(6,0,"photoUrl",wcf));            //设置单元格宽度              ws.setColumnView(0,20);              ws.setColumnView(1,40);              ws.setColumnView(2,40);              ws.setColumnView(3,40);              ws.setColumnView(4,40);              ws.setColumnView(5,40);              ws.setColumnView(6,60);               List<Object[]> dataList = new ArrayList<Object[]>();            //List<User> userList = userDAO.findAll();            for(User temp:userList){                Object[] user = {temp.getUserId(),temp.getUserAccount(),temp.getPassword(),temp.getUserName(),temp.getTelephone(),temp.getEmail(),temp.getPhotoUrl()};                dataList.add(user);            }             //向工作表添加数据            for(int i=0;i<dataList.size();i++){                for(int j=0;j<dataList.get(i).length;j++){                    Object o = dataList.get(i)[j];                    if(o != null){                        Label l = new Label(j,i+1,o.toString(),wcf);                        ws.addCell(l);                    }                }            }            workbook.write();            workbook.close();            out.flush();            out.close();        }catch(IOException ioe){            ioe.printStackTrace();        }catch(WriteException we){            we.printStackTrace();        }        return null;    }

struts.xml代码：

<action name="downToExcel" class="UserAction" method="downToExcel"></action>

0 0