ClearAllNodeXLTables ( Microsoft.Office.Interop.Excel.Workbook workbook ) { Debug.Assert(workbook != null); SubgraphImageColumnPopulator.DeleteSubgraphImages(workbook); ExcelTableUtil.ClearTables(workbook, WorksheetNames.Edges, TableNames.Edges, WorksheetNames.Vertices, TableNames.Vertices, WorksheetNames.OverallMetrics, TableNames.OverallMetrics, WorksheetNames.OverallMetrics, TableNames.OverallReadabilityMetrics, WorksheetNames.Miscellaneous, TableNames.DynamicFilterSettings ); ClearGroupTables(workbook); foreach (String sWorksheetName in new String [] { WorksheetNames.TopNByMetrics, WorksheetNames.TwitterSearchNetworkTopItems, WorksheetNames.WordCounts, WorksheetNames.WordPairCounts, }) { ExcelUtil.TryClearWorksheet(workbook, sWorksheetName); } (new PerWorkbookSettings(workbook)).OnWorkbookTablesCleared(); }
ClearGroupTables ( Microsoft.Office.Interop.Excel.Workbook workbook ) { Debug.Assert(workbook != null); ExcelTableUtil.ClearTables(workbook, WorksheetNames.Groups, TableNames.Groups, WorksheetNames.GroupVertices, TableNames.GroupVertices, WorksheetNames.GroupEdgeMetrics, TableNames.GroupEdgeMetrics ); }