Cell Class
Contents
[
Hide
]Cell class
Encapsulates the object that represents a single Workbook cell.
type Cell struct {
ptr unsafe.Pointer
}
Constructors
| Method | Description |
|---|
Methods
| Method | Description |
|---|---|
| IsNull | Checks whether the implementation object is nullptr. |
| Calculate | Calculates the formula of the cell. |
| GetWorksheet | Gets the parent worksheet. |
| PutValue_Bool | Puts a boolean value into the cell. |
| PutValue_Int | Puts an integer value into the cell. |
| PutValue_Double | Puts a double value into the cell. |
| PutValue_String_Bool_Bool | Puts a value into the cell, if appropriate the value will be converted to other data type and cell’s number format will be reset. |
| PutValue_String_Bool | Puts a string value into the cell and converts the value to other data type if appropriate. |
| PutValue_String | Puts a string value into the cell. |
| PutValue_Date | Puts a DateTime value into the cell. |
| GetDateTimeValue | Gets the DateTime value contained in the cell. |
| PutValue_Object | Puts an object value into the cell. |
| GetRow | Gets row number (zero based) of the cell. |
| GetColumn | Gets column number (zero based) of the cell. |
| IsFormula | Represents if the specified cell contains formula. |
| GetType | Represents cell value type. |
| GetName | Gets the name of the cell. |
| IsErrorValue | Checks if the value of this cell is an error. |
| IsNumericValue | Indicates whether the value of this cell is numeric(int, double and datetime) |
| GetStringValue_CellValueFormatStrategy | Gets the string value by specific formatted strategy. |
| GetStringValue | Gets the string value contained in the cell. If the type of this cell is string, then return the string value itself.For other cell types, the formatted string value (formatted with the specified style of this cell) will be returned.The formatted cell value is same with what you can get from excel when copying a cell as text(such ascopying cell to text editor or exporting to csv). |
| GetNumberCategoryType | Represents the category type of this cell’s number formatting. |
| GetDisplayStringValue | Gets the formatted string value of this cell by cell’s display style. |
| GetIntValue | Gets the integer value contained in the cell. |
| GetDoubleValue | Gets the double value contained in the cell. |
| GetFloatValue | Gets the float value contained in the cell. |
| GetBoolValue | Gets the boolean value contained in the cell. |
| GetWidthOfValue | Gets the width of the value in unit of pixels. |
| GetHeightOfValue | Gets the height of the value in unit of pixels. |
| GetDisplayStyle | Gets the display style of the cell.If this cell is also affected by other settings such as conditional formatting, list objects, etc.,then the display style may be different from cell.GetStyle(). |
| GetDisplayStyle_Bool | Gets the display style of the cell.If the cell is conditional formatted, the display style is not same as the cell.GetStyle(). |
| GetStyle | Gets the cell style. |
| GetStyle_Bool | If checkBorders is true, check whether other cells’ borders will effect the style of this cell. |
| SetStyle_Style | Sets the cell style. |
| SetStyle_Style_Bool | Apply the changed property of style to the cell. |
| SetStyle_Style_StyleFlag | Apply the cell style based on flags. |
| GetHasCustomStyle | Indicates whether this cell has custom style settings(different from the default one inheritedfrom corresponding row, column, or workbook). |
| GetSharedStyleIndex | Gets cell’s shared style index in the style pool. |
| GetFormula | Gets or sets a formula of the |
| SetFormula_String | Gets or sets a formula of the |
| GetFormulaLocal | Get the locale formatted formula of the cell. |
| SetFormulaLocal | Get the locale formatted formula of the cell. |
| GetR1C1Formula | Gets or sets a R1C1 formula of the |
| SetR1C1Formula | Gets or sets a R1C1 formula of the |
| SetFormula_String_Object | Set the formula and the value(calculated result) of the formula. |
| SetFormula_String_FormulaParseOptions | Set the formula and the value(calculated result) of the formula. |
| GetFormula_Bool_Bool | Get the formula of this cell. |
| SetFormula_String_FormulaParseOptions_Object | Set the formula and the value(calculated result) of the formula. |
| SetArrayFormula_String_Int_Int | Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in ms excel) to a range of cells. |
| SetArrayFormula_String_Int_Int_FormulaParseOptions | Sets an array formula to a range of cells. |
| SetSharedFormula_String_Int_Int | Sets shared formulas to a range of cells. |
| SetSharedFormula_String_Int_Int_FormulaParseOptions | Sets shared formulas to a range of cells. |
| GetContainsExternalLink | Indicates whether this cell contains an external link.Only applies when the cell is a formula cell. |
| GetPrecedents | Gets all references appearing in this cell’s formula. |
| IsArrayHeader | Indicates the cell’s formula is an array formulaand it is the first cell of the array. |
| IsDynamicArrayFormula | Indicates whether the cell’s formula is dynamic array formula(true) or legacy array formula(false). |
| GetArrayRange | Gets the array range if the cell’s formula is an array formula. |
| IsArrayFormula | Indicates whether the cell formula is an array formula. |
| IsSharedFormula | Indicates whether the cell formula is part of shared formula. |
| IsTableFormula | Indicates whether this cell is part of table formula. |
| SetDynamicArrayFormula_String_FormulaParseOptions_Bool | Sets dynamic array formula and make the formula spill into neighboring cells if possible. |
| RemoveArrayFormula | Remove array formula. |
| Copy | Copies data from a source cell. |
| GetValue | Gets/sets the value contained in this cell. |
| SetValue | Gets/sets the value contained in this cell. |
| IsStyleSet | Indicates if the cell’s style is set. If return false, it means this cell has a default cell format. |
| Characters | Returns a Characters object that represents a range of characters within the cell text. |
| Replace | Replace text of the cell with options. |
| InsertText | Insert some characters to the cell.If the cell is rich formatted, this method could keep the original formatting. |
| IsRichText | Indicates whether the string value of this cell is a rich formatted text. |
| IsMerged | Checks if a cell is part of a merged range or not. |
| GetMergedRange | Returns a |
| GetComment | Gets the comment of this cell. |
| GetHtmlString | Gets and sets the html string which contains data and some formats in this cell. |
| SetHtmlString | Gets and sets the html string which contains data and some formats in this cell. |
| GetHtmlString_Bool | Gets the html string which contains data and some formats in this cell. |
| ToString | Returns a string represents the current Cell object. |
| ToJson | Convert |
| Equals_Object | Checks whether this object refers to the same cell with another. |
| GetHashCode | Serves as a hash function for a particular type. |
| Equals_Cell | Checks whether this object refers to the same cell with another cell object. |
| GetConditionalFormattingResult | Get the result of the conditional formatting. |
| GetValidation | Gets the validation applied to this cell. |
| GetValidationValue | Gets the value of validation which applied to this cell. |
| GetTable | Gets the table which contains this cell. |
| IsCheckBoxStyle | Indicates whether setting this cell as a check box. |
| SetIsCheckBoxStyle | Indicates whether setting this cell as a check box. |
| GetRichValue | Gets rich value of the cell. |
| Dispose |