ShowOrHideColumnGroup ( Microsoft.Office.Interop.Excel.Workbook oWorkbook, ColumnGroups eColumnGroup, Boolean bShow ) { Debug.Assert(oWorkbook != null); #if DEBUG // Verify that a single value in the ColumnGroup enumeration has been // specified. Double dLogColumnGroup = Math.Log((Double)eColumnGroup, 2); Debug.Assert((Int32)dLogColumnGroup == dLogColumnGroup); #endif ListObject oTable; if (TryGetColumnGroupTable(oWorkbook, eColumnGroup, out oTable)) { ExcelColumnHider.ShowOrHideColumns(oTable, GetColumnNames(oWorkbook, eColumnGroup), bShow); if (eColumnGroup == ColumnGroups.VertexOtherColumns) { // Hiding the subgraph image column doesn't hide the images in // the column. SubgraphImageColumnPopulator.ShowOrHideSubgraphImages( oWorkbook, bShow); } } }
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(); }
OnImageCreationCompleted ( RunWorkerCompletedEventArgs e ) { AssertValid(); Debug.Assert(m_oWorkbook != null); Debug.Assert(m_oSelectedVertexNames != null); if (e.Cancelled) { this.State = DialogState.Idle; lblStatus.Text = "Image creation stopped."; } else if (e.Error != null) { this.State = DialogState.Idle; Exception oException = e.Error; if (oException is System.IO.IOException) { lblStatus.Text = "Image creation error."; this.ShowWarning(oException.Message); } else { ErrorUtil.OnException(oException); } } else { // Success. Were temporary images created that need to be inserted // into the vertex worksheet? Debug.Assert(e.Result is TemporaryImages); TemporaryImages oTemporaryImages = (TemporaryImages)e.Result; if (oTemporaryImages.Folder != null) { // Yes. Insert them, then delete the temporary images. this.State = DialogState.PopulatingImageColumn; String sLastStatusFromSubgraphImageCreator = lblStatus.Text; lblStatus.Text = "Inserting subgraph thumbnails into the worksheet. Please" + " wait..."; SubgraphImageColumnPopulator.PopulateSubgraphImageColumn( m_oWorkbook, oTemporaryImages); lblStatus.Text = sLastStatusFromSubgraphImageCreator; } this.State = DialogState.Idle; if (m_eMode == DialogMode.Automate) { this.Close(); } } }