Udostępnij za pośrednictwem

XmlMappedRange.EntireColumn Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assembly:
Microsoft.Office.Tools.Excel.dll

Gets a Range that represents the entire column that contains the XmlMappedRange control.

public:
 property Microsoft::Office::Interop::Excel::Range ^ EntireColumn { Microsoft::Office::Interop::Excel::Range ^ get(); };
public Microsoft.Office.Interop.Excel.Range EntireColumn { get; }
member this.EntireColumn : Microsoft.Office.Interop.Excel.Range
Public ReadOnly Property EntireColumn As Range

Property Value

Range

A Range that represents the entire column that contains the XmlMappedRange control.

Examples

The following code example uses the EntireColumn and EntireRow properties to set the border color of the column and row that contain an XmlMappedRange to green. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

private void HighlightColumnAndRow()
{
    // Set the color of the column and row borders to the RGB value for green.
    this.CustomerLastNameCell.EntireColumn.Borders.Color = 0xFF00;
    this.CustomerLastNameCell.EntireRow.Borders.Color = 0xFF00;
}

Private Sub HighlightColumnAndRow()
    ' Set the color of the column and row borders to the 
    ' RGB value for green.
    Me.CustomerLastNameCell.EntireColumn.Borders.Color = &HFF00
    Me.CustomerLastNameCell.EntireRow.Borders.Color = &HFF00
End Sub

Applies to