cvs文件其实就是一文本文件的形式存储信息，该文件可转化为excel 文件及其他文件类型。
可以实现cvs文件下载的java代码
package com.jifeng.report.service.impl;
import java.io.File;
import java.io.OutputStream;
import java.text.MessageFormat;
import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.Region;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Service;
import com.jifeng.common.common.PortalConfig;
import com.jifeng.common.util.DateFormatHelper;
import com.jifeng.common.util.IdWorkerUtil;
import com.jifeng.common.util.StringUtil;
import com.jifeng.module.campaigns.entity.Campaigns;
import com.jifeng.report.service.CampaignsCsvService;
/**
* 营销活动cvs下载service实现
*/
@SuppressWarnings("deprecation")
@Service
public class CampaignsCsvServiceImpl implements CampaignsCsvService {
private Logger log = LoggerFactory.getLogger(CampaignsCsvServiceImpl.class);
/**
* 营销活动列表下载csv
* @param campaignsList 活动详情
* @param response
* @return
* @throws Exception
*/
public boolean campaignsListCsvDown(List<Campaigns> campaignsList, HttpServletResponse response){
try {
//CSV文件生成
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("campaignsListCsvDown");
HSSFCellStyle style = workbook.createCellStyle(); // 样式对象
style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 垂直
style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 水平
HSSFRow row = sheet.createRow((short) 0);
HSSFRow row1 = sheet.createRow((short) 1);
// 写入头部信息
addMergeCell(sheet,row,style,0,0,1,0,"活动名称");
addMergeCell(sheet,row,style,0,1,1,1,"开始日期");
addMergeCell(sheet,row,style,0,2,1,2,"持续时间");
addMergeCell(sheet,row,style,0,3,1,3,"店铺");
addMergeCell(sheet,row,style,0,4,1,4,"开销");
addMergeCell(sheet,row,style,0,5,0,6,"客流量变化");
addMergeCell(sheet,row1,style,1,5,1,5,"店铺");
addMergeCell(sheet,row1,style,1,6,1,6,"对比位置");
addMergeCell(sheet,row,style,0,7,1,7,"平均成本每增加访客");
//从第3行开始循环写数据
int rowNum = 2;
for (Campaigns campaigns : campaignsList) {
HSSFRow row2 = sheet.createRow(rowNum);
row2.createCell(0).setCellValue(campaigns.getCampaignsName());
row2.createCell(1).setCellValue(DateFormatHelper.formatToMdy(campaigns.getStartTime()));
row2.createCell(2).setCellValue(campaigns.getDayNum() + "天");
row2.createCell(3).setCellValue(campaigns.getStoreNum() + "家");
row2.createCell(4).setCellValue("$" + campaigns.getSpend());
row2.createCell(5).setCellValue(campaigns.getRateChange() + "%");
row2.createCell(6).setCellValue("不涉及");
if(campaigns.getCostAvg() > 0){
row2.createCell(7).setCellValue(campaigns.getCostAvg());
}else{
row2.createCell(7).setCellValue("不涉及");
}
rowNum++;
}
File file = new File(PortalConfig.getPdfAddress()+ IdWorkerUtil.nextId() +".csv");
String fileName = file.getPath();
if(null != response) {
// 设置下载时客户端Excel的名称
fileName = MessageFormat.format(fileName, DateFormatHelper.getDate());
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment;filename=" + StringUtil.toUTF8String("campaignsListCsvDown.csv"));
OutputStream ouputStream = response.getOutputStream();
workbook.write(ouputStream);
ouputStream.flush();
ouputStream.close();
}
return true;
} catch (Exception e) {
log.error("",e);
return false;
}
}
/**
* 营销活动详情根据日期下载csv
* @param campaignsList 活动详情
* @param response
* @return
* @throws Exception
*/
public boolean campaignsDetailsDayCsvDown(List<Campaigns> campaignsList, HttpServletResponse response) {
try {
//CSV文件生成
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("campaignsDetailsDayAnalysis");
//第一行
HSSFRow header = sheet.createRow(0);
header.createCell(0).setCellValue("日期");
header.createCell(1).setCellValue("总客流量");
header.createCell(2).setCellValue("平均客流量每店");
header.createCell(3).setCellValue("比较时期同比");
//从第2行开始循环写数据
int rowNum = 1;
for (Campaigns campaigns : campaignsList) {
HSSFRow row = sheet.createRow(rowNum);
row.createCell(0).setCellValue(campaigns.getCurrentDate());
row.createCell(1).setCellValue(campaigns.getEnters());
row.createCell(2).setCellValue(campaigns.getEntersAvg());
row.createCell(3).setCellValue(campaigns.getRateTb() + "%");
rowNum++;
}
File file = new File(PortalConfig.getPdfAddress()+ IdWorkerUtil.nextId() +".csv");
String fileName = file.getPath();
if(null != response) {
// 设置下载时客户端Excel的名称
fileName = MessageFormat.format(fileName, DateFormatHelper.getDate());
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment;filename=" + StringUtil.toUTF8String("campaignsDetailsDayAnalysis.csv"));
OutputStream ouputStream = response.getOutputStream();
workbook.write(ouputStream);
ouputStream.flush();
ouputStream.close();
}
return true;
} catch (Exception e) {
log.error("",e);
return false;
}
}
/**
* 营销活动详情根据场地下载csv
* @param campaignsList 活动详情
* @param response
* @return
* @throws Exception
*/
public boolean campaignsDetailsStoreCsvDown(List<Campaigns> campaignsList, HttpServletResponse response) {
try {
//CSV文件生成
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("campaignsDetailsStoreCsvDown");
//第一行
HSSFRow header = sheet.createRow(0);
header.createCell(0).setCellValue("店铺");
header.createCell(1).setCellValue("店铺客流量变化");
header.createCell(2).setCellValue("销售额");
header.createCell(3).setCellValue("成交率");
header.createCell(4).setCellValue("客流量");
//从第2行开始循环写数据
int rowNum = 1;
for (Campaigns campaigns : campaignsList) {
HSSFRow row = sheet.createRow(rowNum);
row.createCell(0).setCellValue(campaigns.getStoreName());
row.createCell(1).setCellValue(campaigns.getRateChange() + "%");
row.createCell(2).setCellValue("$" + campaigns.getSales());
row.createCell(3).setCellValue(campaigns.getConversion() +"%");
row.createCell(4).setCellValue(campaigns.getEnters());
rowNum++;
}
File file = new File(PortalConfig.getPdfAddress()+ IdWorkerUtil.nextId() +".csv");
String fileName = file.getPath();
if(null != response) {
// 设置下载时客户端Excel的名称
fileName = MessageFormat.format(fileName, DateFormatHelper.getDate());
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment;filename=" + StringUtil.toUTF8String("campaignsDetailsStoreCsvDown.csv"));
OutputStream ouputStream = response.getOutputStream();
workbook.write(ouputStream);
ouputStream.flush();
ouputStream.close();
}
return true;
} catch (Exception e) {
log.error("",e);
return false;
}
}
/**
* 合并单元格写法
* @param sheet
* @param row
* @param style 样式
* @param beginRow 开始行
* @param beginColumn 开始列
* @param endRow 结束行
* @param endColumn 结束列
* @param value 值
*/
public void addMergeCell(HSSFSheet sheet,HSSFRow row,HSSFCellStyle style,int beginRow,int beginColumn,int endRow,int endColumn,String value){
// 单元格合并
// 四个参数分别是：起始行，起始列，结束行，结束列
sheet.addMergedRegion(new Region(beginRow, (short) beginColumn, endRow, (short) endColumn));
//希尔数据的列
HSSFCell cell = row.createCell((short) beginColumn);
// 跨单元格显示的数据
cell.setCellValue(value);
cell.setCellStyle(style);
}
}
相关推荐
使用POI技术对Excel导入导出及支持CSV文件导入导出。
采用POI、JXL框架导出CVS文件，支持千万级数据导出，无内存溢出，自己项目中使用中。
主要为大家详细介绍了java导出生成csv文件的相关资料，具有一定的参考价值，感兴趣的小伙伴们可以参考一下
easypoi常用导入，导出，工具，引入easypoi包ExcelUtil工具类，可以直接导出查询的数据
轻松解决普通poi形式导出Excel的中出现的栈溢出问题，此资源可实现千万级数据分批导出csv文件，测试实现16500000条数据大概80秒左右；具体表里内容。
displaytag-1.1.1-execle@cvs导出中文乱码问题解决.jar
poi读取大量数据会造成gc内存溢出的报错,由于垃圾回收机制无法将大量的对象及时的回收,而这些对象又会保存在内存中,会导致内存不够用的情况,这时候我们就需要使用新的方法,读取为cvs即可.此解决方案可支持千万数据的...
小demo，直接运行Test.java就行了 导出文件在D盘
1. 数据导出至Excel.doc(包括当前导出方法小结，自己的示例，参考的网站) 2. poi-3.7-20101029.jar：当前最新的稳定的操作Excel的开发包 3. AirExcel.rar，as3xls.rar：air下Excel开发包 4. csvlib-1.4.1.rar：生成...