Aspose::Cells::Cell class
Contents
[
Hide
]Cell class
Encapsulates the object that represents a single Workbook cell.
class Cell
Methods
| Method | Description |
|---|---|
| Calculate(const CalculationOptions& options) | Calculates the formula of the cell. |
| Cell(Cell_Impl* impl) | Constructs from an implementation object. |
| Cell(const Cell& src) | Copy constructor. |
| Characters(int32_t startIndex, int32_t length) | Returns a Characters object that represents a range of characters within the cell text. |
| Copy(const Cell& cell) | Copies data from a source cell. |
| Dispose() | |
| Equals(const Aspose::Cells::Object& obj) | Checks whether this object refers to the same cell with another. |
| Equals(const Cell& cell) | Checks whether this object refers to the same cell with another cell object. |
| GetArrayRange() | Gets the array range if the cell’s formula is an array formula. |
| GetBoolValue() | Gets the boolean value contained in the cell. |
| GetCharacters() | Returns all Characters objects that represents a range of characters within the cell text. |
| GetCharacters(bool flag) | Returns all Characters objects that represents a range of characters within the cell text. |
| GetColumn() | Gets column number (zero based) of the cell. |
| GetComment() | Gets the comment of this cell. |
| GetConditionalFormattingResult() | Get the result of the conditional formatting. |
| GetContainsExternalLink() | Indicates whether this cell contains an external link. Only applies when the cell is a formula cell. |
| GetDateTimeValue() | Gets the DateTime value contained in the cell. |
| GetDependents(bool isAll) | Get all cells whose formula references to this cell directly. |
| GetDependentsInCalculation(bool recursive) | Gets all cells whose calculated result depends on this cell. |
| GetDisplayStringValue() | Gets the formatted string value of this cell by cell’s display style. |
| 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 includeMergedBorders) | Gets the display style of the cell. If the cell is conditional formatted, the display style is not same as the cell.GetStyle(). |
| GetDoubleValue() | Gets the double value contained in the cell. |
| GetEmbeddedImage() | Gets and sets the embeddedn image in the cell. |
| GetFloatValue() | Gets the float value contained in the cell. |
| GetFormatConditions() | Gets format conditions which applies to this cell. |
| GetFormula() | Gets or sets a formula of the Cell. |
| GetFormula(bool isR1C1, bool isLocal) | Get the formula of this cell. |
| GetFormulaLocal() | Get the locale formatted formula of the cell. |
| GetHasCustomStyle() | Indicates whether this cell has custom style settings(different from the default one inherited from corresponding row, column, or workbook). |
| GetHashCode() | Serves as a hash function for a particular type. |
| GetHeightOfValue() | Gets the height of the value in unit of pixels. |
| GetHtmlString() | Gets and sets the html string which contains data and some formats in this cell. |
| GetHtmlString(bool html5) | Gets the html string which contains data and some formats in this cell. |
| GetIntValue() | Gets the integer value contained in the cell. |
| GetMergedRange() | Returns a Range object which represents a merged range. |
| GetName() | Gets the name of the cell. |
| GetNumberCategoryType() | Represents the category type of this cell’s number formatting. |
| GetPrecedents() | Gets all references appearing in this cell’s formula. |
| GetPrecedentsInCalculation() | Gets all precedents(reference to cells in current workbook) used by this cell’s formula while calculating it. |
| GetR1C1Formula() | Gets or sets a R1C1 formula of the Cell. |
| GetRichValue() | Gets rich value of the cell. |
| GetRow() | Gets row number (zero based) of the cell. |
| GetSharedStyleIndex() | Gets cell’s shared style index in the style pool. |
| GetStringValue(CellValueFormatStrategy formatStrategy) | 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 as copying cell to text editor or exporting to csv). |
| GetStyle() | Gets the cell style. |
| GetStyle(bool checkBorders) | If checkBorders is true, check whether other cells’ borders will effect the style of this cell. |
| GetTable() | Gets the table which contains this cell. |
| GetType() | Represents cell value type. |
| GetValidation() | Gets the validation applied to this cell. |
| GetValidationValue() | Gets the value of validation which applied to this cell. |
| GetValue() | Gets/sets the value contained in this cell. |
| GetWidthOfValue() | Gets the width of the value in unit of pixels. |
| GetWorksheet() | Gets the parent worksheet. |
| InsertText(int32_t index, const U16String& text) | Insert some characters to the cell. If the cell is rich formatted, this method could keep the original formatting. |
| InsertText(int32_t index, const char16_t* text) | Insert some characters to the cell. If the cell is rich formatted, this method could keep the original formatting. |
| IsArrayFormula() | Indicates whether the cell formula is an array formula. |
| IsArrayHeader() | Indicates the cell’s formula is an array formula and it is the first cell of the array. |
| IsCheckBoxStyle() | Indicates whether setting this cell as a check box. |
| IsDynamicArrayFormula() | Indicates whether the cell’s formula is dynamic array formula(true) or legacy array formula(false). |
| IsErrorValue() | Checks if the value of this cell is an error. |
| IsFormula() | Represents if the specified cell contains formula. |
| IsMerged() | Checks if a cell is part of a merged range or not. |
| IsNull() const | Checks whether the implementation object is nullptr. |
| IsNumericValue() | Indicates whether the value of this cell is numeric(int, double and datetime) |
| IsRichText() | Indicates whether the string value of this cell is a rich formatted text. |
| IsSharedFormula() | Indicates whether the cell formula is part of shared formula. |
| IsStyleSet() | Indicates if the cell’s style is set. If return false, it means this cell has a default cell format. |
| IsTableFormula() | Indicates whether this cell is part of table formula. |
| explicit operator bool() const | operator bool() |
| operator=(const Cell& src) | operator= |
| PutValue(bool boolValue) | Puts a boolean value into the cell. |
| PutValue(int32_t intValue) | Puts an integer value into the cell. |
| PutValue(double doubleValue) | Puts a double value into the cell. |
| PutValue(const U16String& stringValue, bool isConverted, bool setStyle) | 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(const char16_t* stringValue, bool isConverted, bool setStyle) | 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(const U16String& stringValue, bool isConverted) | Puts a string value into the cell and converts the value to other data type if appropriate. |
| PutValue(const char16_t* stringValue, bool isConverted) | Puts a string value into the cell and converts the value to other data type if appropriate. |
| PutValue(const U16String& stringValue) | Puts a string value into the cell. |
| PutValue(const char16_t* stringValue) | Puts a string value into the cell. |
| PutValue(const Date& dateTime) | Puts a DateTime value into the cell. |
| PutValue(const Aspose::Cells::Object& objectValue) | Puts an object value into the cell. |
| RemoveArrayFormula(bool leaveNormalFormula) | Remove array formula. |
| Replace(const U16String& placeHolder, const U16String& newValue, const ReplaceOptions& options) | Replace text of the cell with options. |
| Replace(const char16_t* placeHolder, const char16_t* newValue, const ReplaceOptions& options) | Replace text of the cell with options. |
| SetArrayFormula(const U16String& arrayFormula, int32_t rowNumber, int32_t columnNumber) | Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in ms excel) to a range of cells. |
| SetArrayFormula(const char16_t* arrayFormula, int32_t rowNumber, int32_t columnNumber) | Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in ms excel) to a range of cells. |
| SetArrayFormula(const U16String& arrayFormula, int32_t rowNumber, int32_t columnNumber, const FormulaParseOptions& options) | Sets an array formula to a range of cells. |
| SetArrayFormula(const char16_t* arrayFormula, int32_t rowNumber, int32_t columnNumber, const FormulaParseOptions& options) | Sets an array formula to a range of cells. |
| SetArrayFormula(const U16String& arrayFormula, int32_t rowNumber, int32_t columnNumber, const FormulaParseOptions& options, const Vector <Vector <Aspose::Cells::Object>>& values) | Sets an array formula to a range of cells. |
| SetArrayFormula(const char16_t* arrayFormula, int32_t rowNumber, int32_t columnNumber, const FormulaParseOptions& options, const Vector <Vector <Aspose::Cells::Object>>& values) | Sets an array formula to a range of cells. |
| SetCharacters(const Vector <FontSetting>& characters) | Sets rich text format of the cell. |
| SetDynamicArrayFormula(const U16String& arrayFormula, const FormulaParseOptions& options, bool calculateValue) | Sets dynamic array formula and make the formula spill into neighboring cells if possible. |
| SetDynamicArrayFormula(const char16_t* arrayFormula, const FormulaParseOptions& options, bool calculateValue) | Sets dynamic array formula and make the formula spill into neighboring cells if possible. |
| SetDynamicArrayFormula(const U16String& arrayFormula, const FormulaParseOptions& options, const Vector <Vector <Aspose::Cells::Object>>& values, bool calculateRange, bool calculateValue) | Sets dynamic array formula and make the formula spill into neighboring cells if possible. |
| SetDynamicArrayFormula(const char16_t* arrayFormula, const FormulaParseOptions& options, const Vector <Vector <Aspose::Cells::Object>>& values, bool calculateRange, bool calculateValue) | Sets dynamic array formula and make the formula spill into neighboring cells if possible. |
| SetDynamicArrayFormula(const U16String& arrayFormula, const FormulaParseOptions& options, const Vector <Vector <Aspose::Cells::Object>>& values, bool calculateRange, bool calculateValue, const CalculationOptions& copts) | Sets dynamic array formula and make the formula spill into neighboring cells if possible. |
| SetDynamicArrayFormula(const char16_t* arrayFormula, const FormulaParseOptions& options, const Vector <Vector <Aspose::Cells::Object>>& values, bool calculateRange, bool calculateValue, const CalculationOptions& copts) | Sets dynamic array formula and make the formula spill into neighboring cells if possible. |
| SetEmbeddedImage(const Vector <uint8_t>& value) | Gets and sets the embeddedn image in the cell. |
| SetFormula(const U16String& value) | Gets or sets a formula of the Cell. |
| SetFormula(const char16_t* value) | Gets or sets a formula of the Cell. |
| SetFormula(const U16String& formula, const Aspose::Cells::Object& value) | Set the formula and the value(calculated result) of the formula. |
| SetFormula(const char16_t* formula, const Aspose::Cells::Object& value) | Set the formula and the value(calculated result) of the formula. |
| SetFormula(const U16String& formula, const FormulaParseOptions& options) | Set the formula and the value(calculated result) of the formula. |
| SetFormula(const char16_t* formula, const FormulaParseOptions& options) | Set the formula and the value(calculated result) of the formula. |
| SetFormula(const U16String& formula, const FormulaParseOptions& options, const Aspose::Cells::Object& value) | Set the formula and the value(calculated result) of the formula. |
| SetFormula(const char16_t* formula, const FormulaParseOptions& options, const Aspose::Cells::Object& value) | Set the formula and the value(calculated result) of the formula. |
| SetFormulaLocal(const U16String& value) | Get the locale formatted formula of the cell. |
| SetFormulaLocal(const char16_t* value) | Get the locale formatted formula of the cell. |
| SetHtmlString(const U16String& value) | Gets and sets the html string which contains data and some formats in this cell. |
| SetHtmlString(const char16_t* value) | Gets and sets the html string which contains data and some formats in this cell. |
| SetIsCheckBoxStyle(bool value) | Indicates whether setting this cell as a check box. |
| SetR1C1Formula(const U16String& value) | Gets or sets a R1C1 formula of the Cell. |
| SetR1C1Formula(const char16_t* value) | Gets or sets a R1C1 formula of the Cell. |
| SetSharedFormula(const U16String& sharedFormula, int32_t rowNumber, int32_t columnNumber) | Sets shared formulas to a range of cells. |
| SetSharedFormula(const char16_t* sharedFormula, int32_t rowNumber, int32_t columnNumber) | Sets shared formulas to a range of cells. |
| SetSharedFormula(const U16String& sharedFormula, int32_t rowNumber, int32_t columnNumber, const FormulaParseOptions& options) | Sets shared formulas to a range of cells. |
| SetSharedFormula(const char16_t* sharedFormula, int32_t rowNumber, int32_t columnNumber, const FormulaParseOptions& options) | Sets shared formulas to a range of cells. |
| SetSharedFormula(const U16String& sharedFormula, int32_t rowNumber, int32_t columnNumber, const FormulaParseOptions& options, const Vector <Vector <Aspose::Cells::Object>>& values) | Sets shared formulas to a range of cells. |
| SetSharedFormula(const char16_t* sharedFormula, int32_t rowNumber, int32_t columnNumber, const FormulaParseOptions& options, const Vector <Vector <Aspose::Cells::Object>>& values) | Sets shared formulas to a range of cells. |
| SetStyle(const Style& style) | Sets the cell style. |
| SetStyle(const Style& style, bool explicitFlag) | Apply the changed property of style to the cell. |
| SetStyle(const Style& style, const StyleFlag& flag) | Apply the cell style based on flags. |
| SetTableFormula(int32_t rowNumber, int32_t columnNumber, const U16String& rowInputCell, const U16String& columnInputCell, const Vector <Vector <Aspose::Cells::Object>>& values) | Create two-variable data table for given range starting from this cell. |
| SetTableFormula(int32_t rowNumber, int32_t columnNumber, const char16_t* rowInputCell, const char16_t* columnInputCell, const Vector <Vector <Aspose::Cells::Object>>& values) | Create two-variable data table for given range starting from this cell. |
| SetTableFormula(int32_t rowNumber, int32_t columnNumber, const U16String& inputCell, bool isRowInput, const Vector <Vector <Aspose::Cells::Object>>& values) | Create one-variable data table for given range starting from this cell. |
| SetTableFormula(int32_t rowNumber, int32_t columnNumber, const char16_t* inputCell, bool isRowInput, const Vector <Vector <Aspose::Cells::Object>>& values) | Create one-variable data table for given range starting from this cell. |
| SetTableFormula(int32_t rowNumber, int32_t columnNumber, int32_t rowIndexOfRowInputCell, int32_t columnIndexOfRowInputCell, int32_t rowIndexOfColumnInputCell, int32_t columnIndexOfColumnInputCell, const Vector <Vector <Aspose::Cells::Object>>& values) | Create two-variable data table for given range starting from this cell. |
| SetTableFormula(int32_t rowNumber, int32_t columnNumber, int32_t rowIndexOfInputCell, int32_t columnIndexOfInputCell, bool isRowInput, const Vector <Vector <Aspose::Cells::Object>>& values) | Create one-variable data table for given range starting from this cell. |
| SetValue(const Aspose::Cells::Object& value) | Gets/sets the value contained in this cell. |
| ToJson() | Convert Cell to JSON struct data. |
| ToString() | Returns a string represents the current Cell object. |
| ~Cell() | Destructor. |
Fields
| Field | Description |
|---|---|
| _impl | The implementation object. |
Examples
Aspose::Cells::Startup();
Workbook excel;
Cells cells = excel.GetWorksheets().Get(0).GetCells();
//Put a string into a cell
Cell cell = cells.Get(0, 0);
cell.PutValue(u"Hello");
U16String first = cell.GetStringValue();
//Put an integer into a cell
cell = cells.Get(u"B1");
cell.PutValue(12);
int second = cell.GetIntValue();
//Put a double into a cell
cell = cells.Get(0, 2);
cell.PutValue(-1.234);
double third = cell.GetDoubleValue();
//Put a formula into a cell
cell = cells.Get(u"D1");
cell.SetFormula(u"=B1 + C1");
//Put a combined formula: "sum(average(b1,c1), b1)" to cell at b2
cell = cells.Get(u"b2");
cell.SetFormula(u"=sum(average(b1,c1), b1)");
//Set style of a cell
Style style = cell.GetStyle();
//Set background color
style.SetBackgroundColor(Color{ 0xff, 0xff, 0xff, 0 });
//Set format of a cell
style.GetFont().SetName(u"Courier New");
style.SetVerticalAlignment(TextAlignmentType::Top);
cell.SetStyle(style);
Aspose::Cells::Cleanup();
See Also
- Namespace Aspose::Cells
- Library Aspose.Cells for C++