org.eodisp.wrapper.excel
Class Range

java.lang.Object
  org.eodisp.wrapper.excel.Range

public class Range
extends java.lang.Object

Represents a range in an excel worksheet

Author:

ibirrer

Field Summary

static int	PROP_VALUE
(package private) static int	PROP_WORKSHEET

Constructor Summary

Range(org.eclipse.swt.ole.win32.OleAutomation range, Worksheet worksheet)

Method Summary

java.lang.String	getAddress() Returns the address of this range in the form "A1".
long	getColumn() Returns the column index of this range
double	getDoubleValue() Returns the double value of this range
float	getFloatValue() Returns the float value of this range
int	getIntValue() Returns the int value of this range
long	getLongValue() Returns the long value of this range
java.lang.String	getName() Returns the name of this range or null if this range doesn't have a name.
long	getRow() Return the row index of this range
java.lang.String	getStringValue() Returns the string value of this range
Worksheet	getWorksheet() Returns the worksheet of this range
void	select() Selects this range in the worksheet.
void	setValue(double value) Sets the value of this range
void	setValue(float value) Sets the value of this range
void	setValue(int value) Sets the value of this range
void	setValue(long value) Sets the value of this range
void	setValue(java.lang.String value) Sets the value of this range
java.lang.String	toString() Returns: Worksheet!Name[Address]

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

PROP_WORKSHEET

static final int PROP_WORKSHEET

See Also:

Constant Field Values

PROP_VALUE

public static final int PROP_VALUE

See Also:

Constant Field Values

Constructor Detail

Range

public Range(org.eclipse.swt.ole.win32.OleAutomation range,
             Worksheet worksheet)

Method Detail

getRow

public long getRow()

Return the row index of this range

Returns:

the row index of this range

getAddress

public java.lang.String getAddress()

Returns the address of this range in the form "A1".

Returns:

the address of this range

getColumn

public long getColumn()

Returns the column index of this range

Returns:

the column index of this range

setValue

public void setValue(int value)

Sets the value of this range

Parameters:

value - the value of this range

setValue

public void setValue(long value)

Sets the value of this range

Parameters:

value - the value of this range

setValue

public void setValue(java.lang.String value)

Sets the value of this range

Parameters:

value - the value of this range

setValue

public void setValue(double value)

Sets the value of this range

Parameters:

value - the value of this range

setValue

public void setValue(float value)

Sets the value of this range

Parameters:

value - the value of this range

getIntValue

public int getIntValue()

Returns the int value of this range

Returns:

the int value of this range

getLongValue

public long getLongValue()

Returns the long value of this range

Returns:

the long value of this range

getStringValue

public java.lang.String getStringValue()

Returns the string value of this range

Returns:

the string value of this range

getDoubleValue

public double getDoubleValue()

Returns the double value of this range

Returns:

the double value of this range

getFloatValue

public float getFloatValue()

Returns the float value of this range

Returns:

the float value of this range

select

public void select()

Selects this range in the worksheet.

getName

public java.lang.String getName()

Returns the name of this range or null if this range doesn't have a name.

Returns:

the name of this range or null if this range doesn't have a name.

getWorksheet

public Worksheet getWorksheet()

Returns the worksheet of this range

Returns:

the worksheet of this range

toString

public java.lang.String toString()

Returns: Worksheet!Name[Address]

Overrides:

toString in class java.lang.Object

Returns:

Worksheet!Name[Address]