open a macro enabled excel file and populate it using openxml

See more:

C#

OpenXML

I have a macro enabled excel file.

I want to open the file as a stream and populate the file using OpenXML.

Following is my code to Open the file.

But i dont know how to take this file in stream and populate it with data.

SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(filepath, SpreadsheetDocumentType.Workbook);

WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();