com.acesoft.aceoffix
Class ExcelReqSheet

java.lang.Object
  extended by com.acesoft.aceoffix.ExcelReqSheet

public class ExcelReqSheet
extends java.lang.Object

Represents a worksheet. Extracts data from the worksheet. You can only use the ExcelRequest.openSheet method to obtain a ExcelReqSheet object.

Version:
3.0
Author:
Acesoft Corporation

Method Summary
 java.lang.String getName()
          Gets the name of the worksheet.
 ExcelReqCell openCell(java.lang.String submitName)
          Opens the specified cell and returns a ExcelReqCell object.
 ExcelReqTableRange openTableRange(java.lang.String submitName)
          Opens the specified TableRange and returns a ExcelReqTableRange object.
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

getName

public java.lang.String getName()
                         throws java.io.IOException
Gets the name of the worksheet.

Throws:
java.io.IOException

openCell

public ExcelReqCell openCell(java.lang.String submitName)
                      throws java.lang.Exception,
                             java.io.IOException
Opens the specified cell and returns a ExcelReqCell object. If the specified cell exists, this method will return a ExcelResCell object.

Parameters:
submitName - The submitName is a name for submitting and is defined by developer before the Excel document is opened. The submitName is case-sensitive.
Throws:
java.lang.Exception
java.io.IOException

openTableRange

public ExcelReqTableRange openTableRange(java.lang.String submitName)
                                  throws java.lang.Exception,
                                         java.io.IOException
Opens the specified TableRange and returns a ExcelReqTableRange object. If the specified TableRange exists, this method will return a ExcelReqTableRange object.

Parameters:
submitName - The submitName is a name for submitting and is defined by developer before the Excel document is opened. The submitName is case-sensitive.
Throws:
java.lang.Exception
java.io.IOException