Worksheet.Columns Property (2007 System)

Gets a Range object that represents one or more columns on the worksheet.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public ReadOnly Property Columns As Range
'Usage
Dim instance As Worksheet 
Dim value As Range 

value = instance.Columns
[BrowsableAttribute(false)]
public Range Columns { get; }
[BrowsableAttribute(false)]
public:
property Range^ Columns {
    Range^ get ();
}
public function get Columns () : Range

Property Value

Type: Range
A Range object that represents one or more columns on the worksheet.

Remarks

When used without parameters, this property returns a Range object that contains all the columns on the worksheet.

This property can be used with the following optional parameters to get specific columns on the worksheet. If you use this property with parameters, the return value is an object that must be cast to a Range.

Parameter

Description

RowIndex

The index of one or more columns to get.

To get a single column, pass one of the following objects to this parameter:

  • An integer that specifies the index of the column you want to get. The column indexes begin at 1.

  • A string that consists of the letter of the column you want to get.

To get multiple contiguous columns, pass a string with the format "first column letter:last column letter". For example, to get columns A through E, pass "A:E".

Note

The name of this parameter is misleading; this parameter specifies the indexes of the columns you want to get, not the rows.

ColumnIndex

Do not use this parameter. This property will throw a COMException if you try to pass a value to this parameter.

Examples

The following code example uses the Columns property to set the color, name, size, and boldness of the font of all the cells in the first column on the worksheet.

This example is for a document-level customization. To run this code, copy it into one of the worksheet classes in your project.

Private Sub SetFirstColumnFont()
    Dim fillColumn As Excel.Range = TryCast(Me.Columns("A"), Excel.Range)

    With fillColumn.Font
        ' Set the font color to blue (RGB value 00 00 FF), and set other font properties.
        .Color = &HFF0000
        .Name = "Arial"
        .Size = 14
        .Bold = False 
    End With 

    ' Test the changes by writing a value to all the column cells.
    fillColumn.Value2 = "This is a test" 
End Sub
private void SetFirstColumnFont()
{
    Excel.Range fillColumn = (Excel.Range)this.Columns["A", missing];
    Excel.Font columnsFont = fillColumn.Font;

    // Set the font color to blue (RGB value 00 00 FF), and set other font properties.
    columnsFont.Color = 0xFF0000;
    columnsFont.Name = "Arial";
    columnsFont.Size = 14;
    columnsFont.Bold = false;

    // Test the changes by writing a value to all the column cells.
    fillColumn.Value2 = "This is a test";
}

.NET Framework Security

See Also

Reference

Worksheet Class

Worksheet Members

Microsoft.Office.Tools.Excel Namespace

Change History

Date

History

Reason

February 2009

Added information and code example about accessing specific columns.

Customer feedback.