asp.net mvc 导出Excel

最新推荐文章于 2025-09-16 16:11:42 发布

转载最新推荐文章于 2025-09-16 16:11:42 发布 · 227 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

原文链接：http://www.cnblogs.com/CHNMurphy/p/10900887.html

标签

#测试 #json

本文介绍了一个使用C#实现的功能，该功能允许将检查清单数据导出到Excel文件中。具体步骤包括：解析查询参数，从数据库获取数据，修改列名，删除不必要的列，以及将数据写入Excel文件并提供下载链接。代码示例展示了如何处理各种请求头，确保文件名正确编码，并设置响应头以便浏览器可以下载Excel文件。

        [HttpGet]
        public void ExportNissan(string CheckListNo)
        {
            JObject queryParam;
            if (CheckListNo == null) queryParam = JObject.Parse("{}");
            else queryParam = JObject.Parse(CheckListNo.Replace("&nbsp;", ""));

            CostToARTrans artrans = new CostToARTrans
            {
                CustomerCode = IsEmpity(queryParam["CustomerCode"]),
                OrderNo = IsEmpity(queryParam["OrderNo"])               
            };
            DataTable dt = CostToARTrans.GetTable(artrans);

            //region 修改列名
            dt.Columns["OrderNo"].ColumnName = "订单号码";
            
            //region 删除不需要数据列
            dt.Columns.Remove("CustomerCode");            

            string fileName = string.Empty;
            var ie = Request.Headers.Get("User-Agent").IndexOf("MSIE") > 0 || Request.Headers.Get("User-Agent").IndexOf("Trident") > 0;
            if (ie) fileName = HttpUtility.UrlEncode("test", System.Text.Encoding.UTF8);
            else fileName = HttpUtility.UrlEncode("test", System.Text.Encoding.UTF8);

            Response.Charset = "UTF-8";
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
            Response.ContentType = "application/ms-excel/msword";
            Response.AddHeader("Content-Disposition", "attachment;fileName=" + fileName + ".xls");
            Response.BinaryWrite(ExcelHelper.RenderToMemory(dt, "test", true).ToArray());
        }
        private string IsEmpity(object queryParam)
        {
            return queryParam != null ? queryParam.ToString() : "";
        }

function fn_ExportNissan()
{
    var queryParams = {
        CustomerCode: $("#cboCustomer").combobox("getValue"),
        OrderNo: $("#txtOrderNo").textbox("getText")        
    };
    var str_CellInfo = JSON.stringify(queryParams);
    var url = "/TestAPI/ExporteXCEL?CheckListNo=" + str_CellInfo;
    window.open(url);
}