Borders Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

A collection of four Border objects that represent the four borders of a Range or Style object.

public interface class Borders : System::Collections::IEnumerable

[System.Runtime.InteropServices.Guid("00020855-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Borders : System.Collections.IEnumerable

Public Interface Borders
Implements IEnumerable

Attributes: GuidAttribute InterfaceTypeAttribute

Implements: IEnumerable

Remarks

Use the Borders property of a Range or Style object to return the Borders collection, which contains all four borders.

Use Borders(index), where index identifies the border, to return a single Border object.

Index can be one of the following XlBordersIndex constants: xlDiagonalDown, xlDiagonalUp, xlEdgeBottom, xlEdgeLeft, xlEdgeRight, xlEdgeTop, xlInsideHorizontal, or xlInsideVertical.

Properties

_Default[XlBordersIndex]	Reserved for internal use.
Application	Returns an Application object that represents the Microsoft Excel application.
Color	Returns or sets the primary color of all four borders of a range. If they're not all the same color, returns 0 (zero).
ColorIndex	Returns or sets the color of all four borders. Returns Null if all four borders aren't the same color.
Count	Returns the number of objects in the collection.
Creator	Returns a 32-bit integer that indicates the application in which this object was created.
Item[XlBordersIndex]	Returns a Border object that represents one of the borders of either a range of cells or a style.
LineStyle	Returns or sets the line style for the border.
Parent	Returns the parent object for the specified object.
ThemeColor	Returns or sets the theme color in the applied color scheme that is associated with the specified object. Read/write Object.
TintAndShade	Returns or sets a Single that lightens or darkens a color.
Value	Returns or sets the line style for the border.
Weight	Returns or sets the weight of the border.

Methods

GetEnumerator()

Applies to

Share via