private void ClearSpreadsheetDocument(SpreadsheetDocument Document)
{
Document.WorkbookPart.DeletePart(Document.WorkbookPart.CalculationChainPart);
foreach (Sheet curSheet in Document.WorkbookPart.Workbook.Sheets)
{
WorksheetPart workSheetPart = SpreadsheetReader.GetWorksheetPartByName(Document, curSheet.Name);
SheetData sheetData = workSheetPart.Worksheet.Elements <SheetData>().First();
if (!sheetData.HasChildren)
{
MergeCells p = workSheetPart.Worksheet.GetFirstChild <MergeCells>();
if (p != null)
{
p.Remove();
}
}
}
}
