com.acesoft.aceoffix.excelwriter
Class Cell

java.lang.Object
  com.acesoft.aceoffix.excelwriter.Cell

public class Cell
extends java.lang.Object

Cell class represents the cell object defined in Excel. Representing a cell object defined in Excel, Cell class is used to fill data into the cell and control the behavior of the cell.

You can only call the Sheet.openCell(String) method or the Sheet.openCellRC(int, int) method to get the Cell object.

Version:

5.0

Author:

Acesoft Corporation

Method Summary

Border	getBorder() Gets the border object.
Font	getFont() Gets the font object.
void	setBackColor(java.awt.Color value) Sets the back color of the cell.
void	setForeColor(java.awt.Color value) Sets the fore color of the cell.
void	setFormula(java.lang.String value) Sets the formula of the cell.
void	setHorizontalAlignment(XlHAlign value) Sets the horizontal alignment of the cell.
void	setNumberFormatLocal(java.lang.String value) Sets the data display format of the cell.
void	setReadOnly(boolean value) Sets a value that indicates whether the cell is read-only.
void	setValue(java.lang.String value) Sets the value of the cell.
void	setVerticalAlignment(XlVAlign value) Sets the vertical alignment of the cell.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

setValue

public void setValue(java.lang.String value)
              throws java.io.IOException

Sets the value of the cell.

Throws:

java.io.IOException

See Also:

Sheet.openCell().

setFormula

public void setFormula(java.lang.String value)
                throws java.io.IOException

Sets the formula of the cell. The formula uses A1-style notation which is defined in Microsoft Excel.

Throws:

java.io.IOException

See Also:

Sheet.openCell().

getBorder

public Border getBorder()
                 throws java.io.IOException

Gets the border object.

Throws:

java.io.IOException

See Also:

code example 2 in the Sheet#openTable(String) Sheet.openTable().

setBackColor

public void setBackColor(java.awt.Color value)
                  throws java.io.IOException

Sets the back color of the cell.

Throws:

java.io.IOException

See Also:

Sheet.openCell().

setForeColor

public void setForeColor(java.awt.Color value)
                  throws java.io.IOException

Sets the fore color of the cell.

Throws:

java.io.IOException

See Also:

Sheet.openCell().

setReadOnly

public void setReadOnly(boolean value)
                 throws java.io.IOException

Sets a value that indicates whether the cell is read-only.

If the value is true, the editable cell will be read-only. And if the value is false, the read-only cell will be editable.

Only when the OpenMode is Aceoffix.OpenModeType.xlsSubmitForm, the ReadOnly property is valid. The default value is false.

Throws:

java.io.IOException

getFont

public Font getFont()

Gets the font object.

setHorizontalAlignment

public void setHorizontalAlignment(XlHAlign value)
                            throws java.io.IOException

Sets the horizontal alignment of the cell.

Throws:

java.io.IOException

setVerticalAlignment

public void setVerticalAlignment(XlVAlign value)
                          throws java.io.IOException

Sets the vertical alignment of the cell.

Throws:

java.io.IOException

setNumberFormatLocal

public void setNumberFormatLocal(java.lang.String value)
                          throws java.io.IOException

Sets the data display format of the cell.

Throws:

java.io.IOException