IChartDataCell
public interface IChartDataCell
Represents cell for chart data.
Methods
| Method | Description |
|---|---|
| getRow() | Returns the index of the row of worksheet in which the cell is located. |
| getColumn() | Returns the index of the column of worksheet in which the cell is located. |
| getValue() | Gets or sets the value of a cell. |
| setValue(Object value) | Gets or sets the value of a cell. |
| getFormula() | Gets or sets the formula in A1-style. |
| setFormula(String value) | Gets or sets the formula in A1-style. |
| getR1C1Formula() | Gets or sets the formula in R1C1-style. |
| setR1C1Formula(String value) | Gets or sets the formula in R1C1-style. |
| getChartDataWorksheet() | Gets the worksheet. |
| isHidden() | Determines whether the cell is hidden. |
| getCustomNumberFormat() | Gets or sets the custom display format of numbers and dates. |
| setCustomNumberFormat(String value) | Gets or sets the custom display format of numbers and dates. |
| getPresetNumberFormat() | Gets or sets the built-in display format of numbers and dates. |
| setPresetNumberFormat(byte value) | Gets or sets the built-in display format of numbers and dates. |
| calculate(boolean updateValues) | If the cell contains a formula, the value will be updated base on that formula. |
getRow()
public abstract int getRow()
Returns the index of the row of worksheet in which the cell is located. Read-only int.
Returns: int
getColumn()
public abstract int getColumn()
Returns the index of the column of worksheet in which the cell is located. Read-only int.
Returns: int
getValue()
public abstract Object getValue()
Gets or sets the value of a cell. Read/write Object.
workbook.getCell(0, "F2").setValue(-2.5f); workbook.getCell(0, "G3").setValue(6.3f);
Returns: java.lang.Object
setValue(Object value)
public abstract void setValue(Object value)
Gets or sets the value of a cell. Read/write Object.
workbook.getCell(0, "F2").setValue(-2.5f); workbook.getCell(0, "G3").setValue(6.3f);
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | java.lang.Object |
getFormula()
public abstract String getFormula()
Gets or sets the formula in A1-style.
IChartDataCell cell = workbook.getCell(0, "B2"); cell.setFormula("1 + SUM(F2:H5)");
Returns: java.lang.String
setFormula(String value)
public abstract void setFormula(String value)
Gets or sets the formula in A1-style.
IChartDataCell cell = workbook.getCell(0, "B2"); cell.setFormula("1 + SUM(F2:H5)");
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | java.lang.String |
getR1C1Formula()
public abstract String getR1C1Formula()
Gets or sets the formula in R1C1-style.
IChartDataCell cell = workbook.getCell(0, "C2"); cell.setR1C1Formula("MAX(R2C6:R5C8) / 3");
Returns: java.lang.String
setR1C1Formula(String value)
public abstract void setR1C1Formula(String value)
Gets or sets the formula in R1C1-style.
IChartDataCell cell = workbook.getCell(0, "C2"); cell.setR1C1Formula("MAX(R2C6:R5C8) / 3");
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | java.lang.String |
getChartDataWorksheet()
public abstract IChartDataWorksheet getChartDataWorksheet()
Gets the worksheet. Read-only IChartDataWorksheet.
Returns: IChartDataWorksheet
isHidden()
public abstract boolean isHidden()
Determines whether the cell is hidden. Read-only boolean.
Returns: boolean
getCustomNumberFormat()
public abstract String getCustomNumberFormat()
Gets or sets the custom display format of numbers and dates. If value is empty will be used PresetNumberFormat value. Read/write String.
Returns: java.lang.String
setCustomNumberFormat(String value)
public abstract void setCustomNumberFormat(String value)
Gets or sets the custom display format of numbers and dates. If value is empty will be used PresetNumberFormat value. Read/write String.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | java.lang.String |
getPresetNumberFormat()
public abstract byte getPresetNumberFormat()
Gets or sets the built-in display format of numbers and dates. Preset number must be in [0..22] or [37..49]. Read/write byte.
0 General 1 0 2 0.00 3 #,##0 4 #,##0.00 5 $#,##0;$-#,##0 6 $#,##0;[Red]$-#,##0 7 $#,##0.00;$-#,##0.00 8 $#,##0.00;[Red]$-#,##0.00 9 0% 10 0.00% 11 0.00E+00 12 # ?/? 13 # / 14 m/d/yy 15 d-mmm-yy 16 d-mmm 17 mmm-yy 18 h:mm AM/PM 19 h:mm:ss AM/PM 20 h:mm 21 h:mm:ss 22 m/d/yy h:mm 37 #,##0;-#,##0 38 #,##0;[Red]-#,##0 39 #,##0.00;-#,##0.00 40 #,##0.00;[Red]-#,##0.00 41 _ * #,##0_ ;_ * "_ ;_ @_ 42 _ $* #,##0_ ;_ $* "_ ;_ @_ 43 _ * #,##0.00_ ;_ * "??_ ;_ @_ 44 _ $* #,##0.00_ ;_ $* "??_ ;_ @_ 45 mm:ss 46 h :mm:ss 47 mm:ss.0 48 ##0.0E+00 49 @
Returns: byte
setPresetNumberFormat(byte value)
public abstract void setPresetNumberFormat(byte value)
Gets or sets the built-in display format of numbers and dates. Preset number must be in [0..22] or [37..49]. Read/write byte.
0 General 1 0 2 0.00 3 #,##0 4 #,##0.00 5 $#,##0;$-#,##0 6 $#,##0;[Red]$-#,##0 7 $#,##0.00;$-#,##0.00 8 $#,##0.00;[Red]$-#,##0.00 9 0% 10 0.00% 11 0.00E+00 12 # ?/? 13 # / 14 m/d/yy 15 d-mmm-yy 16 d-mmm 17 mmm-yy 18 h:mm AM/PM 19 h:mm:ss AM/PM 20 h:mm 21 h:mm:ss 22 m/d/yy h:mm 37 #,##0;-#,##0 38 #,##0;[Red]-#,##0 39 #,##0.00;-#,##0.00 40 #,##0.00;[Red]-#,##0.00 41 _ * #,##0_ ;_ * "_ ;_ @_ 42 _ $* #,##0_ ;_ $* "_ ;_ @_ 43 _ * #,##0.00_ ;_ * "??_ ;_ @_ 44 _ $* #,##0.00_ ;_ $* "??_ ;_ @_ 45 mm:ss 46 h :mm:ss 47 mm:ss.0 48 ##0.0E+00 49 @
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | byte |
calculate(boolean updateValues)
public abstract void calculate(boolean updateValues)
If the cell contains a formula, the value will be updated base on that formula.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| updateValues | boolean | If false, no actual calculation will be performed. Use true for possible exceptions check. |