{

//Add a WorkbookPart to the document

WorkbookPart workbookPart = package.AddWorkbookPart();

workbookPart.Workbook = new Workbook();

 

//Add a WorksheetPart to the WorkbookPart

WorksheetPart worksheetPart = workbookPart.AddNewPart<WorksheetPart>();

worksheetPart.Worksheet = new Worksheet(new SheetData());

//Add Sheets to the workbook Sheets sheets = package.WorkbookPart.Workbook.AppendChild<Sheets>(new Sheets());

 

//Append a new worksheet and associate it with the workbook. Sheet sheet = new Sheet() { Id = package.WorkbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Sheet 1" };

sheets.Append(sheet);

workbookPart.Workbook.Save();

package.Close();

}