EPPlus - .NET - Preserve VBA Project when loading in Excel package

Question

I am loading in an existing xlsm (macro-enabled) file, filling it with data, and outputting the stream to be downloaded by the user. When I do, Excel says it "cannot open the file because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

If I just pull the existing xlsm file and stream it out the controller, Excel is able to open it. The "corruption" only happens when I run it through EPPlus.

public Stream PopulateTemplateWithData()
{
    using var package = new ExcelPackage(_templateStream);

    var propName = package.Workbook.Names[PROP];
    var propWorksheet = propName.Worksheet;
    var propCell = propWorksheet.Cells[propName.Start.Row, propName.Start.Column];
    propCell.Value = _inputData.Prop;

    return package.Stream;
}

// Controller method
public IActionResult DownloadPopulatedWorkbook()
{
    var stream = PopulateTemplateWithData();
    return File(stream, "application/vnd.ms-excel.sheet.macroenabled.12", "example.xlsm");
}

Sean Ivins · Accepted Answer · 2024-09-24 13:48:24Z

1

The problem was that I wasn't calling package.Save() or package.SaveAs(outputStream), so package.Stream was not a complete, finalized Excel file.

answered Sep 24, 2024 at 13:48

Sean Ivins

1133 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

EPPlus - .NET - Preserve VBA Project when loading in Excel package

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related