java中下载生成Excel

 //第一步：选择模板文件：

                Workbook workbook = Workbook.getWorkbook(new File(path+"upload\\model\\活动签到模板.xls"));                            

                //第二步：通过模板得到一个可写的Workbook：

                File targetFile = new File(path+"upload\\excelFile\\"+nowTime+".xls"); 

                WritableWorkbook wwb = Workbook.createWorkbook(targetFile, workbook);

                //第三步：选择模板中名称为StateResult的Sheet：

                WritableSheet sheet = wwb.getSheet(0);

                //第四步：选择单元格，写入动态值

                //表头标题

                Label label1 =(Label)sheet.getWritableCell(0, 0);

                label1.setString(acts.getOrgan().getName()+"_"+acts.getName()+"签到记录");

                //活动名称

                Label label2 =(Label)sheet.getWritableCell(1, 1);

                label2.setString(acts.getName());

                //活动描述

                Label label3 =(Label)sheet.getWritableCell(1, 2);

                label3.setString(acts.getDes());

                //活动类型

                Label label4 =(Label)sheet.getWritableCell(1, 3);

                label4.setString(hdlx);

                //活动内容

                Label label5 =(Label)sheet.getWritableCell(3, 3);

                label5.setString(hdnr);

                //开始时间

                Label label6 =(Label)sheet.getWritableCell(1, 4);

                label6.setString(String.valueOf(acts.getStartTime()));

                //结束时间

                Label label7 =(Label)sheet.getWritableCell(3, 4);

                label7.setString(String.valueOf(acts.getEndTime()));

                

                //签到人员

                Set setCard=acts.getActCard();

                Iterator<ActCard> k = setCard.iterator();

                int j=9;

                while(k.hasNext()){

                    ActCard actCard= k.next();

                    //如果里面没有默认值，要使用new Label的形式赋值

                    sheet.addCell(new Label(0, j,actCard.getPpminfo().getName()));

                    sheet.addCell(new Label(1, j,String.valueOf(actCard.getCardTime())));

                    sheet.addCell(new Label(2, j,actCard.getCardNo()));

                    sheet.addCell(new Label(3, j,String.valueOf(actCard.getRecTime())));

                    j=j+1;

                }

                wwb.write();                        

                wwb.close();

                workbook.close();

 

--夹包 JXL.jar