java 导出excel,

	public String excel() {
try {
String filename = "RKA_"
+ DateFormatUtil.getFormatDate("yyyyMMddHHmmss");
HttpServletResponse response = getResponse();
OutputStream os = response.getOutputStream();// 取得输出流
response.reset();
response.setContentType("APPLICATION/X-MSDOWNLOAD;charset=utf-8");
response.setCharacterEncoding("utf-8");
response.setHeader(
"Content-Disposition",
new String(("attachment;filename=\"" + filename + ".xls\"")
.getBytes("utf-8"), "utf-8"));
response.setContentType("text/html");
WritableWorkbook book = null;
book = Workbook.createWorkbook(os); // 建立excel文件
WritableSheet sheet = book.createSheet("销售信息", 10); // 创建一个工作表
// -----------2--end
// 生成表格题头
Label labe0 = new Label(0, 0, "创建日期");
Label labe1 = new Label(1, 0, "微信号");
Label labe2 = new Label(2, 0, "姓名");
Label labe3 = new Label(3, 0, "电话");
Label labe4 = new Label(4, 0, "门店名称");
Label labe5 = new Label(5, 0, "数量");
Label labe6 = new Label(6, 0, "销售额");
Label labe7 = new Label(7, 0, "大区");
Label labe8 = new Label(8, 0, "标准分部");
Label labe9 = new Label(9, 0, "渠道");
Label labe10 = new Label(10, 0, "电脑型号");
// 将生成的单元格添加到工作表中
sheet.addCell(labe0);
sheet.addCell(labe1);
sheet.addCell(labe2);
sheet.addCell(labe3);
sheet.addCell(labe4);
sheet.addCell(labe5);
sheet.addCell(labe6);
sheet.addCell(labe7);
sheet.addCell(labe8);
sheet.addCell(labe9);
sheet.addCell(labe10);
//---
ISaleInfoService iSaleInfoService = (ISaleInfoService) AppContextUtil
.getBean(RKACommon.saleInfo_Servcie);
List<Saleinfo> saleinfoList =iSaleInfoService.getSaleInfo(RKACommon.sale_sqlQryByDate, getParams());
if (saleinfoList != null || saleinfoList.size() > 0) {
getAllInfoList(saleinfoList);
}
for (int i = 0; i < saleInfoAndUserList.size(); i++) {
Label label0 = new Label(0, i + 1, saleInfoAndUserList.get(i)
.getSaleDate().toString());
Label label1 = new Label(1, i + 1, saleInfoAndUserList.get(i)
.getImNumber());
Label label2 = new Label(2, i + 1, saleInfoAndUserList.get(i)
.getUserName());

Label label3 = new Label(3, i + 1, saleInfoAndUserList.get(i)
.getTelephone());
Label label4 = new Label(4, i + 1, saleInfoAndUserList.get(i)
.getStoreName());

Label label5 = new Label(5, i + 1, saleInfoAndUserList.get(i)
.getSaleCount().toString());
Label label6 = new Label(6, i + 1, saleInfoAndUserList.get(i)
.getSalePrice().toString());
Label label7 = new Label(7, i + 1, saleInfoAndUserList.get(i)
.getAreaName());
Label label8 = new Label(8, i + 1, saleInfoAndUserList.get(i)
.getStandardSegment());
Label label9 = new Label(9, i + 1, saleInfoAndUserList.get(i)
.getChannelName());
Label label10 = new Label(10, i + 1, saleInfoAndUserList.get(i)
.getProductName());
// 将生成的单元格添加到工作表中
sheet.addCell(label0);
sheet.addCell(label1);
sheet.addCell(label2);
sheet.addCell(label3);
sheet.addCell(label4);
sheet.addCell(label5);
sheet.addCell(label6);
sheet.addCell(label7);
sheet.addCell(label8);
sheet.addCell(label9);
sheet.addCell(label10);
}
book.write();
book.close();
} catch (RowsExceededException e) {
e.printStackTrace();
} catch (WriteException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return null;
}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值