[后端] Asp.Net Core 导出Excel文件

Controller :

 1         [HttpGet]
 2         public IActionResult ExportExcel()
 3         {
 4             try
 5             {
 6 
 7                 StringBuilder htmlcontent = new StringBuilder();
 8 
 9                 htmlcontent.Append("<TABLE>");
10                 htmlcontent.Append("<TR>");
11                 htmlcontent.Append("<TD><B>A</B></TD>");    //列名A
12                 htmlcontent.Append("<TD><B>B</B></TD>");    //列名B
13                 htmlcontent.Append("<TD><B>C</B></TD>");    //列名C
14                 htmlcontent.Append("<TD><B>D</B></TD>");    //列名D
15                 htmlcontent.Append("<TD><B>E</B></TD>");    //列名E
16                 htmlcontent.Append("</TR>");
17 
18 
19                 htmlcontent.Append("<TR>");
20                 htmlcontent.Append($"<TD>Value</TD>");      //列名A对应的值
21                 htmlcontent.Append($"<TD>Value</TD>");      //列名B对应的值
22                 htmlcontent.Append($"<TD>Value</TD>");      //列名C对应的值
23                 htmlcontent.Append($"<TD>Value</TD>");      //列名D对应的值
24                 htmlcontent.Append($"<TD>Value</TD>");      //列名E对应的值
25                 htmlcontent.Append("</TR>");
26 
27                 htmlcontent.Append("</TABLE>");
28 
29                 string fileName = "文件名";
30 
31                 Response.Clear();
32                 Response.Headers.Add("content-disposition", "attachment;" + "filename=" + fileName + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
33                 Response.ContentType = "application/vnd.ms-excel";
34                 Response.WriteAsync(htmlcontent.ToString());
35 
36                 return Json(new { status = true, msg = "success" });
37             }
38             catch (Exception ex)
39             {
40                 return Json(new { status = false, msg = ex.Message });
41             }
42         }

Js :

 1 function ExportExcel() {
 2 
 3     let _url = getCurrentURL() + `/ControllerName/ExportExcel`;
 4 
 5     window.location.href = _url;
 6 }
 7 
 8 
 9 function getCurrentURL() {
10 
11     var urlorigin = window.location.origin;
12     var pathname = window.location.pathname;
13 
14     var lastindex = pathname.lastIndexOf(pathName);
15 
16     var url = urlorigin + pathname.substring(0, lastindex);
17     url = url.trimEnd("/");
18     if (url.substring(url.length - 1) === "/") {
19         url = url.substring(0, url.length - 1);
20     }
21     return url;
22 }