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
);
}