java导出excel实例.docVIP

lt;!Action调用!gt; public String makeExcel()throws ApplicationException{ this.getDownloadFile(); return SUCCESS; } public InputStream getDownloadFile() throws Applicatio !Action调用! public String makeExcel()throws ApplicationException{ this.getDownloadFile(); return SUCCESS; } public InputStream getDownloadFile() throws ApplicationException{ shpShopDto = (ShpShopDto) this.getSession().get(shpShopDtoSession); if(shpShopDto!=null){ Pagination pagination = new Pagination(pageNo, rowsPerPage); InputStream is=ServiceManager.agent.getShpSecModelService().makeExcel(shpShopDto.getCode(), pagination); getRequest().setAttribute(pagination, pagination); return is; }else{ return null; } } !Service相关业务 public InputStream makeExcel(Long shopcode,Pagination pagination) throws ApplicationException { HSSFWorkbook book=new HSSFWorkbook(); HSSFSheet sheet=book.createSheet(sheet1); HSSFRow row=sheet.createRow(0); HSSFCell cell=row.createCell((short) 0); cell.setCellValue(编号); cell=row.createCell((short) 1); cell.setCellValue(名称); cell=row.createCell((short) 2); cell.setCellValue(金额); cell=row.createCell((short)3); cell.setCellValue(开始日期); cell=row.createCell((short)4); cell.setCellValue(结束日期); cell=row.createCell((short)5); cell.setCellValue(数量); //list为要生成Excel的数据的集合 List list=shpSecModelDao.find(shopcode, pagination); if(list.size()0){ for(int i=0;ilist.size();i++){ ShpSecModelDto secModel=(ShpSecModelDto)list.get(i); row=sheet.createRow(i+1); //i=0,有个list(0),有一行数据 SimpleDateFormat sf=new SimpleDateFormat(yyyy-MM-dd); cell=row.createCell((short)0); cell.setCellValue(secModel.getId());