function output() {

            var branchCode = $("#currentBranchCode").val();

            var transDate = $("#currentTransDate").val();

            if (branchCode == "" || transDate == "") {

                layer.msg("暂无记录，无法导出", { icon: 7, time: 1000 });

                return;

            }

            var fileName = $("table caption").html() + ".xls";//设置下载时候的文件名

            //要请求的Url和携带的参数

            var url = "/SellAnalyze/Export?currentBranchCode=" + branchCode + "&currentTransDate=" + transDate;

            var xhr = new XMLHttpRequest();

            //设置响应类型为blob类型

            xhr.responseType = "blob";

            xhr.onload = function () {

                if (this.status == "200") {
　　　　　　　　　　　　//获取响应文件流　　

                    var blob = this.response;

                    var aElem = document.getElementById("exportUrl");
　　　　　　　　　　　　//将文件流保存到a标签

                    aElem.href = window.URL.createObjectURL(blob);

                    aElem.download = fileName;

                    aElem.onload = function (e) {

                            window.URL.revokeObjectURL(aElem.href);

                        };

                    $("#exportUrl").removeClass("hidden");

                    layer.confirm('文件已导出, 立即下载？', function (index) {

                        $("#download").click();

                        layer.close(index);

                        });

                }

            }

            xhr.open("post", url, true);

            xhr.send();

        }

　　　　 public ActionResult Export(int? currentBranchCode, DateTime currentTransDate)

        {

            MemoryStream ms = NPOIExcelWrite(datas);

            ms.Seek(0, SeekOrigin.Begin);

            return File(ms, "application/vnd.ms-excel");

        }

        /// <param name="datas">写入的数据</param>

        /// <returns></returns>

        private MemoryStream NPOIExcelWrite(SellDTO[] datas)

        {

            string[] titles = { "货品类别", "货品类别描述", "销售额", "同比", "环比" };

            NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();

            NPOI.SS.UserModel.ISheet sheet = book.CreateSheet("Sheet1");

            NPOI.SS.UserModel.IRow row = sheet.CreateRow();

            for (int i = ; i < titles.Length; i++)

            {

                row.CreateCell(i).SetCellValue(titles[i]);

            }

            for (int i = ; i < datas.Length; i++)

            {

                row = sheet.CreateRow(i + );

                row.CreateCell().SetCellValue(datas[i].JewelryType);

                row.CreateCell().SetCellValue(datas[i].JewelryTypeDesc);

                row.CreateCell().SetCellValue(datas[i].CurrentMonthSaleroom.ToString("F2"));

                row.CreateCell().SetCellValue(datas[i].YearOverYear);

                row.CreateCell().SetCellValue(datas[i].LinkRelative);

            }

            MemoryStream ms = new MemoryStream();

            book.Write(ms);

            ms.Flush();

            book = null;

            return ms;

        }