java.lang.Object
com.aspose.cells.Cell
public class Cell
- extends java.lang.Object
Encapsulates the object that represents a single Workbook cell.
Example:
Workbook excel = new Workbook();
Cells cells = excel.getWorksheets().get(0).getCells();
//Put a string into a cell
Cell cell = cells.get(0, 0);
cell.putValue("Hello");
String first = cell.getStringValue();
//Put an integer into a cell
cell = cells.get("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("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 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 |
boolean | getBoolValue() | |
|
Gets the boolean value contained in the cell.
|
int | getColumn() | |
|
Gets column number (zero based) of the cell.
|
boolean | containsExternalLink() | |
|
Indicates whether this cell contains an external link.
Only applies when the cell is a formula cell.
|
DateTime | getDateTimeValue() | |
|
Gets the DateTime value contained in the cell.
|
java.lang.String | getDisplayStringValue() | |
|
Gets the formatted string value of this cell.
|
double | getDoubleValue() | |
|
Gets the double value contained in the cell.
|
float | getFloatValue() | |
|
Gets the float value contained in the cell.
|
java.lang.String | getFormula() | |
void | setFormula(java.lang.String value) | |
|
Gets or sets a formula of the Cell.
|
java.lang.String | getHtmlString() | |
void | setHtmlString(java.lang.String value) | |
|
Gets and sets the html string which contains data and some formats in this cell.
|
int | getIntValue() | |
|
Gets the integer value contained in the cell.
|
boolean | isArrayHeader() | |
|
Inidicates the cell's formula is and array formula
and it is the first cell of the array.
|
boolean | isErrorValue() | |
|
Checks if a formula can properly evaluate a result.
|
boolean | isFormula() | |
|
Represents if the specified cell contains formula.
|
boolean | isInArray() | |
|
Indicates whether the cell formula is an array formula.
|
boolean | isInTable() | |
|
Indicates whether this cell is part of table formula.
|
boolean | isMerged() | |
|
Checks if a cell is part of a merged range or not.
|
boolean | isStyleSet() | |
|
Indicates if the cell's style is set. If return false, it means this cell has a default cell format.
|
java.lang.String | getName() | |
|
Gets the name of the cell.
|
int | getNumberCategoryType() | |
|
Represents the category type of this cell's number formatting.
The value of the property is NumberCategoryType integer constant. |
java.lang.String | getR1C1Formula() | |
void | setR1C1Formula(java.lang.String value) | |
|
Gets or sets a R1C1 formula of the Cell.
|
int | getRow() | |
|
Gets row number (zero based) of the cell.
|
int | getSharedStyleIndex() | |
|
Gets cell's shared style index in the style pool.
|
java.lang.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).
|
java.lang.String | getStringValueWithoutFormat() | |
|
Gets cell's value as string without any format.
|
int | getType() | |
|
Represents cell value type.
The value of the property is CellValueType integer constant. |
java.lang.Object | getValue() | |
void | setValue(java.lang.Object value) | |
|
Gets the value contained in this cell.
|
Worksheet | getWorksheet() | |
|
Gets the parent worksheet.
|
Method Summary |
void | calculate(boolean ignoreError, ICustomFunction customFunction) | |
Calcaulate the formula of the cell.
|
void | calculate(CalculationOptions options) | |
Calcaulate the formula of the cell.
|
FontSetting | characters(int startIndex, int length) | |
Returns a Characters object that represents a range of characters within the cell text.
|
void | copy(Cell cell) | |
Copies data from a source cell.
|
boolean | equals(Cell cell) | |
Checks whether this object refers to the same cell with another cell object.
|
boolean | equals(java.lang.Object obj) | |
Checks whether this object refers to the same cell with another.
|
CellArea | getArrayRange() | |
Gets the array range if the cell's formula is an array formula.
|
FontSetting[] | getCharacters() | |
Returns all Characters objects
that represents a range of characters within the cell text.
|
FontSetting[] | getCharacters(boolean flag) | |
Returns all Characters objects
that represents a range of characters within the cell text.
|
ConditionalFormattingResult | getConditionalFormattingResult() | |
Get the result of the conditional formatting.
|
Cell[] | getDependents(boolean isAll) | |
Get all cells which refer to the specific cell.
|
Style | getDisplayStyle() | |
Gets the display style of the cell.
If the cell is conditional formatted, the display style is not same as the cell.GetStyle().
|
FormatConditionCollection[] | getFormatConditions() | |
Gets format conditions which applies to this cell.
|
int | getHeightOfValue() | |
Gets the height of the value in unit of pixels.
|
java.util.Iterator | getLeafs() | |
Get all cells which will be updated when this cell is modified.
This method can only work after calling Workbook.CalculateFormula.
|
Range | getMergedRange() | |
Returns a Range object which represents a merged range.
|
ReferredAreaCollection | getPrecedents() | |
Gets all cells or ranges which this cell's formula depends on.
|
java.lang.String | getStringValue(int formatStrategy) | |
Gets the string value by specific formatted strategy.
|
Style | getStyle() | |
Gets the cell style.
|
Style | getStyle(boolean checkBorders) | |
If checkBorders is true, check whether other cells' borders will effect the style of this cell.
|
ListObject | getTable() | |
Gets the table which contains this cell.
|
Validation | getValidation() | |
Gets the validation applied to this cell.
|
boolean | getValidationValue() | |
Gets the value of validation which applied to this cell.
|
int | getWidthOfValue() | |
Gets the width of the value in unit of pixels.
|
int | hashCode() | |
Serves as a hash function for a particular type.
|
boolean | isRichText() | |
Indicates whether the cell string value is a rich text.
|
void | putValue(boolean boolValue) | |
Puts an boolean value into the cell.
|
void | putValue(DateTime dateTime) | |
Puts a DateTime value into the cell.
|
void | putValue(double doubleValue) | |
Puts a double value into the cell.
|
void | putValue(int intValue) | |
Puts an integer value into the cell.
|
void | putValue(java.lang.Object objectValue) | |
Puts an object value into the cell.
|
void | putValue(java.lang.String stringValue) | |
Puts a string value into the cell.
|
void | putValue(java.lang.String stringValue, boolean isConverted) | |
Puts a string value into the cell and converts the value to other data type if appropriate.
|
void | putValue(java.lang.String stringValue, boolean isConverted, boolean 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.
|
void | removeArrayFormula(boolean leaveNormalFormula) | |
Remove array formula.
|
void | setAddInFormula(java.lang.String addInFileName, java.lang.String addInFunction) | |
Sets an Add-In formula to the cell.
|
void | setArrayFormula(java.lang.String arrayFormula, int rowNumber, int columnNumber) | |
Sets an array formula to a range of cells.
|
void | setCharacters(FontSetting[] characters) | |
Sets rich text format of the cell.
|
void | setFormula(java.lang.String formula, java.lang.Object value) | |
Set the formula and the value of the formula.
|
void | setSharedFormula(java.lang.String sharedFormula, int rowNumber, int columnNumber) | |
Sets a formula to a range of cells.
|
void | setStyle(Style style) | |
Sets the cell style.
|
void | setStyle(Style style, boolean explicitFlag) | |
Apply the cell style.
|
void | setStyle(Style style, StyleFlag flag) | |
Apply the cell style.
|
java.lang.String | toString() | |
Returns a string represents the current Cell object.
|
Property Getters/Setters Detail |
-
Gets the parent worksheet.
getDateTimeValue | |
public DateTime getDateTimeValue()
|
-
Gets the DateTime value contained in the cell.
getRow | |
public int getRow()
|
-
Gets row number (zero based) of the cell.
Cell row number
getColumn | |
public int getColumn()
|
-
Gets column number (zero based) of the cell.
isFormula | |
public boolean isFormula()
|
-
Represents if the specified cell contains formula.
getType | |
public int getType()
|
-
Represents cell value type.
The value of the property is CellValueType integer constant.
getName | |
public java.lang.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 | |
public boolean isErrorValue()
|
-
Checks if a formula can properly evaluate a result.
Only applies to formula cell.
getStringValue | |
public java.lang.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 | |
public java.lang.String getStringValueWithoutFormat()
|
-
Gets cell's value as string without any format.
getNumberCategoryType | |
public int getNumberCategoryType()
|
-
Represents the category type of this cell's number formatting.
The value of the property is NumberCategoryType integer constant.
getDisplayStringValue | |
public java.lang.String getDisplayStringValue()
|
-
Gets the formatted string value of this cell.
getIntValue | |
public int getIntValue()
|
-
Gets the integer value contained in the cell.
getDoubleValue | |
public double getDoubleValue()
|
-
Gets the double value contained in the cell.
getFloatValue | |
public float getFloatValue()
|
-
Gets the float value contained in the cell.
getBoolValue | |
public boolean getBoolValue()
|
-
Gets the boolean value contained in the cell.
getSharedStyleIndex | |
public int getSharedStyleIndex()
|
-
Gets cell's shared style index in the style pool.
getFormula/setFormula | |
public java.lang.String getFormula() / public void setFormula(java.lang.String 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 delimeter, such as "=SUM(A1, E1, H2)".
User can set any formula in Workbook designer file. Aspose.Cells will keep all the formulas.
If user use this property to set a formula to a cell, major part of Workbook built-in functions
is supported. And more is coming. If you have any special need for Workbook built-in functions,
please let us know.
Example:
Workbook excel = new Workbook();
Cells cells = excel.getWorksheets().get(0).getCells();
cells.get("B6").setFormula("=SUM(B2:B5, E1) + sheet2!A1");
getR1C1Formula/setR1C1Formula | |
public java.lang.String getR1C1Formula() / public void setR1C1Formula(java.lang.String value)
|
-
Gets or sets a R1C1 formula of the Cell.
containsExternalLink | |
public boolean containsExternalLink()
|
-
Indicates whether this cell contains an external link.
Only applies when the cell is a formula cell.
isArrayHeader | |
public boolean isArrayHeader()
|
-
Inidicates the cell's formula is and array formula
and it is the first cell of the array.
isInArray | |
public boolean isInArray()
|
-
Indicates whether the cell formula is an array formula.
isInTable | |
public boolean isInTable()
|
-
Indicates whether this cell is part of table formula.
getValue/setValue | |
public java.lang.Object getValue() / public void setValue(java.lang.Object value)
|
-
Gets the value contained in this cell.
Possible type:
null,
Boolean,
DateTime,
Double,
Integer
String.
isStyleSet | |
public boolean isStyleSet()
|
-
Indicates if the cell's style is set. If return false, it means this cell has a default cell format.
isMerged | |
public boolean isMerged()
|
-
Checks if a cell is part of a merged range or not.
getHtmlString/setHtmlString | |
public java.lang.String getHtmlString() / public void setHtmlString(java.lang.String value)
|
-
Gets and sets the html string which contains data and some formats in this cell.
removeArrayFormula | |
public void removeArrayFormula(boolean leaveNormalFormula) |
-
Remove array formula.
- Parameters:
leaveNormalFormula
- True represents converting the array formula to normal formula.
setAddInFormula | |
public void setAddInFormula(java.lang.String addInFileName, java.lang.String addInFunction) |
-
Sets an Add-In formula to the cell.
Add-In file should be placed in the directory or sub-directory of Workbook Add-In library.
For example, file name can be "Eurotool.xla" or "solver\solver.xla".
- Parameters:
addInFileName
- Add-In file name.addInFunction
- Add-In function name.
Example:
cells.get("h11").setAddInFormula("HRVSTTRK.xla", "=pct_overcut(F3:G3)");
cells.get("h12").setAddInFormula("HRVSTTRK.xla", "=pct_overcut()");
copy | |
public void copy(Cell cell) |
-
Copies data from a source cell.
- Parameters:
cell
- Source Cell object.
characters | |
public FontSetting characters(int startIndex, int 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
- The index of the start of the character.length
- The number of characters.
- Returns:
- Characters object.
Example:
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());
isRichText | |
public boolean isRichText() |
-
Indicates whether the cell string value is a rich text.
-
Returns all Characters objects
that represents a range of characters within the cell text.
- Returns:
- All Characters objects
-
Returns all Characters objects
that represents a range of characters within the cell text.
- Parameters:
flag
- Indicates whether applying table style to the cell if the cell is in the table.
- Returns:
- All Characters objects
setCharacters | |
public void setCharacters(FontSetting[] characters) |
-
Sets rich text format of the cell.
- Parameters:
characters
- All Characters objects.
getMergedRange | |
public Range getMergedRange() |
-
Returns a Range object which represents a merged range.
- Returns:
- Range object. Null if this cell is not merged.
setSharedFormula | |
public void setSharedFormula(java.lang.String sharedFormula, int rowNumber, int columnNumber) |
-
Sets a formula to a range of cells.
- Parameters:
sharedFormula
- Shared formula.rowNumber
- Number of rows to populate the formula.columnNumber
- Number of columns to populate the formula.
toString | |
public java.lang.String toString() |
-
Returns a string represents the current Cell object.
- Returns:
equals | |
public boolean equals(java.lang.Object obj) |
-
Checks whether this object refers to the same cell with another.
- Parameters:
obj
- another object
- Returns:
- true if two objects refers to the same cell.
hashCode | |
public int hashCode() |
-
Serves as a hash function for a particular type.
- Returns:
- A hash code for current Cell object.
equals | |
public boolean equals(Cell cell) |
-
Checks whether this object refers to the same cell with another cell object.
- Parameters:
cell
- another cell object
- Returns:
- true if two cell objects refers to the same cell.
-
Get the result of the conditional formatting.
Returns null if no conditional formatting is applied to this cell,
-
Gets the validation applied to this cell.
- Returns:
getValidationValue | |
public boolean getValidationValue() |
-
Gets the value of validation which applied to this cell.
- Returns:
-
Gets the table which contains this cell.
- Returns:
-
Calcaulate the formula of the cell.
- Parameters:
options
- Options for calculation
calculate | |
public void calculate(boolean ignoreError, ICustomFunction customFunction) |
-
Calcaulate the formula of the cell.
- Parameters:
ignoreError
- Indicates if hide the error in calculating formulas.
The error may be unsupported function, external links, etc.customFunction
- The custom formula calculation functions to extend the calculation engine.
putValue | |
public void putValue(boolean boolValue) |
-
Puts an boolean value into the cell.
- Parameters:
boolValue
-
putValue | |
public void putValue(int intValue) |
-
Puts an integer value into the cell.
- Parameters:
intValue
- Input value
putValue | |
public void putValue(double doubleValue) |
-
Puts a double value into the cell.
- Parameters:
doubleValue
- Input value
putValue | |
public void putValue(java.lang.String stringValue, boolean isConverted, boolean 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
- Input valueisConverted
- True: converted to other data type if appropriate.setStyle
- True: set the number format to cell's style when converting to other data type
putValue | |
public void putValue(java.lang.String stringValue, boolean isConverted) |
-
Puts a string value into the cell and converts the value to other data type if appropriate.
- Parameters:
stringValue
- Input valueisConverted
- True: converted to other data type if appropriate.
putValue | |
public void putValue(java.lang.String stringValue) |
-
Puts a string value into the cell.
- Parameters:
stringValue
- Input value
putValue | |
public void putValue(DateTime dateTime) |
-
Puts a DateTime value into the cell.
- Parameters:
dateTime
- Input value
putValue | |
public void putValue(java.lang.Object objectValue) |
-
Puts an object value into the cell.
- Parameters:
objectValue
- input value
getStringValue | |
public java.lang.String getStringValue(int formatStrategy) |
-
Gets the string value by specific formatted strategy.
- Parameters:
formatStrategy
- A CellValueFormatStrategy value. The formatted strategy.
- Returns:
getDisplayStyle | |
public Style getDisplayStyle() |
-
Gets the display style of the cell.
If the cell is conditional formatted, the display style is not same as the cell.GetStyle().
-
Gets format conditions which applies to this cell.
- Returns:
- Returns FormatConditionCollection object
getStyle | |
public Style getStyle() |
-
Gets the cell style.
To change the style of the cell, please call Cell.SetStyle() method after changing the style.
- Returns:
- Style object.
getStyle | |
public Style getStyle(boolean checkBorders) |
-
If checkBorders is true, check whether other cells' borders will effect the style of this cell.
- Parameters:
checkBorders
- Check other cells' borders
- Returns:
setStyle | |
public void setStyle(Style style) |
-
Sets the cell style.
If the border settings are changed, the border of adjact cells will be updated too.
- Parameters:
style
- The cell style.
setStyle | |
public void setStyle(Style style, boolean explicitFlag) |
-
Apply the cell style.
- Parameters:
style
- The cell style.explicitFlag
- True, only overwriting formatting which is explicitly set.
-
Apply the cell style.
- Parameters:
style
- The cell style.flag
- The style flag.
setFormula | |
public void setFormula(java.lang.String formula, java.lang.Object value) |
-
Set the formula and the value of the formula.
- Parameters:
formula
- The formula.value
- The value of the formula.
-
Gets all cells or ranges which this cell's formula depends on.
Returns null if this is not a formula cell.
- Returns:
-
Returns all cells or ranges.
Example:
Workbook workbook = new Workbook();
Cells cells = workbook.getWorksheets().get(0).getCells();
cells.get("A1").setFormula("= B1 + SUM(B1:B10) + [Book1.xls]Sheet1!A1");
ReferredAreaCollection areas = cells.get("A1").getPrecedents();
for (int i = 0; i < areas.getCount(); i++)
{
ReferredArea area = areas.get(i);
StringBuilder stringBuilder = new StringBuilder();
if (area.isExternalLink())
{
stringBuilder.append("[");
stringBuilder.append(area.getExternalFileName());
stringBuilder.append("]");
}
stringBuilder.append(area.getSheetName());
stringBuilder.append("!");
stringBuilder.append(CellsHelper.cellIndexToName(area.getStartRow(), area.getStartColumn()));
if (area.isArea())
{
stringBuilder.append(":");
stringBuilder.append(CellsHelper.cellIndexToName(area.getEndRow(), area.getEndColumn()));
}
System.out.println(m$Object.toString(stringBuilder));
}
workbook.save("C:\\Book2.xls");
getDependents | |
public Cell[] getDependents(boolean isAll) |
-
Get all cells which refer to the specific cell.
- Parameters:
isAll
- Indicates whether check other worksheets
getLeafs | |
public java.util.Iterator getLeafs() |
-
Get all cells which will be updated when this cell is modified.
This method can only work after calling Workbook.CalculateFormula.
getWidthOfValue | |
public int getWidthOfValue()
throws java.lang.Exception |
-
Gets the width of the value in unit of pixels.
- Returns:
getHeightOfValue | |
public int getHeightOfValue()
throws java.lang.Exception |
-
Gets the height of the value in unit of pixels.
- Returns:
getArrayRange | |
public 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.
setArrayFormula | |
public void setArrayFormula(java.lang.String arrayFormula, int rowNumber, int columnNumber) |
-
Sets an array formula to a range of cells.
- Parameters:
arrayFormula
- Array formula.rowNumber
- Number of rows to populate result of the array formula.columnNumber
- Number of columns to populate result of the array formula.
See Also:
Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
Aspose.Cells Support Forum - our preferred method of support.