CellFormat 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.

Represents the search criteria for the cell format.

public interface class CellFormat

[System.Runtime.InteropServices.Guid("00024450-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface CellFormat

Public Interface CellFormat

Attributes: GuidAttribute InterfaceTypeAttribute

Remarks

Use the FindFormat or ReplaceFormat properties of the Application object to return a CellFormat object.

You can use the Borders, Font, or Interior properties of the CellFormat object to define the search criteria for the cell format.

Properties

AddIndent	True if text is automatically indented when the text alignment in a cell is set to equal distribution either horizontally or vertically.
Application	Returns an Application object that represents the Microsoft Excel application.
Borders	Allows the user to set or return the search criteria based on the cell's border format.
Creator	Returns a 32-bit integer that indicates the application in which this object was created.
Font	Returns a Font object, allowing the user to set or return the search criteria based on the cell's font format.
FormulaHidden	True if the formula will be hidden when the worksheet is protected. Returns Null if the specified range contains some cells with FormulaHidden equal to True and some cells with FormulaHidden equal to False.
HorizontalAlignment	Returns or sets the horizontal alignment for the specified object.
IndentLevel	Returns or sets the indent level for the cell or range. Can be an integer from 0 to 15.
Interior	Returns an Interior object allowing the user to set or return the search criteria based on the cell's interior format.
Locked	True if the object is locked; False if the object can be modified when the sheet is protected. Returns Null if the specified range contains both locked and unlocked cells.
MergeCells	True if the range or style contains merged cells.
NumberFormat	Returns or sets the format code for the object. Returns Null if all cells in the specified range don't have the same number format.
NumberFormatLocal	Returns or sets the format code for the object as a string in the language of the user.
Orientation	The text orientation. Can be an integer value from –90 to 90 degrees.
Parent	Returns the parent object for the specified object.
ShrinkToFit	True if text automatically shrinks to fit in the available column width. Returns Null if this property isn’t set to the same value for all cells in the specified range.
VerticalAlignment	Returns or sets the vertical alignment of the specified object.
WrapText	True if Microsoft Excel wraps the text in the object. Returns Null if the specified range contains some cells that wrap text and other cells that don’t.

Methods

Clear()

Clears the criteria set in the FindFormat and ReplaceFormat properties.

Applies to

Condividi tramite