We recommend using Visual Studio 2017
This documentation is archived and is not being maintained.

NamedRange.Style Property

Gets or sets a Style that represents the style of the NamedRange control.

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

Object Style { get; set; }

Property Value

Type: System.Object
A Style that represents the style of the NamedRange control.

The following code example creates a new custom style that displays text vertically and then sets a NamedRange to use this style.

This example is for a document-level customization.


private void CreateStyle()
{
    Excel.Style verticalStyle = Globals.ThisWorkbook.Styles.Add(
        "Vertical Text", missing);
    verticalStyle.Orientation = Excel.XlOrientation.xlVertical;

    Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
        this.Controls.AddNamedRange(this.Range["A1", missing],
        "namedRange1");
    namedRange1.Style = verticalStyle;
    namedRange1.Value2 = "This text is vertical";
}


Show: