导出到excel

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: