function exe(){
$.ajax({
type:'post',
url:m_strContextPath+'action?searchHelperAction=2',
dataType:'text',
contentType :"application/x-www-form-urlencoded; charset=UTF-8",
async:false,
success:function(d,s){
if(d=='0'){
alert("数据为空,不能导出。");
}else {
var url_x = m_strContextPath+'action?searchHelperAction=3';
window.location.href = url_x;
return;
}
}
});
}
public String excel(HttpContext arg0, IContextDictionary arg1){
HttpServletResponse response = arg0.getResponse();
OutputStream os = response.getOutputStream();// 取得输出流
response.reset();// 清空输出流
response.setHeader("Content-disposition", "attachment; filename="+new String("XXXX".getBytes("GB2312"),"8859_1")+".xls");// 设定输出文件头
response.setContentType("application/msexcel");// 定义输出类型
//File excelFile = new File(filePath);
// 文件格式
WritableCellFormat format = new WritableCellFormat();
// x 靠左
format.setAlignment(Alignment.RIGHT);
// y 靠顶
format.setVerticalAlignment(VerticalAlignment.TOP);
// 创建一个工作文件
WritableWorkbook writableWorkbook = Workbook.createWorkbook(os);
// 创建一个工作簿
WritableSheet sheet1 = writableWorkbook.createSheet("XXXXXXXX", 0);
//创建行数 设置行的宽度
sheet1.setColumnView(0, 20);
sheet1.setColumnView(1, 20);
// 设置行的值
sheet1.addCell(new Label(0, 0, "XXXXX", format));
sheet1.addCell(new Label(1, 0, "XXXXX", format));
// 把集合写入到excel中
int rowNum = 1;
for (DataRow dr : dt.getRows())
{
int colspanNum = 0;
sheet1.addCell(new Label(colspanNum, rowNum, dr.getString("XMQID"), format));
sheet1.addCell(new Label(++colspanNum, rowNum, dr.getString("BLOCKID"), format));
rowNum++;
}
writableWorkbook.write();
writableWorkbook.close();
return null;
}