1. In MVC view:
<input name='input' id='input' type='button' value='export'>
2. in js:
$(function () {
$("#input").on("click", exportclick);
});
function exportclick(e) {
//基础信息是要导出的表头:
var basicInfo = $("#BasicInfo").html();
var calResultInfo = $("#calcDiv").html();
var txt_target1 = $("#target1").val();
var txt_tagret2 = $("#target2").val();
var txt_calcdiv = $("#calcDiv").html();
var inputtable = " <table>" + $("#inputtable").html() + " </table>";
var actionStr = "2Excel?txt_target1=" + txt_target1 + "&txt_tagret2=" + txt_tagret2 + " ";
//季节设置
var seasonSetTableRows = document.getElementById("inputtable").rows.length;
var seasonSetTableColumns = document.getElementById("inputtable").rows[3].cells.length;
var inputRows = new Object();
inputRows.RowsList = [];
for (var m = 3; m < seasonSetTableRows; m++) {
var columns = new Array([seasonSetTableColumns]);
for (var n = 0; n < seasonSetTableColumns;n++){
if (n == 0 || n == 1 || n == 2) {
columns[n] = document.getElementById("inputtable").rows[m].cells[n].innerText;
}
else
{
columns[n] = document.getElementById("inputtable").rows[m].cells[n].getElementsByTagName("input")[0].value;
}
}
inputRows.RowsList.push(columns);
}
var form = $("<form>");//定义一个form表单
form.attr("id", "exportnew");
form.attr("style", "display:none");
form.attr("target", "/CharterLeg/incomeBudget2Excel");
form.attr("method", "post");
form.attr("action", actionStr);
var input1 = $("<input>");
input1.attr("type", "hidden").attr("name", "basicInfo").attr("value", basicInfo);
var input2 = $("<input>");
input2.attr("type", "hidden").attr("name", "calResultInfo").attr("value", calResultInfo);
var input3 = $("<input>");
input3.attr("type", "hidden").attr("name", "txt_calcdiv").attr("value", txt_calcdiv);
var input4 = $("<input>");
input4.attr("type", "hidden").attr("name", "inputtable").attr("value", inputtable);
var input5 = $("<input>");
input5.attr("type", "hidden").attr("name", "basic").attr("value", basicInfo);
var input6 = $("<input>");
input6.attr("type", "hidden").attr("name", "model").attr("id", "model").attr("value", JSON.stringify(inputRows));
//$("#exportnew").remove();
$("body").append(form);//将表单放置在web中
form.append(input1);
form.append(input2);
form.append(input3);
form.append(input4);
form.append(input5);
form.append(input6);
form.submit();//表单提交
};
3. in controller: