从aspnet-core api控制器使用javascript下载Excel文件 [英] Download excel file using javascript from aspnet-core api controller

问题描述

我的

My excel file is corrupted. I tried converting to bytearray and using other types but to no avail.

I returned this from the API:

return File(excelPackage.GetAsByteArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName);

AJAX Call:

$('#form').on('submit', function (e) {
    e.preventDefault();
    $.ajax({
        url: '/api/Excel/DownloadExcel',
        type: 'POST',
        data: $('#form').serialize()
    })
        .done(function (data) {
            var a = document.createElement('a');
            var url = window.URL.createObjectURL(new Blob([data],
                        {type:"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" }));
            a.href = url;
            a.download = 'myfile.xlsx';
            a.click();
            window.URL.revokeObjectURL(url);
        })
        .fail(function (response) {
            displayErrorMessage(response.status, response.responseText);
        });
});

解决方案

Here is a simple workaround like below:

1.Model:

public class UserInfo
{
    public string UserName { get; set; }

    public int Age { get; set; }
}

2.View:

<form id="form">
    <input type="submit" value="Export" />
</form>
@section Scripts{ 
<script>
    $('#form').on('submit', function (e) {
        var data = $('#form').serialize();
        console.log(data);
        e.preventDefault();
        $.ajax({
            url: '/Home/DownloadExcel',
            type: 'POST',
            data: $('#form').serialize(),
            xhrFields: {
                responseType: 'blob'
            },
            success: function (data) {
                window.location = '/Home/Download';
            }
        })
    })
</script>
}

3.Controller:

[HttpPost]
public ActionResult DownloadExcel(List<UserInfo> list)
{
    list = new List<UserInfo>() { 
        new UserInfo(){ UserName="aa",Age=23},
        new UserInfo(){ UserName="ab",Age=24},
        new UserInfo(){ UserName="ac",Age=23}
    };
    using (var package = new ExcelPackage())
    {
        var workSheet = package.Workbook.Worksheets.Add("Sheet1");
        workSheet.Cells.LoadFromCollection(list, true);
        package.Save();
        TempData["file"] = package.GetAsByteArray();
        return Ok();
    }         
}
[HttpGet]
public virtual ActionResult Download()
{
    byte[] data = TempData["file"] as byte[];
    return File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "myfile.xlsx");                  
}

4.Result:

这篇关于从aspnet-core api控制器使用javascript下载Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！