在.NET CORE 3.1中打开Excel文件，编辑并另存为流

using Microsoft.Office.Interop.Excel;

Application excelApp = new Application();
Workbook workbook = excelApp.Workbooks.Open("path/to/your/excel/file.xlsx");

Worksheet worksheet = workbook.ActiveSheet;

Range cell = worksheet.Cells[1, 1]; // 获取第一个单元格
cell.Value = "Hello, World!"; // 修改单元格的值

MemoryStream stream = new MemoryStream();
workbook.SaveAs(stream);

workbook.Close();
excelApp.Quit();
Marshal.ReleaseComObject(worksheet);
Marshal.ReleaseComObject(workbook);
Marshal.ReleaseComObject(excelApp);

using Microsoft.Office.Interop.Excel;
using System.IO;
using System.Runtime.InteropServices;

namespace ExcelManipulation
{
    class Program
    {
        static void Main(string[] args)
        {
            Application excelApp = new Application();
            Workbook workbook = excelApp.Workbooks.Open("path/to/your/excel/file.xlsx");
            Worksheet worksheet = workbook.ActiveSheet;

            Range cell = worksheet.Cells[1, 1];
            cell.Value = "Hello, World!";

            MemoryStream stream = new MemoryStream();
            workbook.SaveAs(stream);

            workbook.Close();
            excelApp.Quit();
            Marshal.ReleaseComObject(worksheet);
            Marshal.ReleaseComObject(workbook);
            Marshal.ReleaseComObject(excelApp);
        }
    }
}