1、前端js
function exportRecord(){
var browseUrl=$("#browseUrl").val();
if(browseUrl == null || browseUrl == ""){
$.messager.show({
title : '提示',
msg : '浏览资源ID,不能为空!'
});
return ;
}else{
var data = $.toJSON(getCustomerSearch());
window.location.href="statResourceBrowseAction!exportStatResourceBrowse?queryJson="+data+"&excelTatol="+excelTatol;
}
}
二、Java请求处理
public void exportStatResourceBrowse() {
ExportToExcelUtil<StatResourceBrowse> excelUtil = new ExportToExcelUtil<StatResourceBrowse>();
// 导出总记录数
excelTatol = request.getParameter("excelTatol") == null ? 10 : Integer.parseInt(request.getParameter("excelTatol"));
OutputStream out = null;
try {
out = response.getOutputStream();
excelUtil.setResponseHeader(response,"Excel表表名");
String[] headers = { "列1", "列2", "列3", "列4","列5","列6","列7"};
String[] columns = { "Id", "Title","areas", "province","hospital","Level","Source"};
List<StatResourceBrowse> dataset = service.getList(getQueryJsonKeywordObject());
excelUtil.exportExcel( headers, columns, dataset, out, request, "");
} catch (Exception e1) {
e1.printStackTrace();
} finally {
try {
out.flush();
out.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
三、poi导出Excel工具类
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.lang.reflect.Method;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collection;
import java.uti