org.eodisp.wrapper.excel
Class Worksheet

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

public class Worksheet
extends java.lang.Object

Represents an Excel Worksheet.

Author:

ibirrer

Constructor Summary

Worksheet(org.eclipse.swt.ole.win32.OleAutomation worksheet, Workbook workbook)

Method Summary

CommandButton	getCommandButton(int index) Returns the command button by its index.
CommandButton	getCommandButton(java.lang.String name) Returns the command button with the given name.
java.util.List<CommandButton>	getCommandButtons() Returns all command buttons in this worksheet.
java.lang.String	getName() Returns the name of this worksheet
Range	getRange(java.lang.String range) Returns a range of this Worksheet.
Workbook	getWorkbook() Returns the workbook that contains this worksheet.

Methods inherited from class java.lang.Object

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

Constructor Detail

Worksheet

Worksheet(org.eclipse.swt.ole.win32.OleAutomation worksheet,
          Workbook workbook)

Method Detail

getRange

public Range getRange(java.lang.String range)

Returns a range of this Worksheet.

Parameters:

range - the range, either given in the form A1 or the name of the range.

Returns:

the range or null if the given string does not name a valid range.

getName

public java.lang.String getName()

Returns the name of this worksheet

Returns:

the name of this worksheet.

getWorkbook

public Workbook getWorkbook()

Returns the workbook that contains this worksheet.

Returns:

the workbook that conatais this workbook.

getCommandButton

public CommandButton getCommandButton(java.lang.String name)

Returns the command button with the given name.

Parameters:

name - the unique name of the command button.

Returns:

the command button or null if no command button exists with the given name.

getCommandButton

public CommandButton getCommandButton(int index)

Returns the command button by its index.

Parameters:

index - the index of the command button

Returns:

the command button or null if no command button exists with the given index.

See Also:

#getCommandButton(String)}

getCommandButtons

public java.util.List<CommandButton> getCommandButtons()

Returns all command buttons in this worksheet.

Returns:

all command buttons in this worksheet.