.NET Core 2如何从内存流生成并下载Excel文件（不存服务器）

I recently hit this exact problem while building a .NET Core project: I needed to generate an Excel spreadsheet from database records and let users download it immediately—no saving the file to the server first.

At first, searching up keywords gave me some vague ideas, but most ASP.NET solutions out there don’t work for .NET Core. They rely on old HttpContext tricks or server-side file handling that’s just not compatible anymore. After testing a few approaches and digging through docs, I found a solid working solution that I want to share with anyone else stuck on this.

Step-by-Step Implementation #

1. Pick an Excel Library #

I went with EPPlus for this—it’s lightweight, well-maintained, and plays nicely with .NET Core. Install it via NuGet:

# NuGet Package Manager
Install-Package EPPlus

# Or .NET CLI
dotnet add package EPPlus

2. Generate the Excel File in Memory #

Instead of writing to a server file, we’ll build the entire workbook in a MemoryStream. Here’s a practical example with sample data (swap in your own records):

using OfficeOpenXml;
using System.IO;
using System.Collections.Generic;

public MemoryStream CreateExcelStream()
{
    // Required for EPPlus v5+ - set your license type
    ExcelPackage.LicenseContext = LicenseContext.NonCommercial; // Use Commercial if you have a license

    var stream = new MemoryStream();
    using (var excelPackage = new ExcelPackage(stream))
    {
        // Add a worksheet
        var worksheet = excelPackage.Workbook.Worksheets.Add("My Records");

        // Add header row
        worksheet.Cells[1, 1].Value = "ID";
        worksheet.Cells[1, 2].Value = "Full Name";
        worksheet.Cells[1, 3].Value = "Phone Number";

        // Populate with your actual data (replace this with your record fetch logic)
        var sampleRecords = new List<UserRecord>
        {
            new UserRecord { Id = 1, FullName = "Alex Morgan", Phone = "555-1234" },
            new UserRecord { Id = 2, FullName = "Sam Taylor", Phone = "555-5678" }
        };

        // Fill rows with data
        int currentRow = 2;
        foreach (var record in sampleRecords)
        {
            worksheet.Cells[currentRow, 1].Value = record.Id;
            worksheet.Cells[currentRow, 2].Value = record.FullName;
            worksheet.Cells[currentRow, 3].Value = record.Phone;
            currentRow++;
        }

        // Auto-fit columns for better readability
        worksheet.Cells.AutoFitColumns();

        // Save the workbook to the memory stream
        excelPackage.Save();
    }

    // Reset stream position to the start so the response can read it
    stream.Position = 0;
    return stream;
}

// Replace this with your actual data model
public class UserRecord
{
    public int Id { get; set; }
    public string FullName { get; set; }
    public string Phone { get; set; }
}

3. Return the Stream as a Download in Your Controller #

In your .NET Core controller, use FileStreamResult to send the memory stream straight to the user’s browser as a downloadable file:

using Microsoft.AspNetCore.Mvc;

public class DownloadController : Controller
{
    public IActionResult GetExcel()
    {
        var excelStream = CreateExcelStream();
        
        // Set the correct MIME type for .xlsx files
        return File(
            fileStream: excelStream,
            contentType: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
            fileDownloadName: "User_Records.xlsx"
        );
    }
}

Important Notes #

• EPPlus License: Don’t forget to set LicenseContext—EPPlus requires this for legal use (non-commercial or commercial).
• Memory Management: The using statement takes care of disposing the ExcelPackage, and the MemoryStream is handled by the framework once the response is sent.
• MIME Type: Using the correct content type ensures browsers recognize the file as an Excel spreadsheet instead of a generic binary file.

This approach skips server-side storage entirely—everything happens in memory, and the file is sent directly to the user’s device for download.

内容的提问来源于stack exchange，提问作者Elnoor