QueryTable

Inheritance: java.lang.Object

public class QueryTable

Represents QueryTable information.

Example

         //Instantiating a Workbook object
         Workbook workbook = new Workbook();
 
         //Obtaining the reference of the first worksheet
         Worksheet worksheet = workbook.getWorksheets().get(0);
         //Getting the first query table in the worksheet if exists
         //QueryTable qt = worksheet.QueryTables[0];
         //Getting display address of the query table.
         //string address = qt.ResultRange.Address;

Methods

MethodDescription
equals(Object arg0)
getAdjustColumnWidth()Returns or sets the AdjustColumnWidth of the object.
getClass()
getConnectionId()Gets the connection id of the query table.
getExternalConnection()Gets the relate external connection.
getName()Gets the name of querytable.
getPreserveFormatting()Returns or sets the PreserveFormatting of the object.
getResultRange()Gets the range of the result.
hashCode()
notify()
notifyAll()
setAdjustColumnWidth(boolean value)Returns or sets the AdjustColumnWidth of the object.
setPreserveFormatting(boolean value)Returns or sets the PreserveFormatting of the object.
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getAdjustColumnWidth()

public boolean getAdjustColumnWidth()

Returns or sets the AdjustColumnWidth of the object.

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getConnectionId()

public int getConnectionId()

Gets the connection id of the query table.

Returns: int

getExternalConnection()

public ExternalConnection getExternalConnection()

Gets the relate external connection.

Returns: ExternalConnection

getName()

public String getName()

Gets the name of querytable.

Returns: java.lang.String

getPreserveFormatting()

public boolean getPreserveFormatting()

Returns or sets the PreserveFormatting of the object.

Returns: boolean

getResultRange()

public Range getResultRange()

Gets the range of the result.

Returns: Range -

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

setAdjustColumnWidth(boolean value)

public void setAdjustColumnWidth(boolean value)

Returns or sets the AdjustColumnWidth of the object.

Parameters:

ParameterTypeDescription
valueboolean

setPreserveFormatting(boolean value)

public void setPreserveFormatting(boolean value)

Returns or sets the PreserveFormatting of the object.

Parameters:

ParameterTypeDescription
valueboolean

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int