asposecells.api

Classes

Constants

Class Cell

Encapsulates the object that represents a single Workbook cell.

Example:

excel = Workbook()
cells = excel.getWorksheets().get(0).getCells()

# Put a string into a cell
cell = cells.get(0, 0)
cell.putValue("Hello")
first = cell.getStringValue()
# Put an integer into a cell
cell = cells.get("B1")
cell.putValue(12)
second = cell.getIntValue()
# Put a double into a cell
cell = cells.get(0, 2)
cell.putValue(-1.234)
third = cell.getDoubleValue()
# Put a formula into a cell
cell = cells.get("D1")
cell.setFormula("=B1 + C1")
# Put a combined formula: "sum(average(b1,c1), b1)" to cell at b2
cell = cells.get("b2")
cell.setFormula("=sum(average(b1,c1), b1)")

# Set style of a cell
style = cell.getStyle()
# Set background color
style.setBackgroundColor(Color.getYellow())
# Set format of a cell
style.getFont().setName("Courier New")
style.setVerticalAlignment(TextAlignmentType.TOP)
cell.setStyle(style)

Property Getters/Setters Summary
`method`	`getBoolValue()`
	Gets the boolean value contained in the cell.
`method`	`getColumn()`
	Gets column number (zero based) of the cell.
`method`	`getComment()`
	Gets the comment of this cell.
`method`	`containsExternalLink()`
	Indicates whether this cell contains an external link. Only applies when the cell is a formula cell.
`method`	`getDateTimeValue()`
	Gets the DateTime value contained in the cell.
`method`	`getDisplayStringValue()`
	Gets the formatted string value of this cell by cell's display style.
`method`	`getDoubleValue()`
	Gets the double value contained in the cell.
`method`	`getEmbeddedImage()`
`method`	`setEmbeddedImage(value)`
	Gets and sets the embeddedn image in the cell.
`method`	`getFloatValue()`
	Gets the float value contained in the cell.
`method`	`getFormula()`
`method`	`setFormula(value)`
	Gets or sets a formula of the Cell.
`method`	`getFormulaLocal()`
`method`	`setFormulaLocal(value)`
	Get the locale formatted formula of the cell.
`method`	`hasCustomStyle()`
	Indicates whether this cell has custom style settings(different from the default one inherited from corresponding row, column, or workbook).
`method`	`getHtmlString()`
`method`	`setHtmlString(value)`
	Gets and sets the html string which contains data and some formats in this cell.
`method`	`getIntValue()`
	Gets the integer value contained in the cell.
`method`	`isArrayFormula()`
	Indicates whether the cell formula is an array formula.
`method`	`isArrayHeader()`
	Indicates the cell's formula is an array formula and it is the first cell of the array.
`method`	`isDynamicArrayFormula()`
	Indicates whether the cell's formula is dynamic array formula(true) or legacy array formula(false).
`method`	`isErrorValue()`
	Checks if the value of this cell is an error.
`method`	`isFormula()`
	Represents if the specified cell contains formula.
`method`	`isInArray()`
	Indicates whether the cell formula is an array formula.
`method`	`isInTable()`
	Indicates whether this cell is part of table formula.
`method`	`isMerged()`
	Checks if a cell is part of a merged range or not.
`method`	`isNumericValue()`
	Indicates whether the value of this cell is numeric(int, double and datetime)
`method`	`isSharedFormula()`
	Indicates whether the cell formula is part of shared formula.
`method`	`isStyleSet()`
	Indicates if the cell's style is set. If return false, it means this cell has a default cell format.
`method`	`isTableFormula()`
	Indicates whether this cell is part of table formula.
`method`	`getName()`
	Gets the name of the cell.
`method`	`getNumberCategoryType()`
	Represents the category type of this cell's number formatting. The value of the property is NumberCategoryType integer constant.
`method`	`getR1C1Formula()`
`method`	`setR1C1Formula(value)`
	Gets or sets a R1C1 formula of the Cell.
`method`	`getRow()`
	Gets row number (zero based) of the cell.
`method`	`getSharedStyleIndex()`
	Gets cell's shared style index in the style pool.
`method`	`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).
`method`	`getStringValueWithoutFormat()`
	Gets cell's value as string without any format.
`method`	`getType()`
	Represents cell value type. The value of the property is CellValueType integer constant.
`method`	`getValue()`
`method`	`setValue(value)`
	Gets/sets the value contained in this cell.
`method`	`getWorksheet()`
	Gets the parent worksheet.

Method Summary
`method`	`calculate(options)`
`method`	Calculates the formula of the cell.
`method`	`characters(startIndex, length)`
`method`	Returns a Characters object that represents a range of characters within the cell text.
`method`	`copy(cell)`
`method`	Copies data from a source cell.
`method`	`equals(cell)`
`method`	Checks whether this object refers to the same cell with another cell object.
`method`	`equals(obj)`
`method`	Checks whether this object refers to the same cell with another.
`method`	`getArrayRange()`
`method`	Gets the array range if the cell's formula is an array formula.
`method`	`getCharacters()`
`method`	Returns all Characters objects that represents a range of characters within the cell text.
`method`	`getCharacters(flag)`
`method`	Returns all Characters objects that represents a range of characters within the cell text.
`method`	`getConditionalFormattingResult()`
`method`	Get the result of the conditional formatting.
`method`	`getDependents(isAll)`
`method`	Get all cells whose formula references to this cell directly.
`method`	`getDependentsInCalculation(recursive)`
`method`	Gets all cells whose calculated result depends on this cell.
`method`	`getDisplayStyle()`
`method`	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().
`method`	`getDisplayStyle(includeMergedBorders)`
`method`	Gets the display style of the cell. If the cell is conditional formatted, the display style is not same as the cell.GetStyle().
`method`	`getFormatConditions()`
`method`	Gets format conditions which applies to this cell.
`method`	`getFormula(isR1C1, isLocal)`
`method`	Get the formula of this cell.
`method`	`getHeightOfValue()`
`method`	Gets the height of the value in unit of pixels.
`method`	`getHtmlString(html5)`
`method`	Gets the html string which contains data and some formats in this cell.
`method`	`getLeafs()`
`method`	Get all cells which reference to this cell directly and need to be updated when this cell is modified.
`method`	`getLeafs(recursive)`
`method`	Get all cells which will be updated when this cell is modified.
`method`	`getMergedRange()`
`method`	Returns a Range object which represents a merged range.
`method`	`getPrecedents()`
`method`	Gets all references appearing in this cell's formula.
`method`	`getPrecedentsInCalculation()`
`method`	Gets all precedents(reference to cells in current workbook) used by this cell's formula while calculating it.
`method`	`getStringValue(formatStrategy)`
`method`	Gets the string value by specific formatted strategy.
`method`	`getStyle()`
`method`	Gets the cell style.
`method`	`getStyle(checkBorders)`
`method`	If checkBorders is true, check whether other cells' borders will effect the style of this cell.
`method`	`getTable()`
`method`	Gets the table which contains this cell.
`method`	`getValidation()`
`method`	Gets the validation applied to this cell.
`method`	`getValidationValue()`
`method`	Gets the value of validation which applied to this cell.
`method`	`getWidthOfValue()`
`method`	Gets the width of the value in unit of pixels.
`method`	`hashCode()`
`method`	Serves as a hash function for a particular type.
`method`	`insertText(index, text)`
`method`	Insert some characters to the cell. If the cell is rich formatted, this method could keep the original formatting.
`method`	`isRichText()`
`method`	Indicates whether the string value of this cell is a rich formatted text.
`method`	`putValue(boolValue)`
`method`	Puts a boolean value into the cell.
`method`	`putValue(dateTime)`
`method`	Puts a DateTime value into the cell.
`method`	`putValue(doubleValue)`
`method`	Puts a double value into the cell.
`method`	`putValue(intValue)`
`method`	Puts an integer value into the cell.
`method`	`putValue(objectValue)`
`method`	Puts an object value into the cell.
`method`	`putValue(stringValue)`
`method`	Puts a string value into the cell.
`method`	`putValue(stringValue, isConverted)`
`method`	Puts a string value into the cell and converts the value to other data type if appropriate.
`method`	`putValue(stringValue, isConverted, setStyle)`
`method`	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.
`method`	`removeArrayFormula(leaveNormalFormula)`
`method`	Remove array formula.
`method`	`replace(placeHolder, newValue, options)`
`method`	Replace text of the cell with options.
`method`	`setArrayFormula(arrayFormula, rowNumber, columnNumber)`
`method`	Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in ms excel) to a range of cells.
`method`	`setArrayFormula(arrayFormula, rowNumber, columnNumber, isR1C1, isLocal)`
`method`	Sets an array formula to a range of cells.
`method`	`setArrayFormula(arrayFormula, rowNumber, columnNumber, options)`
`method`	Sets an array formula to a range of cells.
`method`	`setArrayFormula(arrayFormula, rowNumber, columnNumber, options, values)`
`method`	Sets an array formula to a range of cells.
`method`	`setCharacters(characters)`
`method`	Sets rich text format of the cell.
`method`	`setDynamicArrayFormula(arrayFormula, options, calculateValue)`
`method`	Sets dynamic array formula and make the formula spill into neighboring cells if possible.
`method`	`setDynamicArrayFormula(arrayFormula, options, values, calculateRange, calculateValue)`
`method`	Sets dynamic array formula and make the formula spill into neighboring cells if possible.
`method`	`setDynamicArrayFormula(arrayFormula, options, values, calculateRange, calculateValue, copts)`
`method`	Sets dynamic array formula and make the formula spill into neighboring cells if possible.
`method`	`setFormula(formula, isR1C1, isLocal, value)`
`method`	Set the formula and the value of the formula.
`method`	`setFormula(formula, options, value)`
`method`	Set the formula and the value(calculated result) of the formula.
`method`	`setFormula(formula, value)`
`method`	Set the formula and the value(calculated result) of the formula.
`method`	`setSharedFormula(sharedFormula, rowNumber, columnNumber)`
`method`	Sets shared formulas to a range of cells.
`method`	`setSharedFormula(sharedFormula, rowNumber, columnNumber, isR1C1, isLocal)`
`method`	Sets a formula to a range of cells.
`method`	`setSharedFormula(sharedFormula, rowNumber, columnNumber, options)`
`method`	Sets shared formulas to a range of cells.
`method`	`setSharedFormula(sharedFormula, rowNumber, columnNumber, options, values)`
`method`	Sets shared formulas to a range of cells.
`method`	`setStyle(style)`
`method`	Sets the cell style.
`method`	`setStyle(style, explicitFlag)`
`method`	Apply the changed property of style to the cell.
`method`	`setStyle(style, flag)`
`method`	Apply the cell style based on flags.
`method`	`setTableFormula(rowNumber, columnNumber, rowIndexOfInputCell, columnIndexOfInputCell, isRowInput, values)`
`method`	Create one-variable data table for given range starting from this cell.
`method`	`setTableFormula(rowNumber, columnNumber, rowIndexOfRowInputCell, columnIndexOfRowInputCell, rowIndexOfColumnInputCell, columnIndexOfColumnInputCell, values)`
`method`	Create two-variable data table for given range starting from this cell.
`method`	`setTableFormula(rowNumber, columnNumber, inputCell, isRowInput, values)`
`method`	Create one-variable data table for given range starting from this cell.
`method`	`setTableFormula(rowNumber, columnNumber, rowInputCell, columnInputCell, values)`
`method`	Create two-variable data table for given range starting from this cell.
`method`	`toJson()`
`method`	Convert Cell to JSON struct data.
`method`	`toString()`
`method`	Returns a string represents the current Cell object.

- Property Getters/Setters Detail
  - getWorksheet : Worksheet
```
Worksheet getWorksheet()
```
    Gets the parent worksheet.
  - getDateTimeValue : DateTime
```
DateTime getDateTimeValue()
```
    Gets the DateTime value contained in the cell.
  - getRow : int
```
int getRow()
```
    Gets row number (zero based) of the cell.
    Cell row number
  - getColumn : int
```
int getColumn()
```
    Gets column number (zero based) of the cell.
  - isFormula : boolean
```
boolean isFormula()
```
    Represents if the specified cell contains formula.
  - getType : int
```
int getType()
```
    Represents cell value type. The value of the property is CellValueType integer constant.
  - getName : String
```
String getName()
```
    Gets the name of the cell.
    A cell name includes its column letter and row number. For example, the name of a cell in row 0 and column 0 is A1.
  - isErrorValue : boolean
```
boolean isErrorValue()
```
    Checks if the value of this cell is an error.
    Also applies to formula cell to check whether the calculated result is an error.
  - isNumericValue : boolean
```
boolean isNumericValue()
```
    Indicates whether the value of this cell is numeric(int, double and datetime)
    Also applies to formula cell to check the calculated result
  - getStringValue : String
```
String 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).
  - getStringValueWithoutFormat : String
```
String getStringValueWithoutFormat()
```
    Gets cell's value as string without any format.
    NOTE: This method is now obsolete. Instead, User should get the value object and format it according to the value type and the specific requirement. This property will be removed 12 months later since December 2020. Aspose apologizes for any inconvenience you may have experienced.
  - getNumberCategoryType : int
```
int getNumberCategoryType()
```
    Represents the category type of this cell's number formatting. The value of the property is NumberCategoryType integer constant.
    When cell's formatting pattern is combined with conditional formatting patterns, then the returned type is corresponding to the part which is used for current value of this cell. For example, if the formatting pattern for this cell is "#,##0;(#,##0);"-";@", then when cell's value is numeric and not 0, the returned type is NumberCategoryType.NUMBER; When cell's value is 0 or not numeric value, the returned type is NumberCategoryType.TEXT.
  - getDisplayStringValue : String
```
String getDisplayStringValue()
```
    Gets the formatted string value of this cell by cell's display style.
  - getIntValue : int
```
int getIntValue()
```
    Gets the integer value contained in the cell.
  - getDoubleValue : float
```
float getDoubleValue()
```
    Gets the double value contained in the cell.
  - getFloatValue : float
```
float getFloatValue()
```
    Gets the float value contained in the cell.
  - getBoolValue : boolean
```
boolean getBoolValue()
```
    Gets the boolean value contained in the cell.
  - hasCustomStyle : boolean
```
boolean hasCustomStyle()
```
    Indicates whether this cell has custom style settings(different from the default one inherited from corresponding row, column, or workbook).
  - getSharedStyleIndex : int
```
int getSharedStyleIndex()
```
    Gets cell's shared style index in the style pool.
  - getFormula/setFormula : String
```
String getFormula() / setFormula(value)
```
    Gets or sets a formula of the Cell.
    A formula string always begins with an equal sign (=). And please always use comma(,) as parameters delimiter, such as "=SUM(A1, E1, H2)".
    Example:
    excel = Workbook() cells = excel.getWorksheets().get(0).getCells() cells.get("B6").setFormula("=SUM(B2:B5, E1) + sheet2!A1")
  - getFormulaLocal/setFormulaLocal : String
```
String getFormulaLocal() / setFormulaLocal(value)
```
    Get the locale formatted formula of the cell.
  - getR1C1Formula/setR1C1Formula : String
```
String getR1C1Formula() / setR1C1Formula(value)
```
    Gets or sets a R1C1 formula of the Cell.
  - containsExternalLink : boolean
```
boolean containsExternalLink()
```
    Indicates whether this cell contains an external link. Only applies when the cell is a formula cell.
  - isArrayHeader : boolean
```
boolean isArrayHeader()
```
    Indicates the cell's formula is an array formula and it is the first cell of the array.
  - isDynamicArrayFormula : boolean
```
boolean isDynamicArrayFormula()
```
    Indicates whether the cell's formula is dynamic array formula(true) or legacy array formula(false).
  - isArrayFormula : boolean
```
boolean isArrayFormula()
```
    Indicates whether the cell formula is an array formula.
  - isInArray : boolean
```
boolean isInArray()
```
    Indicates whether the cell formula is an array formula.
    NOTE: This class is now obsolete. Instead, please use Cell.IsArrayFormula to check whether the cell formula is an array formula. This property will be removed 12 months later since May 2018. Aspose apologizes for any inconvenience you may have experienced.
  - isSharedFormula : boolean
```
boolean isSharedFormula()
```
    Indicates whether the cell formula is part of shared formula.
  - isTableFormula : boolean
```
boolean isTableFormula()
```
    Indicates whether this cell is part of table formula.
  - isInTable : boolean
```
boolean isInTable()
```
    Indicates whether this cell is part of table formula.
    NOTE: This class is now obsolete. Instead, please use Cell.IsTableFormula to check whether the cell formula is part of table formula. This property will be removed 12 months later since May 2018. Aspose apologizes for any inconvenience you may have experienced.
  - getValue/setValue : Object
```
Object getValue() / setValue(value)
```
    Gets/sets the value contained in this cell.
    Possible type:
    null,
    Boolean,
    DateTime,
    Double,
    Integer
    String.
    For int value, it may be returned as an Integer object or a Double object. And there is no guarantee that the returned value will be kept as the same type of object always.
  - isStyleSet : boolean
```
boolean isStyleSet()
```
    Indicates if the cell's style is set. If return false, it means this cell has a default cell format.
  - isMerged : boolean
```
boolean isMerged()
```
    Checks if a cell is part of a merged range or not.
  - getComment : Comment
```
Comment getComment()
```
    Gets the comment of this cell.
    If there is no comment applies to the cell, returns null.
  - getHtmlString/setHtmlString : String
```
String getHtmlString() / setHtmlString(value)
```
    Gets and sets the html string which contains data and some formats in this cell.
  - getEmbeddedImage/setEmbeddedImage : byte[]
```
byte[] getEmbeddedImage() / setEmbeddedImage(value)
```
    Gets and sets the embeddedn image in the cell.
- Method Detail
  - setDynamicArrayFormula
```
CellArea setDynamicArrayFormula(arrayFormula, options, calculateValue)
```
    Sets dynamic array formula and make the formula spill into neighboring cells if possible.
    Parameters:
    arrayFormula: String - the formula expression
    options: FormulaParseOptions - options to parse formula. "Parse" option will be ignored and the formula will always be parsed immediately
    calculateValue: boolean - whether calculate this dynamic array formula for those cells in the spilled range.
    Returns:
    the range that the formula should spill into.
  - setDynamicArrayFormula
```
CellArea setDynamicArrayFormula(arrayFormula, options, values, calculateRange, calculateValue)
```
    Sets dynamic array formula and make the formula spill into neighboring cells if possible.
    Parameters:
    arrayFormula: String - the formula expression
    options: FormulaParseOptions - options to parse formula. "Parse" option will be ignored and the formula will always be parsed immediately
    values: Object[][] - values(calculated results) for those cells with given dynamic array formula
    calculateRange: boolean - Whether calculate the spilled range for this dynamic array formula. If the "values" parameter is not null and this flag is false, then the spilled range's height will be values.Length and width will be values[0].Length.
    calculateValue: boolean - whether calculate this dynamic array formula for those cells in the spilled range when "values" is null or corresponding item in "values" for one cell is null.
    Returns:
    the range that the formula should spill into.
  - setDynamicArrayFormula
```
CellArea setDynamicArrayFormula(arrayFormula, options, values, calculateRange, calculateValue, copts)
```
    Sets dynamic array formula and make the formula spill into neighboring cells if possible.
    Parameters:
    arrayFormula: String - the formula expression
    options: FormulaParseOptions - options to parse formula. "Parse" option will be ignored and the formula will always be parsed immediately
    values: Object[][] - values(calculated results) for those cells with given dynamic array formula
    calculateRange: boolean - Whether calculate the spilled range for this dynamic array formula. If the "values" parameter is not null and this flag is false, then the spilled range's height will be values.Length and width will be values[0].Length.
    calculateValue: boolean - whether calculate this dynamic array formula for those cells in the spilled range when "values" is null or corresponding item in "values" for one cell is null.
    copts: CalculationOptions - The options for calculating formula. Commonly, for performance consideration, the CalculationOptions.Recursive property should be false.
    Returns:
    the range that the formula should spill into.
  - setTableFormula
```
 setTableFormula(rowNumber, columnNumber, rowInputCell, columnInputCell, values)
```
    Create two-variable data table for given range starting from this cell.
    Parameters:
    rowNumber: int - Number of rows to populate the formula.
    columnNumber: int - Number of columns to populate the formula.
    rowInputCell: String - the row input cell
    columnInputCell: String - the column input cell
    values: Object[][] - values for cells in table formula range
  - setTableFormula
```
 setTableFormula(rowNumber, columnNumber, inputCell, isRowInput, values)
```
    Create one-variable data table for given range starting from this cell.
    Parameters:
    rowNumber: int - Number of rows to populate the formula.
    columnNumber: int - Number of columns to populate the formula.
    inputCell: String - the input cell
    isRowInput: boolean - Indicates whether the input cell is a row input cell(true) or a column input cell(false).
    values: Object[][] - values for cells in table formula range
  - setTableFormula
```
 setTableFormula(rowNumber, columnNumber, rowIndexOfRowInputCell, columnIndexOfRowInputCell, rowIndexOfColumnInputCell, columnIndexOfColumnInputCell, values)
```
    Create two-variable data table for given range starting from this cell.
    Parameters:
    rowNumber: int - Number of rows to populate the formula.
    columnNumber: int - Number of columns to populate the formula.
    rowIndexOfRowInputCell: int - row index of the row input cell
    columnIndexOfRowInputCell: int - column index of the row input cell
    rowIndexOfColumnInputCell: int - row index of the column input cell
    columnIndexOfColumnInputCell: int - column index of the column input cell
    values: Object[][] - values for cells in table formula range
  - setTableFormula
```
 setTableFormula(rowNumber, columnNumber, rowIndexOfInputCell, columnIndexOfInputCell, isRowInput, values)
```
    Create one-variable data table for given range starting from this cell.
    Parameters:
    rowNumber: int - Number of rows to populate the formula.
    columnNumber: int - Number of columns to populate the formula.
    rowIndexOfInputCell: int - row index of the input cell
    columnIndexOfInputCell: int - column index of the input cell
    isRowInput: boolean - Indicates whether the input cell is a row input cell(true) or a column input cell(false).
    values: Object[][] - values for cells in table formula range
  - removeArrayFormula
```
 removeArrayFormula(leaveNormalFormula)
```
    Remove array formula.
    Parameters:
    leaveNormalFormula: boolean - True represents converting the array formula to normal formula.
  - copy
```
 copy(cell)
```
    Copies data from a source cell.
    Parameters:
    cell: Cell - Source Cell object.
  - characters
```
FontSetting characters(startIndex, length)
```
    Returns a Characters object that represents a range of characters within the cell text.
    This method only works on cell with string value.
    Parameters:
    startIndex: int - The index of the start of the character.
    length: int - The number of characters.
    Returns:
    Characters object.
    Example:
    excel = Workbook() excel.getWorksheets().get(0).getCells().get("A1").putValue("Helloworld") excel.getWorksheets().get(0).getCells().get("A1").characters(5, 5).getFont().setBold(True) excel.getWorksheets().get(0).getCells().get("A1").characters(5, 5).getFont().setColor(Color.getBlue())
  - replace
```
 replace(placeHolder, newValue, options)
```
    Replace text of the cell with options.
    Parameters:
    placeHolder: String - Cell placeholder
    newValue: String - String value to replace
    options: ReplaceOptions - The replace options
  - insertText
```
 insertText(index, text)
```
    Insert some characters to the cell. If the cell is rich formatted, this method could keep the original formatting.
    Parameters:
    index: int - The index.
    text: String - Inserted text.
  - isRichText
```
boolean isRichText()
```
    Indicates whether the string value of this cell is a rich formatted text.
  - getCharacters
```
FontSetting[] getCharacters()
```
    Returns all Characters objects that represents a range of characters within the cell text.
    Returns:
    All Characters objects
  - getCharacters
```
FontSetting[] getCharacters(flag)
```
    Returns all Characters objects that represents a range of characters within the cell text.
    Parameters:
    flag: boolean - Indicates whether applying table style to the cell if the cell is in the table.
    Returns:
    All Characters objects
  - setCharacters
```
 setCharacters(characters)
```
    Sets rich text format of the cell.
    Parameters:
    characters: FontSetting[] - All Characters objects.
  - getMergedRange
```
Range getMergedRange()
```
    Returns a Range object which represents a merged range.
    Returns:
    Range object. Null if this cell is not merged.
  - getHtmlString
```
String getHtmlString(html5)
```
    Gets the html string which contains data and some formats in this cell.
    Parameters:
    html5: boolean - Indicates whether the value is compatible for html5
    Returns:
  - toString
```
String toString()
```
    Returns a string represents the current Cell object.
    Returns:
  - toJson
```
String toJson()
```
    Convert Cell to JSON struct data.
    Returns:
  - equals
```
boolean equals(obj)
```
    Checks whether this object refers to the same cell with another.
    Parameters:
    obj: Object - another object
    Returns:
    true if two objects refers to the same cell.
  - hashCode
```
int hashCode()
```
    Serves as a hash function for a particular type.
    Returns:
    A hash code for current Cell object.
  - equals
```
boolean equals(cell)
```
    Checks whether this object refers to the same cell with another cell object.
    Parameters:
    cell: Cell - another cell object
    Returns:
    true if two cell objects refers to the same cell.
  - getConditionalFormattingResult
```
ConditionalFormattingResult getConditionalFormattingResult()
```
    Get the result of the conditional formatting.
    Returns null if no conditional formatting is applied to this cell,
  - getValidation
```
Validation getValidation()
```
    Gets the validation applied to this cell.
    Returns:
  - getValidationValue
```
boolean getValidationValue()
```
    Gets the value of validation which applied to this cell.
    Returns:
  - getTable
```
ListObject getTable()
```
    Gets the table which contains this cell.
    Returns:
  - calculate
```
 calculate(options)
```
    Calculates the formula of the cell.
    Parameters:
    options: CalculationOptions - Options for calculation
  - putValue
```
 putValue(boolValue)
```
    Puts a boolean value into the cell.
    Parameters:
    boolValue: boolean -
  - putValue
```
 putValue(intValue)
```
    Puts an integer value into the cell.
    Parameters:
    intValue: int - Input value
  - putValue
```
 putValue(doubleValue)
```
    Puts a double value into the cell.
    Parameters:
    doubleValue: float - Input value
  - putValue
```
 putValue(stringValue, isConverted, 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.
    Parameters:
    stringValue: String - Input value
    isConverted: boolean - True: converted to other data type if appropriate.
    setStyle: boolean - True: set the number format to cell's style when converting to other data type
  - putValue
```
 putValue(stringValue, isConverted)
```
    Puts a string value into the cell and converts the value to other data type if appropriate.
    Parameters:
    stringValue: String - Input value
    isConverted: boolean - True: converted to other data type if appropriate.
  - putValue
```
 putValue(stringValue)
```
    Puts a string value into the cell.
    Parameters:
    stringValue: String - Input value
  - putValue
```
 putValue(dateTime)
```
    Puts a DateTime value into the cell.
    Setting a DateTime value for a cell dose not means the cell will be formatted as date time automatically. DateTime value was maintained as numeric value in the data model of both ms excel and Aspose.Cells. Whether the numeric value will be taken as the numeric value itself or date time depends on the number format applied on this cell. If this cell has not been formatted as date time, it will be displayed as a numeric value even though what you input is DateTime.
    Parameters:
    dateTime: DateTime - Input value
  - putValue
```
 putValue(objectValue)
```
    Puts an object value into the cell.
    Parameters:
    objectValue: Object - input value
  - getStringValue
```
String getStringValue(formatStrategy)
```
    Gets the string value by specific formatted strategy.
    Parameters:
    formatStrategy: int - A CellValueFormatStrategy value. The formatted strategy.
    Returns:
  - getWidthOfValue
```
int getWidthOfValue()
```
    Gets the width of the value in unit of pixels.
    Returns:
  - getHeightOfValue
```
int getHeightOfValue()
```
    Gets the height of the value in unit of pixels.
    Returns:
  - getDisplayStyle
```
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
```
Style getDisplayStyle(includeMergedBorders)
```
    Gets the display style of the cell. If the cell is conditional formatted, the display style is not same as the cell.GetStyle().
    Parameters:
    includeMergedBorders: boolean - Indicates whether checking borders of the merged cells.
  - getFormatConditions
```
FormatConditionCollection[] getFormatConditions()
```
    Gets format conditions which applies to this cell.
    Returns:
    Returns FormatConditionCollection object
  - getStyle
```
Style getStyle()
```
    Gets the cell style.
    To change the style of the cell, please call Cell.SetStyle() method after modifying the returned style object. This method is same with getStyle(boolean) with true value for the parameter.
    Returns:
    Style object.
  - getStyle
```
Style getStyle(checkBorders)
```
    If checkBorders is true, check whether other cells' borders will effect the style of this cell.
    Parameters:
    checkBorders: boolean - Check other cells' borders
    Returns:
    Style object.
  - setStyle
```
 setStyle(style)
```
    Sets the cell style.
    If the border settings are changed, the border of adjust cells will be updated too.
    Parameters:
    style: Style - The cell style.
  - setStyle
```
 setStyle(style, explicitFlag)
```
    Apply the changed property of style to the cell.
    Parameters:
    style: Style - The cell style.
    explicitFlag: boolean - True, only overwriting formatting which is explicitly set.
  - setStyle
```
 setStyle(style, flag)
```
    Apply the cell style based on flags.
    Parameters:
    style: Style - The cell style.
    flag: StyleFlag - The style flag.
  - setFormula
```
 setFormula(formula, value)
```
    Set the formula and the value(calculated result) of the formula.
    Parameters:
    formula: String - The formula.
    value: Object - The value(calculated result) of the formula.
  - getFormula
```
String getFormula(isR1C1, isLocal)
```
    Get the formula of this cell.
    Parameters:
    isR1C1: boolean - Whether the formula needs to be formatted as R1C1.
    isLocal: boolean - Whether the formula needs to be formatted by locale.
    Returns:
    the formula of this cell.
  - setFormula
```
 setFormula(formula, isR1C1, isLocal, value)
```
    Set the formula and the value of the formula.
    NOTE: This class is now obsolete. Instead, please use Cell.SetFormula(string,FormulaParseOptions,object). This property will be removed 12 months later since December 2019. Aspose apologizes for any inconvenience you may have experienced.
    Parameters:
    formula: String - The formula.
    isR1C1: boolean - Whether the formula is R1C1 formula.
    isLocal: boolean - Whether the formula is locale formatted.
    value: Object - The value of the formula.
  - setFormula
```
 setFormula(formula, options, value)
```
    Set the formula and the value(calculated result) of the formula.
    Parameters:
    formula: String - The formula.
    options: FormulaParseOptions - Options for parsing the formula.
    value: Object - The value(calculated result) of the formula.
  - setArrayFormula
```
 setArrayFormula(arrayFormula, rowNumber, columnNumber, isR1C1, isLocal)
```
    Sets an array formula to a range of cells.
    NOTE: This class is now obsolete. Instead, please use Cell.SetArrayFormula(string,int,int,FormulaParseOptions). This property will be removed 12 months later since December 2019. Aspose apologizes for any inconvenience you may have experienced.
    Parameters:
    arrayFormula: String - Array formula.
    rowNumber: int - Number of rows to populate result of the array formula.
    columnNumber: int - Number of columns to populate result of the array formula.
    isR1C1: boolean - whether the formula is R1C1 formula
    isLocal: boolean - whether the formula is locale formatted
  - setArrayFormula
```
 setArrayFormula(arrayFormula, rowNumber, columnNumber)
```
    Sets an array formula(legacy array formula entered via CTRL+SHIFT+ENTER in ms excel) to a range of cells.
    Parameters:
    arrayFormula: String - Array formula.
    rowNumber: int - Number of rows to populate result of the array formula.
    columnNumber: int - Number of columns to populate result of the array formula.
  - setArrayFormula
```
 setArrayFormula(arrayFormula, rowNumber, columnNumber, options)
```
    Sets an array formula to a range of cells.
    Parameters:
    arrayFormula: String - Array formula.
    rowNumber: int - Number of rows to populate result of the array formula.
    columnNumber: int - Number of columns to populate result of the array formula.
    options: FormulaParseOptions - Options for parsing the formula.
  - setArrayFormula
```
 setArrayFormula(arrayFormula, rowNumber, columnNumber, options, values)
```
    Sets an array formula to a range of cells.
    Parameters:
    arrayFormula: String - Array formula.
    rowNumber: int - Number of rows to populate result of the array formula.
    columnNumber: int - Number of columns to populate result of the array formula.
    options: FormulaParseOptions - Options for parsing the formula.
    values: Object[][] - values for those cells with given array formula
  - setSharedFormula
```
 setSharedFormula(sharedFormula, rowNumber, columnNumber, isR1C1, isLocal)
```
    Sets a formula to a range of cells.
    NOTE: This class is now obsolete. Instead, please use Cell.SetSharedFormula(string,int,int,FormulaParseOptions). This property will be removed 12 months later since December 2019. Aspose apologizes for any inconvenience you may have experienced.
    Parameters:
    sharedFormula: String - Shared formula.
    rowNumber: int - Number of rows to populate the formula.
    columnNumber: int - Number of columns to populate the formula.
    isR1C1: boolean - whether the formula is R1C1 formula
    isLocal: boolean - whether the formula is locale formatted
  - setSharedFormula
```
 setSharedFormula(sharedFormula, rowNumber, columnNumber)
```
    Sets shared formulas to a range of cells.
    Parameters:
    sharedFormula: String - Shared formula.
    rowNumber: int - Number of rows to populate the formula.
    columnNumber: int - Number of columns to populate the formula.
  - setSharedFormula
```
 setSharedFormula(sharedFormula, rowNumber, columnNumber, options)
```
    Sets shared formulas to a range of cells.
    Parameters:
    sharedFormula: String - Shared formula.
    rowNumber: int - Number of rows to populate the formula.
    columnNumber: int - Number of columns to populate the formula.
    options: FormulaParseOptions - Options for parsing the formula.
  - setSharedFormula
```
 setSharedFormula(sharedFormula, rowNumber, columnNumber, options, values)
```
    Sets shared formulas to a range of cells.
    Parameters:
    sharedFormula: String - Shared formula.
    rowNumber: int - Number of rows to populate the formula.
    columnNumber: int - Number of columns to populate the formula.
    options: FormulaParseOptions - Options for parsing the formula.
    values: Object[][] - values for those cells with given shared formula
  - getPrecedents
```
ReferredAreaCollection getPrecedents()
```
    Gets all references appearing in this cell's formula.
    Returns null if this is not a formula cell.
    All references appearing in this cell's formula will be returned no matter they are referenced or not while calculating. For example, although cell A2 in formula "=IF(TRUE,A1,A2)" is not used while calculating, it is still taken as the formula's precedents.
    To get those references which influence the calculation only, please use getPrecedentsInCalculation().
    Returns:
    Collection of all references appearing in this cell's formula.
    Example:
    workbook = Workbook() cells = workbook.getWorksheets().get(0).getCells() cells.get("A1").setFormula("= B1 + SUM(B1:B10) + [Book2.xlsx]Chart!B2") areas = cells.get("A1").getPrecedents() for i in range(0, areas.getCount()): area = areas.get(i) stringBuilder = "" if area.isExternalLink(): stringBuilder += "[" stringBuilder += str(area.getExternalFileName()) stringBuilder += "]" stringBuilder += str(area.getSheetName()) stringBuilder += "!" stringBuilder += str(CellsHelper.cellIndexToName(area.getStartRow(), area.getStartColumn())) if area.isArea(): stringBuilder += ":" stringBuilder += str(CellsHelper.cellIndexToName(area.getEndRow(), area.getEndColumn())) workbook.save("Book1.xlsx")
  - getDependents
```
Cell[] getDependents(isAll)
```
    Get all cells whose formula references to this cell directly.
    If one reference containing this cell appears in one cell's formula, that cell will be taken as the dependent of this cell, no matter the reference or this cell is used or not while calculating. For example, although cell A2 in formula "=IF(TRUE,A1,A2)" is not used while calculating, this formula is still be taken as A2's dependent.
    To get those formulas whose calculated results depend on this cell, please use getDependentsInCalculation(boolean).
    When tracing dependents for one cell, all formulas in the workbook or worksheet will be analized and checked. So it is a time consumed process. If user need to trace dependents for lots of cells, using this method will cause poor performance. For performance consideration, user should use getDependentsInCalculation(boolean) instead. Or, user may gather precedents map of all cells by getPrecedents() firstly, and then build the dependents map according to the precedents map.
    Parameters:
    isAll: boolean - Indicates whether check formulas in other worksheets
  - getPrecedentsInCalculation
```
Iterator getPrecedentsInCalculation()
```
    Gets all precedents(reference to cells in current workbook) used by this cell's formula while calculating it.
    This method can only work with the situation that FormulaSettings.EnableCalculationChain is true for the workbook and the workbook has been fully calculated. If this cell is not a formula or it does not reference to any other cells, null will be returned.
    Returns:
    Enumerator to enumerate all references(ReferredArea)
  - getDependentsInCalculation
```
Iterator getDependentsInCalculation(recursive)
```
    Gets all cells whose calculated result depends on this cell.
    To use this method, please make sure the workbook has been set with true value for FormulaSettings.EnableCalculationChain and has been fully calculated with this setting. If there is no formula reference to this cell, null will be returned.
    Parameters:
    recursive: boolean - Whether returns those dependents which do not reference to this cell directly but reference to other leafs of this cell
    Returns:
    Enumerator to enumerate all dependents(Cell objects)
  - getLeafs
```
Iterator getLeafs()
```
    Get all cells which reference to this cell directly and need to be updated when this cell is modified.
    NOTE: This class is now obsolete. Instead, please use Cell.GetDependentsInCalculation(bool) to get all dependents in calculation chain. This property will be removed 12 months later since May 2022. Aspose apologizes for any inconvenience you may have experienced.
    Returns:
    Enumerator to enumerate all dependents(Cell)
  - getLeafs
```
Iterator getLeafs(recursive)
```
    Get all cells which will be updated when this cell is modified.
    NOTE: This class is now obsolete. Instead, please use Cell.GetDependentsInCalculation(bool) to get all dependents in calculation chain. This property will be removed 12 months later since May 2022. Aspose apologizes for any inconvenience you may have experienced.
    Parameters:
    recursive: boolean - Whether returns those leafs that do not reference to this cell directly but reference to other leafs of this cell
    Returns:
    Enumerator to enumerate all dependents(Cell)
  - getArrayRange
```
CellArea getArrayRange()
```
    Gets the array range if the cell's formula is an array formula.
    Only applies when the cell's formula is an array formula
    Returns:
    The array range.

asposecells.api

Classes

Constants

Class Cell

Property Getters/Setters Detail

getWorksheet : Worksheet

getDateTimeValue : DateTime

getRow : int

getColumn : int

isFormula : boolean

getType : int

getName : String

isErrorValue : boolean

isNumericValue : boolean

getStringValue : String

getStringValueWithoutFormat : String

getNumberCategoryType : int

getDisplayStringValue : String

getIntValue : int

getDoubleValue : float

getFloatValue : float

getBoolValue : boolean

hasCustomStyle : boolean

getSharedStyleIndex : int

getFormula/setFormula : String

getFormulaLocal/setFormulaLocal : String

getR1C1Formula/setR1C1Formula : String

containsExternalLink : boolean

isArrayHeader : boolean

isDynamicArrayFormula : boolean

isArrayFormula : boolean

isInArray : boolean

isSharedFormula : boolean

isTableFormula : boolean

isInTable : boolean

getValue/setValue : Object

isStyleSet : boolean

isMerged : boolean

getComment : Comment

getHtmlString/setHtmlString : String

getEmbeddedImage/setEmbeddedImage : byte[]

Method Detail

setDynamicArrayFormula

setDynamicArrayFormula

setDynamicArrayFormula

setTableFormula

setTableFormula

setTableFormula

setTableFormula

removeArrayFormula

copy

characters

replace

insertText

isRichText

getCharacters

getCharacters

setCharacters

getMergedRange

getHtmlString

toString

toJson

equals

hashCode

equals

getConditionalFormattingResult

getValidation

getValidationValue

getTable

calculate

putValue

putValue

putValue

putValue

putValue

putValue

putValue

putValue

getStringValue

getWidthOfValue