C# Range.get_Offset方法代码示例

//.........这里部分代码省略.........
            String [] asVertexAttributes,
            ListObject oVertexTable,
            Range oVertexNameColumnData,
            Range oVisibilityColumnData
            )
        {
            Debug.Assert(oSourceGraph != null);
            Debug.Assert(oVertexTable != null);
            Debug.Assert(oVertexNameColumnData != null);
            Debug.Assert(oVisibilityColumnData != null);
            AssertValid();

            // Create a dictionary that maps vertex names to row numbers in the
            // vertex worksheet.

            Dictionary<String, Int32> oVertexDictionary =
            new Dictionary<String, Int32>();

            Object [,] aoVertexNameValues =
            ExcelUtil.GetRangeValues(oVertexNameColumnData);

            Int32 iRows = oVertexNameColumnData.Rows.Count;

            if (iRows == 1 && aoVertexNameValues[1, 1] == null)
            {
            // Range.get_Value() (and therefore ExcelUtil.GetRangeValues())
            // returns a single null cell when the table is empty.  Work around
            // this.

            iRows = 0;
            }

            for (Int32 iRowOneBased = 1; iRowOneBased <= iRows; iRowOneBased++)
            {
            String sVertexName;

            if ( ExcelUtil.TryGetNonEmptyStringFromCell(aoVertexNameValues,
                iRowOneBased, 1, out sVertexName) )
            {
                oVertexDictionary[sVertexName] = iRowOneBased;
            }
            }

            aoVertexNameValues = null;

            // Create a list of vertices not already included in the vertex table.
            // This can occur when the graph has isolated vertices.

            List<String> oIsolatedVertexNames = new List<String>();

            foreach (IVertex oVertex in oSourceGraph.Vertices)
            {
            String sVertexName = oVertex.Name;

            if ( !oVertexDictionary.ContainsKey(sVertexName) )
            {
                oIsolatedVertexNames.Add(sVertexName);
            }
            }

            Int32 iIsolatedVertices = oIsolatedVertexNames.Count;

            if (iIsolatedVertices > 0)
            {
            // Append the isolated vertices to the table.  The vertex
            // visibilities should be set to Show to force them to be shown
            // even though they are not included in edges.

            String [,] asAddedVertexNameValues =
                new String [iIsolatedVertices, 1];

            String [,] asAddedVisibilityValues =
                new String [iIsolatedVertices, 1];

            String sShow = ( new VertexVisibilityConverter() ).GraphToWorkbook(
                VertexWorksheetReader.Visibility.Show);

            for (Int32 i = 0; i < iIsolatedVertices; i++)
            {
                String sIsolatedVertexName = oIsolatedVertexNames[i];
                asAddedVertexNameValues[i, 0] = sIsolatedVertexName;
                asAddedVisibilityValues[i, 0] = sShow;
                oVertexDictionary[sIsolatedVertexName] = iRows + i + 1;
            }

            ExcelUtil.SetRangeValues(
                oVertexNameColumnData.get_Offset(iRows, 0),
                asAddedVertexNameValues);

            ExcelUtil.SetRangeValues(
                oVisibilityColumnData.get_Offset(iRows, 0),
                asAddedVisibilityValues);
            }

            if (asVertexAttributes != null)
            {
            ImportVertexAttributes(oSourceGraph, asVertexAttributes,
                oVertexDictionary, oVertexTable);
            }
        }

        //*************************************************************************
        //  Method: GetParallelSubrange()
        //
        /// <summary>
        /// Given a subrange in one column, returns a subrange in a second column
        /// with the same start and end rows.
        /// </summary>
        ///
        /// <param name="column1Subrange">
        /// The subrange in one column.
        /// </param>
        ///
        /// <param name="column2NumberOneBased">
        /// The one-based column number of the second column.
        /// </param>
        ///
        /// <returns>
        /// The range in <paramref name="column2NumberOneBased" /> that has the
        /// same start and end rows as <paramref name="column1Subrange" />.
        /// </returns>
        //*************************************************************************
        public static Range GetParallelSubrange(
            Range column1Subrange,
            Int32 column2NumberOneBased
            )
        {
            Debug.Assert(column1Subrange != null);
            Debug.Assert(column2NumberOneBased >= 1);

            Int32 iColumn1NumberOneBased = column1Subrange.Column;

            Range oColumn2Subrange = column1Subrange.get_Offset(
            Missing.Value, column2NumberOneBased - iColumn1NumberOneBased);

            return (oColumn2Subrange);
        }

        OffsetRange
        (
            ref Range range,
            Int32 rowOffset,
            Int32 columnOffset
        )
        {
            Debug.Assert(range != null);

            range = range.get_Offset(rowOffset, columnOffset);
        }

        //*************************************************************************
        //  Method: RemoveSourceColumnHeader()
        //
        /// <summary>
        /// Removes the header from one of the source columns.
        /// </summary>
        ///
        /// <param name="oSourceColumn">
        /// The source column to remove the header from.
        /// </param>
        //*************************************************************************
        protected void RemoveSourceColumnHeader(
            ref Range oSourceColumn
            )
        {
            AssertValid();

            Int32 iRows = oSourceColumn.Rows.Count;

            if (iRows == 1)
            {
            OnInvalidSourceWorkbook(
                "There are no edges to import.",
                oSourceColumn.Worksheet, 1, 1
                );
            }

            // Trim the last row of the range, then shift the range down one row.

            oSourceColumn = oSourceColumn.get_Resize(iRows - 1, 1);
            oSourceColumn = oSourceColumn.get_Offset(1, 0);
        }