mvc html转excel,asp.net mvc 导出Excel-优快云博客

这段代码展示了如何处理HTTP Get请求，并根据查询参数创建一个CostToARTrans对象。接着，它从对象中获取数据并修改列名，然后删除不需要的列。最后，将数据导出为Excel文件，同时考虑了不同浏览器的兼容性问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[HttpGet]public void ExportNissan(string_queryParam)

{/*{

"CustomerCode": "",

"OrderNo": "",

"LegalCode": "",

"ProjectCode": "",

"OriginAeraCode": "",

"TransCode": "",

"DestAeraCode": "",

"Flag": "",

"BeginDT": "",

"EndDT": "",

"CustomerOrderNo": "",

"ETDBeginDT": "",

"ETDEndDT": ""

}*/

var queryParam = _queryParam == null ? JObject.Parse("{}") : JObject.Parse(_queryParam.Replace(" ", ""));

CostToARTrans artrans= newCostToARTrans

{

CustomerCode= queryParam["CustomerCode"] != null ? queryParam["CustomerCode"].ToString() : "",

OrderNo= queryParam["OrderNo"] != null ? queryParam["OrderNo"].ToString() : "",

LegalCode= queryParam["LegalCode"] != null ? queryParam["LegalCode"].ToString() : "",

ProjectCode= queryParam["ProjectCode"] != null ? queryParam["ProjectCode"].ToString() : "",

OriginAeraCode= queryParam["OriginAeraCode"] != null ? queryParam["OriginAeraCode"].ToString() : "",

TransCode= queryParam["TransCode"] != null ? queryParam["TransCode"].ToString() : "",

DestAeraCode= queryParam["DestAeraCode"] != null ? queryParam["DestAeraCode"].ToString() : "",

Flag= queryParam["Flag"] != null ? queryParam["Flag"].ToString() : "",

BeginDT= queryParam["BeginDT"] != null ? queryParam["BeginDT"].ToString() : "",

EndDT= queryParam["EndDT"] != null ? queryParam["EndDT"].ToString() : "",

CustomerOrderNo= queryParam["CustomerOrderNo"] != null ? queryParam["CustomerOrderNo"].ToString() : "",

ETDBeginDT= queryParam["ETDBeginDT"] != null ? queryParam["ETDBeginDT"].ToString() : "",

ETDEndDT= queryParam["ETDEndDT"] != null ? queryParam["ETDEndDT"].ToString() : ""};

DataTable dt=CostToARTrans.GetTable(artrans);//修改列名

dt.Columns["OrderNo"].ColumnName = "订单号码";//删除不需要数据列

dt.Columns.Remove("aa");var ie = Request.Headers.Get("User-Agent").IndexOf("MSIE") > 0 || Request.Headers.Get("User-Agent").IndexOf("Trident") > 0;

Response.Charset= "UTF-8";

Response.ContentEncoding= System.Text.Encoding.GetEncoding("UTF-8");

Response.ContentType= "application/ms-excel/msword";

Response.AddHeader("Content-Disposition", "attachment;fileName=" + (ie ? HttpUtility.UrlEncode("Test", System.Text.Encoding.UTF8) : HttpUtility.UrlEncode("Test", System.Text.Encoding.UTF8)) + ".xls");

Response.BinaryWrite(ExcelHelper.RenderToMemory(dt,"Test", true).ToArray());

}