TryAutoFillNumericRangeColumn ( ListObject oTable, String sSourceColumnName, String sDestinationColumnName, NumericRangeColumnAutoFillUserSettings oDetails, out Double dSourceCalculationNumber1, out Double dSourceCalculationNumber2, out Int32 iDecimalPlaces ) { Debug.Assert(oTable != null); Debug.Assert(!String.IsNullOrEmpty(sDestinationColumnName)); Debug.Assert(oDetails != null); dSourceCalculationNumber1 = dSourceCalculationNumber2 = Double.MinValue; iDecimalPlaces = Int32.MinValue; if (String.IsNullOrEmpty(sSourceColumnName)) { return(false); } return(TableColumnMapper.TryMapToNumericRange( oTable, sSourceColumnName, sDestinationColumnName, oDetails.UseSourceNumber1, oDetails.UseSourceNumber2, oDetails.SourceNumber1, oDetails.SourceNumber2, oDetails.DestinationNumber1, oDetails.DestinationNumber2, oDetails.IgnoreOutliers, oDetails.UseLogs, out dSourceCalculationNumber1, out dSourceCalculationNumber2, out iDecimalPlaces )); }
AutoFillByEdgeWeight ( Microsoft.Office.Interop.Excel.Workbook workbook, String edgeWeightColumnName, Boolean showVertexLabels, String vertexLabelColumnName ) { Debug.Assert(workbook != null); Debug.Assert(!String.IsNullOrEmpty(edgeWeightColumnName)); Debug.Assert(!showVertexLabels || !String.IsNullOrEmpty(vertexLabelColumnName)); ListObject oVertexTable = null; ListObject oEdgeTable = null; ExcelHiddenColumns oHiddenVertexColumns = null; ExcelHiddenColumns oHiddenEdgeColumns = null; AutoFillWorkbookWithSchemeResults oAutoFillWorkbookWithSchemeResults = new AutoFillWorkbookWithSchemeResults(); try { if ( !TryStartAutoFill(workbook, showVertexLabels, vertexLabelColumnName, out oEdgeTable, out oVertexTable, out oHiddenEdgeColumns, out oHiddenVertexColumns) || ExcelUtil.VisibleTableRangeIsEmpty(oEdgeTable) ) { return; } // Map the edge weight column to the edge width column. Double dSourceCalculationNumber1, dSourceCalculationNumber2; Int32 iDecimalPlaces; if (!TableColumnMapper.TryMapToNumericRange(oEdgeTable, edgeWeightColumnName, EdgeTableColumnNames.Width, false, false, 0, 0, MinimumEdgeWeightWidthWorkbook, MaximumEdgeWeightWidthWorkbook, false, false, out dSourceCalculationNumber1, out dSourceCalculationNumber2, out iDecimalPlaces )) { return; } // Fill in other columns with constants. String sBlack = (new ColorConverter2()).GraphToWorkbook( Color.FromArgb(0, 0, 0)); FillColumnsWithConstants( oEdgeTable, EdgeTableColumnNames.Color, sBlack, oEdgeTable, CommonTableColumnNames.Alpha, 0.6F * (AlphaConverter.MaximumAlphaWorkbook - AlphaConverter.MinimumAlphaWorkbook), oVertexTable, VertexTableColumnNames.Shape, (new VertexShapeConverter()).GraphToWorkbook( VertexShape.Circle), oVertexTable, VertexTableColumnNames.Color, sBlack, oVertexTable, VertexTableColumnNames.Radius, 3.0F, oVertexTable, CommonTableColumnNames.Alpha, AlphaConverter.MaximumAlphaWorkbook ); // Save the results. oAutoFillWorkbookWithSchemeResults.SetEdgeWeightResults( edgeWeightColumnName, dSourceCalculationNumber1, dSourceCalculationNumber2, iDecimalPlaces); } finally { (new PerWorkbookSettings(workbook)). AutoFillWorkbookWithSchemeResults = oAutoFillWorkbookWithSchemeResults; EndAutoFill(workbook, oEdgeTable, oVertexTable, oHiddenEdgeColumns, oHiddenVertexColumns); } }