XlCellFormatting Members
Represents the object that specifies cell format characteristics.Constructors
| Name | Description |
|---|---|
| XlCellFormatting() | Initializes a new instance of the XlCellFormatting class with the default settings. |
Properties
| Name | Description |
|---|---|
| Alignment | Gets or sets alignment options to be applied to the cell content. Inherited from XlFormatting. |
| Bad static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Bad MS Excel style. |
| Border | Gets or sets border settings to be applied to a cell. Inherited from XlFormatting. |
| Calculation static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Calculation MS Excel style. |
| CheckCell static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Check Cell MS Excel style. |
| Explanatory static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Explanatory… MS Excel style. |
| Fill | Gets or sets fill settings to be applied to the cell background. Inherited from XlFormatting. |
| Font | Gets or sets font settings to be applied to the cell content. Inherited from XlFormatting. |
| Good static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Good MS Excel style. |
| Heading1 static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Heading 1 MS Excel style. |
| Heading2 static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Heading 2 MS Excel style. |
| Heading3 static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Heading 3 MS Excel style. |
| Heading4 static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Heading 4 MS Excel style. |
| Hyperlink static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Hyperlink MS Excel style. |
| Input static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Input MS Excel style. |
| IsDateTimeFormatString | Gets or sets a value indicating whether the format string assigned to the XlFormatting.NetFormatString property is a date and time format string. Inherited from XlFormatting. |
| LinkedCell static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Linked Cell MS Excel style. |
| NetFormatString | Gets or sets the .NET-style format string that specifies how a numeric value should be displayed in a cell. Inherited from XlFormatting. |
| Neutral static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Neutral MS Excel style. |
| Note static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Note MS Excel style. |
| NumberFormat | Gets or sets an MS Excel-style number format that specifies how a numeric value should be displayed in a cell. Inherited from XlFormatting. |
| Output static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Output MS Excel style. |
| Title static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Title MS Excel style. |
| Total static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Total MS Excel style. |
| WarningText static | Returns the XlCellFormatting object that provides format characteristics corresponding to the Warning Text MS Excel style. |
Methods
| Name | Description |
|---|---|
| Clone() | Creates a copy of the current XlCellFormatting object. |
| CopyFrom(XlCellFormatting) | Copies the appropriate properties of the specified object into the current instance of the XlCellFormatting class. |
| CopyObject<T>(T) static | This member supports the internal infrastructure and is not intended to be used directly from your code. Inherited from XlFormatting. |
| Equals(XlCellFormatting, XlCellFormatting) static | Determines whether the specified instances of the XlCellFormatting class are considered equal. |
| Equals(Object, Object) static | Determines whether the specified object instances are considered equal. Inherited from Object. |
| Equals(Object) | Determines whether the specified object is equal to the current object. Inherited from Object. |
| FromNetFormat(String, Boolean) static | Specifies a number format for cell values based on the given .NET-style format string. |
| GetHashCode() | Serves as the default hash function. Inherited from Object. |
| GetType() | Gets the Type of the current instance. Inherited from Object. |
| MemberwiseClone() protected | Creates a shallow copy of the current Object. Inherited from Object. |
| Merge(XlCellFormatting, XlCellFormatting) static | Combines formatting settings of the target and source instances of the XlCellFormatting class. |
| MergeWith(XlCellFormatting) | Combines the format settings of the specified XlCellFormatting object with the current instance of the XlCellFormatting class. |
| MergeWith(XlDifferentialFormatting) | Combines the format settings of the specified XlDifferentialFormatting object with the current instance of the XlCellFormatting class. |
| ReferenceEquals(Object, Object) static | Determines whether the specified Object instances are the same instance. Inherited from Object. |
| Themed(XlThemeColor, Double) static | Creates the XlCellFormatting object that specifies themed formatting for a cell. |
| ToDifferentialFormatting() |
This member supports the internal infrastructure and is not intended to be used directly from your code. Converts the current cell format to the differential formatting object. |
| ToString() | Returns a string that represents the current object. Inherited from Object. |
See Also