jxl生成excel,此文章属于记录性文章,有springmvc,springroo等很多其他类没添加进来,仅供参考使用
来源:互联网 发布:电脑淘宝弹出广告 编辑:程序博客网 时间:2024/05/16 01:05
生成EXCEL的action
package com.wmgr.controller;import java.io.IOException;import java.io.OutputStream;import java.math.BigDecimal;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Calendar;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import jxl.Workbook;import jxl.write.Label;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;import jxl.write.WriteException;import org.apache.commons.lang.StringUtils;import org.apache.log4j.Logger;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.ModelAttribute;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestParam;import org.springframework.web.servlet.ModelAndView;import com.boyacai.wmgr.domain.Activity;import com.boyacai.wmgr.domain.News;import com.boyacai.wmgr.domain.TJFTJ;import com.boyacai.wmgr.domain.TproductType;import com.boyacai.wmgr.util.Page;import com.boyacai.wmgr.util.StringUtil;@RequestMapping("/jftj")@Controllerpublic class JFExportExcel {private Logger logger = Logger.getLogger(ActivityController.class);private Calendar calendar = Calendar.getInstance();@RequestMapping("/genexcel")public void genexcel(@RequestParam(value = "timeFrom", required = false) String timeFrom,@RequestParam(value = "timeTo", required = false) String timeTo,@RequestParam(value = "channel", required = false) String channel,HttpServletRequest request, HttpServletResponse response) throws IOException {logger.info("/tcashCW/genexcel start");OutputStream os = null;WritableWorkbook wwb = null;try {StringBuilder builder1 = new StringBuilder(" where");List<Object> params1 = new ArrayList<Object>();//channel号if (!StringUtil.isEmpty(channel)) {builder1.append(" o.channel =? and");params1.add(channel);}//更新时间if (!StringUtil.isEmpty(timeFrom)&&!StringUtil.isEmpty(timeTo)) {builder1.append(" o.bettime between ? and ? and");SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");params1.add(sdf.parse(timeFrom));params1.add(sdf.parse(timeTo));}if (builder1.toString().endsWith("and")) {builder1.delete(builder1.length() - 3, builder1.length());}if (builder1.toString().endsWith("where")) {builder1.delete(builder1.length() - 5, builder1.length());}List<TJFTJ> list=TJFTJ.findListExcel(builder1.toString(), "", params1);if (!StringUtil.isEmpty(builder1.toString())) {//List<Tcashdetail> list = Tcashdetail.findList(builder.toString(), orderBy, params);os = response.getOutputStream();wwb = Workbook.createWorkbook(os);response.setContentType("application/dowload");response.setHeader("Content-disposition", "attachment;filename=\""+ new String((java.net.URLEncoder.encode("积分信息统计.xls","UTF-8")).getBytes("UTF-8"), "GB2312") + "\"");// Workbook的createSheet方法有两个参数,第一个是工作表的名称,第二个是工作表在工作薄中的位置WritableSheet ws = wwb.createSheet("sheet1", 0); ws.setColumnView(0, 40);ws.setColumnView(1, 30);ws.setColumnView(2, 20);ws.setColumnView(3, 20);ws.setColumnView(4, 25);ws.setColumnView(5, 10);ws.addCell(new Label(0, 0, "betcode"));ws.addCell(new Label(1, 0, "bettime"));ws.addCell(new Label(2, 0, "phone"));ws.addCell(new Label(3, 0, "userno"));ws.addCell(new Label(4, 0, "orderid"));ws.addCell(new Label(5, 0, "channel"));BigDecimal amtAll = BigDecimal.ZERO;for (int i = 0; i < list.size(); i++) {TJFTJ t = list.get(i);int j = i+1; ws.addCell(new Label(0, j, t.getBetcode())); ws.addCell(new Label(1, j, t.getBettime().toString())); ws.addCell(new Label(2, j, t.getPhone())); ws.addCell(new Label(3, j, t.getUserno())); ws.addCell(new Label(4, j, t.getOrderid())); ws.addCell(new Label(5, j, t.getChannel()));} //ws.setProtected(true); wwb.setProtected(false); wwb.write(); }} catch (Exception e) {logger.error("jftj/genexcel Exception", e);} finally {if (wwb != null) {try {wwb.close();} catch (WriteException e) {logger.error("jftj/genexcel WriteException", e);}}if (os != null) {os.close();}}logger.info("genexcel end");}}
0 0
- jxl生成excel,此文章属于记录性文章,有springmvc,springroo等很多其他类没添加进来,仅供参考使用
- Jxl导出Excel表 仅供参考
- 使用jxl.jar生成excel
- okhttp3.2.0适配https,虽然网络上有很多文章。在此借助前人的经验,做一些处理。
- 很多天没更新Oracle的文章了
- 使用文章记录地址
- 使用JXL来生成一个Excel文件
- 使用JXL进行后台生成excel文件
- jxl 导出excel springMVC
- 其他-jxl的使用(操作excel表格)
- 通过jxl来生成,有单元格样式的excel
- jxl生成EXCEL
- jxl生成excel
- jxl生成excel
- jxl 生成excel
- jxl生成excel
- 学习了一篇文章,jquery生成excel
- 使用jxl工具包生成Excel以及读取Excel的方法
- “以地控税”—GIS在税务征管的创新应用
- perl函数说明(gethostent)
- 申通运营管理RCP项目中的报错信息处理
- 多边形重心问题
- ASCII码排序
- jxl生成excel,此文章属于记录性文章,有springmvc,springroo等很多其他类没添加进来,仅供参考使用
- Arrays.copyOf 和System.arraycopy
- Unity3D的LightProbe动态光探头用法介绍
- dhcp移植
- 发邮件
- Binary String Matching
- html表单输入框css样式美化特效源代码下载
- Convert.ToInt32()与int.Parse()的区别
- Qt中的内存管理