com.moyosoft.connector.ms.excel
Class QueryTable

java.lang.Object
  |
  +--com.moyosoft.connector.ms.excel.QueryTable

public class QueryTable

extends java.lang.Object

Constructor Summary

QueryTable(Dispatch dispatch)

Method Summary

void	cancelRefresh()
void	delete()
CmdType	getCommandType()
Range	getDestination()
Dispatch	getDispatch()
ListObject	getListObject()
java.lang.String	getName()
Parameters	getParameters()
java.lang.String	getPostText()
QueryType	getQueryType()
int	getRefreshPeriod()
CellInsertionMode	getRefreshStyle()
Range	getResultRange()
RobustConnect	getRobustConnect()
java.lang.String	getSourceConnectionFile()
java.lang.String	getSourceDataFile()
java.lang.String	getTextFileDecimalSeparator()
java.lang.String	getTextFileOtherDelimiter()
TextParsingType	getTextFileParseType()
int	getTextFilePlatform()
int	getTextFileStartRow()
TextQualifier	getTextFileTextQualifier()
java.lang.String	getTextFileThousandsSeparator()
TextVisualLayoutType	getTextFileVisualLayout()
WebFormatting	getWebFormatting()
WebSelectionType	getWebSelectionType()
java.lang.String	getWebTables()
boolean	isAdjustColumnWidth()
boolean	isBackgroundQuery()
boolean	isEnableEditing()
boolean	isEnableRefresh()
boolean	isFetchedRowOverflow()
boolean	isFieldNames()
boolean	isFillAdjacentFormulas()
boolean	isHasAutoFormat()
boolean	isMaintainConnection()
boolean	isPreserveColumnInfo()
boolean	isPreserveFormatting()
boolean	isRefreshing()
boolean	isRefreshOnFileOpen()
boolean	isRowNumbers()
boolean	isSaveData()
boolean	isSavePassword()
boolean	isTablesOnlyFromHTML()
boolean	isTextFileCommaDelimiter()
boolean	isTextFileConsecutiveDelimiter()
boolean	isTextFilePromptOnRefresh()
boolean	isTextFileSemicolonDelimiter()
boolean	isTextFileSpaceDelimiter()
boolean	isTextFileTabDelimiter()
boolean	isTextFileTrailingMinusNumbers()
boolean	isWebConsecutiveDelimitersAsOne()
boolean	isWebDisableDateRecognition()
boolean	isWebDisableRedirections()
boolean	isWebPreFormattedTextToColumns()
boolean	isWebSingleBlockTextImport()
boolean	refresh()
void	resetTimer()
void	saveAsODC(java.io.File file)
void	saveAsODC(java.io.File file, java.lang.String description)
void	setAdjustColumnWidth(boolean value)
void	setBackgroundQuery(boolean value)
void	setCommandType(CmdType value)
void	setEnableEditing(boolean value)
void	setEnableRefresh(boolean value)
void	setFieldNames(boolean value)
void	setFillAdjacentFormulas(boolean value)
void	setHasAutoFormat(boolean value)
void	setMaintainConnection(boolean value)
void	setName(java.lang.String value)
void	setPostText(java.lang.String value)
void	setPreserveColumnInfo(boolean value)
void	setPreserveFormatting(boolean value)
void	setRefreshOnFileOpen(boolean value)
void	setRefreshPeriod(int value)
void	setRefreshStyle(CellInsertionMode value)
void	setRobustConnect(RobustConnect value)
void	setRowNumbers(boolean value)
void	setSaveData(boolean value)
void	setSavePassword(boolean value)
void	setSourceConnectionFile(java.lang.String value)
void	setSourceDataFile(java.lang.String value)
void	setTablesOnlyFromHTML(boolean value)
void	setTextFileCommaDelimiter(boolean value)
void	setTextFileConsecutiveDelimiter(boolean value)
void	setTextFileDecimalSeparator(java.lang.String value)
void	setTextFileOtherDelimiter(java.lang.String value)
void	setTextFileParseType(TextParsingType value)
void	setTextFilePlatform(int value)
void	setTextFilePromptOnRefresh(boolean value)
void	setTextFileSemicolonDelimiter(boolean value)
void	setTextFileSpaceDelimiter(boolean value)
void	setTextFileStartRow(int value)
void	setTextFileTabDelimiter(boolean value)
void	setTextFileTextQualifier(TextQualifier value)
void	setTextFileThousandsSeparator(java.lang.String value)
void	setTextFileTrailingMinusNumbers(boolean value)
void	setTextFileVisualLayout(TextVisualLayoutType value)
void	setWebConsecutiveDelimitersAsOne(boolean value)
void	setWebDisableDateRecognition(boolean value)
void	setWebDisableRedirections(boolean value)
void	setWebFormatting(WebFormatting value)
void	setWebPreFormattedTextToColumns(boolean value)
void	setWebSelectionType(WebSelectionType value)
void	setWebSingleBlockTextImport(boolean value)
void	setWebTables(java.lang.String value)

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryTable

public QueryTable(Dispatch dispatch)

Method Detail

getDispatch

public Dispatch getDispatch()

getName

public java.lang.String getName()

setName

public void setName(java.lang.String value)

isFieldNames

public boolean isFieldNames()

setFieldNames

public void setFieldNames(boolean value)

isRowNumbers

public boolean isRowNumbers()

setRowNumbers

public void setRowNumbers(boolean value)

isFillAdjacentFormulas

public boolean isFillAdjacentFormulas()

setFillAdjacentFormulas

public void setFillAdjacentFormulas(boolean value)

isHasAutoFormat

public boolean isHasAutoFormat()

setHasAutoFormat

public void setHasAutoFormat(boolean value)

isRefreshOnFileOpen

public boolean isRefreshOnFileOpen()

setRefreshOnFileOpen

public void setRefreshOnFileOpen(boolean value)

isRefreshing

public boolean isRefreshing()

isFetchedRowOverflow

public boolean isFetchedRowOverflow()

isBackgroundQuery

public boolean isBackgroundQuery()

setBackgroundQuery

public void setBackgroundQuery(boolean value)

cancelRefresh

public void cancelRefresh()

getRefreshStyle

public CellInsertionMode getRefreshStyle()

setRefreshStyle

public void setRefreshStyle(CellInsertionMode value)

isEnableRefresh

public boolean isEnableRefresh()

setEnableRefresh

public void setEnableRefresh(boolean value)

isSavePassword

public boolean isSavePassword()

setSavePassword

public void setSavePassword(boolean value)

getDestination

public Range getDestination()

getPostText

public java.lang.String getPostText()

setPostText

public void setPostText(java.lang.String value)

getResultRange

public Range getResultRange()

delete

public void delete()

refresh

public boolean refresh()

getParameters

public Parameters getParameters()

isSaveData

public boolean isSaveData()

setSaveData

public void setSaveData(boolean value)

isTablesOnlyFromHTML

public boolean isTablesOnlyFromHTML()

setTablesOnlyFromHTML

public void setTablesOnlyFromHTML(boolean value)

isEnableEditing

public boolean isEnableEditing()

setEnableEditing

public void setEnableEditing(boolean value)

getTextFilePlatform

public int getTextFilePlatform()

setTextFilePlatform

public void setTextFilePlatform(int value)

getTextFileStartRow

public int getTextFileStartRow()

setTextFileStartRow

public void setTextFileStartRow(int value)

getTextFileParseType

public TextParsingType getTextFileParseType()

setTextFileParseType

public void setTextFileParseType(TextParsingType value)

getTextFileTextQualifier

public TextQualifier getTextFileTextQualifier()

setTextFileTextQualifier

public void setTextFileTextQualifier(TextQualifier value)

isTextFileConsecutiveDelimiter

public boolean isTextFileConsecutiveDelimiter()

setTextFileConsecutiveDelimiter

public void setTextFileConsecutiveDelimiter(boolean value)

isTextFileTabDelimiter

public boolean isTextFileTabDelimiter()

setTextFileTabDelimiter

public void setTextFileTabDelimiter(boolean value)

isTextFileSemicolonDelimiter

public boolean isTextFileSemicolonDelimiter()

setTextFileSemicolonDelimiter

public void setTextFileSemicolonDelimiter(boolean value)

isTextFileCommaDelimiter

public boolean isTextFileCommaDelimiter()

setTextFileCommaDelimiter

public void setTextFileCommaDelimiter(boolean value)

isTextFileSpaceDelimiter

public boolean isTextFileSpaceDelimiter()

setTextFileSpaceDelimiter

public void setTextFileSpaceDelimiter(boolean value)

getTextFileOtherDelimiter

public java.lang.String getTextFileOtherDelimiter()

setTextFileOtherDelimiter

public void setTextFileOtherDelimiter(java.lang.String value)

isPreserveColumnInfo

public boolean isPreserveColumnInfo()

setPreserveColumnInfo

public void setPreserveColumnInfo(boolean value)

isPreserveFormatting

public boolean isPreserveFormatting()

setPreserveFormatting

public void setPreserveFormatting(boolean value)

isAdjustColumnWidth

public boolean isAdjustColumnWidth()

setAdjustColumnWidth

public void setAdjustColumnWidth(boolean value)

getCommandType

public CmdType getCommandType()

setCommandType

public void setCommandType(CmdType value)

isTextFilePromptOnRefresh

public boolean isTextFilePromptOnRefresh()

setTextFilePromptOnRefresh

public void setTextFilePromptOnRefresh(boolean value)

getQueryType

public QueryType getQueryType()

isMaintainConnection

public boolean isMaintainConnection()

setMaintainConnection

public void setMaintainConnection(boolean value)

getTextFileDecimalSeparator

public java.lang.String getTextFileDecimalSeparator()

setTextFileDecimalSeparator

public void setTextFileDecimalSeparator(java.lang.String value)

getTextFileThousandsSeparator

public java.lang.String getTextFileThousandsSeparator()

setTextFileThousandsSeparator

public void setTextFileThousandsSeparator(java.lang.String value)

getRefreshPeriod

public int getRefreshPeriod()

setRefreshPeriod

public void setRefreshPeriod(int value)

resetTimer

public void resetTimer()

getWebSelectionType

public WebSelectionType getWebSelectionType()

setWebSelectionType

public void setWebSelectionType(WebSelectionType value)

getWebFormatting

public WebFormatting getWebFormatting()

setWebFormatting

public void setWebFormatting(WebFormatting value)

getWebTables

public java.lang.String getWebTables()

setWebTables

public void setWebTables(java.lang.String value)

isWebPreFormattedTextToColumns

public boolean isWebPreFormattedTextToColumns()

setWebPreFormattedTextToColumns

public void setWebPreFormattedTextToColumns(boolean value)

isWebSingleBlockTextImport

public boolean isWebSingleBlockTextImport()

setWebSingleBlockTextImport

public void setWebSingleBlockTextImport(boolean value)

isWebDisableDateRecognition

public boolean isWebDisableDateRecognition()

setWebDisableDateRecognition

public void setWebDisableDateRecognition(boolean value)

isWebConsecutiveDelimitersAsOne

public boolean isWebConsecutiveDelimitersAsOne()

setWebConsecutiveDelimitersAsOne

public void setWebConsecutiveDelimitersAsOne(boolean value)

isWebDisableRedirections

public boolean isWebDisableRedirections()

setWebDisableRedirections

public void setWebDisableRedirections(boolean value)

getSourceConnectionFile

public java.lang.String getSourceConnectionFile()

setSourceConnectionFile

public void setSourceConnectionFile(java.lang.String value)

getSourceDataFile

public java.lang.String getSourceDataFile()

setSourceDataFile

public void setSourceDataFile(java.lang.String value)

getRobustConnect

public RobustConnect getRobustConnect()

setRobustConnect

public void setRobustConnect(RobustConnect value)

isTextFileTrailingMinusNumbers

public boolean isTextFileTrailingMinusNumbers()

setTextFileTrailingMinusNumbers

public void setTextFileTrailingMinusNumbers(boolean value)

saveAsODC

public void saveAsODC(java.io.File file)

saveAsODC

public void saveAsODC(java.io.File file,
                      java.lang.String description)

getListObject

public ListObject getListObject()

getTextFileVisualLayout

public TextVisualLayoutType getTextFileVisualLayout()

setTextFileVisualLayout

public void setTextFileVisualLayout(TextVisualLayoutType value)