.Net核心API返回带有请求对象的流内容

Question

我试图从Web API返回Excel文件，但我得到的是JSON响应，而不是下载的文件。

using (var excel = new ExcelPackage())
        {
            var sheet = excel.Workbook.Worksheets.Add("Placments");

            var taxonomyConnStr = GetConnectionString(DatabaseSettings.ConnectionStringNames.Taxonomy);
            var plookConnStr = GetConnectionString(DatabaseSettings.ConnectionStringNames.Plook);
            var content = _repo.GetPlacementDataTable(masterAgencyDivisionId, masterClientId, plookConnStr);



            if (content.Rows.Count > 0)
            {
                Color colFromHex = System.Drawing.ColorTranslator.FromHtml("#000000");

                sheet.Row(1).Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
                sheet.Row(1).Style.Fill.BackgroundColor.SetColor(colFromHex);
                sheet.Row(1).Style.Font.Color.SetColor(Color.White);
                sheet.Row(1).Style.Font.Bold = true;
                sheet.Row(1).Style.Font.Size = 12;

                sheet.Cells[1, 1].LoadFromDataTable(content, true);

                sheet.Cells[sheet.Dimension.Address].AutoFitColumns();

            }
            else
            {
                sheet.Cells[1, 1].LoadFromText("There is no data for filtered results. Please adjust your selections.");
            }

            var stream = new MemoryStream();
            excel.SaveAs(stream);
            stream.Position = 0;

            var result = new HttpResponseMessage(HttpStatusCode.OK);
            result.Content = new StreamContent(stream);
            result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-sream");
            result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
            {
                FileName = "Report.xlsx"

            };

            return result;

        }

这是我的AJAX调用

$(document).ready(function () {
    $("#btnSubmit").click(function () {
           window.location = "https://localhost:44318/custom/GetPlacementExcel/6/77";
           })
})

但我得到的回应是：

{“version”：{“major”：1，“minor”：1，“build”：-1，“revision”：-1，“majorRevision”：-1，“minorRevision”：-1}，“content”：{“headers”：[{“key”：“Content-Disposition”，“value”：[“attachment;filename=Report.xlsx“]}，{”key“：”Content-Type“，”value“：[”application/octet-stream“]}]}，”statusCode“：200，”reasonPhrase“：”OK“，”headers“：[]，”requestMessage“：null，”isSuccessStatusCode“：true}

Answer 1

Asp.NetCore不再使用Http响应消息，因此您需要使用适当的操作结果来返回所需的数据。

由于您已经将数据存储在流中，因此返回一个＜code＞FileStreamResult

public IActionResult MyAction() {

    //...code removed for brevity

    var stream = new MemoryStream();
    excel.SaveAs(stream);
    stream.Position = 0;
    var fileName = "Report.xlsx";
    var mimeType = "application/vnd.ms-excel";
    //return the data stream as a file
    return File(stream, mimeType, fileName); //<-- returns a FileStreamResult

}