1.使用的文件POI
https://pan.baidu.com/s/1tlHH0pBLKTGRsoqNO1I1Ng
2.页面效果
3.前端页面
//工具栏
var toolbar = [ {
id : 'button-search',
text : '查询',
iconCls : 'icon-search',
handler : doSearch
},{
id : 'button-export',
text : '导出',
iconCls : 'icon-undo',
handler : doExport
}];
------------------------------------
//对doExport绑定事件
function doExport(){
//发送请求,请求action进行文件下载
window.location.href = "subareaAction_exportXls.action" ;
}
4.SubareaAction.java
@Scope("prototype")
public class SubareaAction extends BaseAction<Subarea>{
@Autowired
private ISubareaService subareaService ;
/**
* 导出分区数据
*/
public String exportXls() throws Exception {
//1.查询分区的所有数据
List<Subarea> list = subareaService.findAll();
//2.使用POI将数据写到Excel文件中
//在内存中创建一个Excel文件
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
//创建一个标签
HSSFSheet sheet = hssfWorkbook.createSheet("分区数据");
//创建标题行 即从Excel表格的第一行开始写入
HSSFRow headRow = sheet.createRow(0);
headRow.createCell(0).setCellValue("分区编号");
headRow.createCell(1).setCellValue("开始编号");
headRow.createCell(2).setCellValue("结束编号");
headRow.createCell(3).setCellValue("位置信息");
headRow.createCell(4).setCellValue("省市区");
for (Subarea subarea : list) {
HSSFRow dataRow = sheet.createRow(sheet.getLastRowNum() + 1);
dataRow.createCell(0).setCellValue(subarea.getId());
dataRow.createCell(1).setCellValue(subarea.getStartnum());
dataRow.createCell(2).setCellValue(subarea.getEndnum());
dataRow.createCell(3).setCellValue(subarea.getPosition());
dataRow.createCell(4).setCellValue(subarea.getRegion().getName());
}
//第三步:使用输出流进行文件下载(一个流、两个头)
String filename = "分区数据.xls";
String contentType = ServletActionContext.getServletContext().getMimeType(filename);
ServletOutputStream out = ServletActionContext.getResponse().getOutputStream();
ServletActionContext.getResponse().setContentType(contentType);
//获取客户端浏览器类型
String agent = ServletActionContext.getRequest().getHeader("User-Agent");
filename = FileUtils.encodeDownloadFilename(filename, agent);
ServletActionContext.getResponse().setHeader("content-disposition", "attachment;filename="+filename);
hssfWorkbook.write(out);
return NONE;
}
}
5.FileUtils工具类
public class FileUtils {
/**
* 下载文件时,针对不同浏览器,进行附件名的编码
*
* @param filename
* 下载文件名
* @param agent
* 客户端浏览器
* @return 编码后的下载附件名
* @throws IOException
*/
public static String encodeDownloadFilename(String filename, String agent)
throws IOException {
if (agent.contains("Firefox")) { // 火狐浏览器
filename = "=?UTF-8?B?"
+ new BASE64Encoder().encode(filename.getBytes("utf-8"))
+ "?=";
filename = filename.replaceAll("\r\n", "");
} else { // IE及其他浏览器
filename = URLEncoder.encode(filename, "utf-8");
filename = filename.replace("+"," ");
}
return filename;
}
}
service层与dao层代码略