Read and save excel async is not work

[H0LIXI]

EPPlus usage

Noncommercial use

Environment

Windows10

Epplus version

7.1.x

Spreadsheet application

Excel

Description

I try to read and save excel async.
But the excel was not changed after save.

using (var excel = new ExcelPackage())
{
    await excel.LoadAsync(excelPath);
    var worksheets = excel.Workbook.Worksheets;
    foreach (var sheet in worksheets)
    {
        sheet.Cells[1, 1].Value = DateTime.Now.ToString();
    }

    await excel.SaveAsync();
}

I have provided a simple demo that can reproduce this problem
TestEPPlusAsync.zip

[JanKallman]

The Load/LoadAsync methods will load the file to the Stream without setting the ExcelPackage.File property, so if you use SaveAsync it will only save the workbook to the Stream property. Either set the ExcelPackage.File property to the FileInfo you want to save to or use the SaveAsAsync property.

[H0LIXI]

The Load/LoadAsync methods will load the file to the Stream without setting the ExcelPackage.File property, so if you use SaveAsync it will only save the workbook to the Stream property. Either set the ExcelPackage.File property to the FileInfo you want to save to or use the SaveAsAsync property.

Thank you for your reply. It works after setting the ExcelPackage.File property