/**
* 获取的数据存储到excel中
*/
function getDataByExcel(xzqhArray, sql) {
// sql 语句进行base64编码传输
sql = new Base64().encode(sql);
// 增加iframe元素是为了防止form表单post提交后页面跳转
var iframe = document.createElement("iframe");
iframe.id = "targetIfr";
iframe.name = "targetIfr";
iframe.src = "about:blank";
iframe.style.display = "none";
var form = document.createElement("form");
form.id = "remoteSqlForm"
form.action = "接口";
form.method = "post"; //指定为post
form.style.display ='none';
form.target = "targetIfr"
form.innerHTML = "<input type='hidden' name='xzqhArray' value='" + xzqhArray + "'/>"+
"<input type='hidden' name='sql' value='" + sql + "'/>";
document.body.appendChild(iframe);
document.body.appendChild(form);
form.submit();
}