net.rgielen.com4j.office2010.excel._QueryTable Maven / Gradle / Ivy
package net.rgielen.com4j.office2010.excel ;
import com4j.*;
@IID("{00020400-0000-0000-C000-000000000046}")
public interface _QueryTable extends Com4jObject {
// Methods:
/**
*
* Getter method for the COM property "Application"
*
*/
@DISPID(148)
@PropGet
net.rgielen.com4j.office2010.excel._Application application();
/**
*
* Getter method for the COM property "Creator"
*
*/
@DISPID(149)
@PropGet
net.rgielen.com4j.office2010.excel.XlCreator creator();
/**
*
* Getter method for the COM property "Parent"
*
*/
@DISPID(150)
@PropGet
com4j.Com4jObject parent();
/**
*
* Getter method for the COM property "Name"
*
*/
@DISPID(110)
@PropGet
java.lang.String name();
/**
*
* Setter method for the COM property "Name"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(110)
@PropPut
void name(
java.lang.String rhs);
/**
*
* Getter method for the COM property "FieldNames"
*
*/
@DISPID(1584)
@PropGet
boolean fieldNames();
/**
*
* Setter method for the COM property "FieldNames"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1584)
@PropPut
void fieldNames(
boolean rhs);
/**
*
* Getter method for the COM property "RowNumbers"
*
*/
@DISPID(1585)
@PropGet
boolean rowNumbers();
/**
*
* Setter method for the COM property "RowNumbers"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1585)
@PropPut
void rowNumbers(
boolean rhs);
/**
*
* Getter method for the COM property "FillAdjacentFormulas"
*
*/
@DISPID(1586)
@PropGet
boolean fillAdjacentFormulas();
/**
*
* Setter method for the COM property "FillAdjacentFormulas"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1586)
@PropPut
void fillAdjacentFormulas(
boolean rhs);
/**
*
* Getter method for the COM property "HasAutoFormat"
*
*/
@DISPID(695)
@PropGet
boolean hasAutoFormat();
/**
*
* Setter method for the COM property "HasAutoFormat"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(695)
@PropPut
void hasAutoFormat(
boolean rhs);
/**
*
* Getter method for the COM property "RefreshOnFileOpen"
*
*/
@DISPID(1479)
@PropGet
boolean refreshOnFileOpen();
/**
*
* Setter method for the COM property "RefreshOnFileOpen"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1479)
@PropPut
void refreshOnFileOpen(
boolean rhs);
/**
*
* Getter method for the COM property "Refreshing"
*
*/
@DISPID(1587)
@PropGet
boolean refreshing();
/**
*
* Getter method for the COM property "FetchedRowOverflow"
*
*/
@DISPID(1588)
@PropGet
boolean fetchedRowOverflow();
/**
*
* Getter method for the COM property "BackgroundQuery"
*
*/
@DISPID(1427)
@PropGet
boolean backgroundQuery();
/**
*
* Setter method for the COM property "BackgroundQuery"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1427)
@PropPut
void backgroundQuery(
boolean rhs);
/**
*/
@DISPID(1589)
void cancelRefresh();
/**
*
* Getter method for the COM property "RefreshStyle"
*
*/
@DISPID(1590)
@PropGet
net.rgielen.com4j.office2010.excel.XlCellInsertionMode refreshStyle();
/**
*
* Setter method for the COM property "RefreshStyle"
*
* @param rhs Mandatory net.rgielen.com4j.office2010.excel.XlCellInsertionMode parameter.
*/
@DISPID(1590)
@PropPut
void refreshStyle(
net.rgielen.com4j.office2010.excel.XlCellInsertionMode rhs);
/**
*
* Getter method for the COM property "EnableRefresh"
*
*/
@DISPID(1477)
@PropGet
boolean enableRefresh();
/**
*
* Setter method for the COM property "EnableRefresh"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1477)
@PropPut
void enableRefresh(
boolean rhs);
/**
*
* Getter method for the COM property "SavePassword"
*
*/
@DISPID(1481)
@PropGet
boolean savePassword();
/**
*
* Setter method for the COM property "SavePassword"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1481)
@PropPut
void savePassword(
boolean rhs);
/**
*
* Getter method for the COM property "Destination"
*
*/
@DISPID(681)
@PropGet
net.rgielen.com4j.office2010.excel.Range destination();
/**
*
* Getter method for the COM property "Connection"
*
*/
@DISPID(1432)
@PropGet
java.lang.Object connection();
/**
*
* Setter method for the COM property "Connection"
*
* @param rhs Mandatory java.lang.Object parameter.
*/
@DISPID(1432)
@PropPut
void connection(
java.lang.Object rhs);
/**
*
* Getter method for the COM property "Sql"
*
*/
@DISPID(1480)
@PropGet
java.lang.Object sql();
/**
*
* Setter method for the COM property "Sql"
*
* @param rhs Mandatory java.lang.Object parameter.
*/
@DISPID(1480)
@PropPut
void sql(
java.lang.Object rhs);
/**
*
* Getter method for the COM property "PostText"
*
*/
@DISPID(1591)
@PropGet
java.lang.String postText();
/**
*
* Setter method for the COM property "PostText"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1591)
@PropPut
void postText(
java.lang.String rhs);
/**
*
* Getter method for the COM property "ResultRange"
*
*/
@DISPID(1592)
@PropGet
net.rgielen.com4j.office2010.excel.Range resultRange();
/**
*/
@DISPID(117)
void delete();
/**
* @param backgroundQuery Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(1417)
boolean refresh(
@Optional java.lang.Object backgroundQuery);
/**
*
* Getter method for the COM property "Parameters"
*
*/
@DISPID(1593)
@PropGet
net.rgielen.com4j.office2010.excel.Parameters parameters();
/**
*
* Getter method for the COM property "Recordset"
*
*/
@DISPID(1165)
@PropGet
com4j.Com4jObject recordset();
/**
*
* Setter method for the COM property "Recordset"
*
* @param rhs Mandatory com4j.Com4jObject parameter.
*/
@DISPID(1165)
@PropPut
void recordset(
com4j.Com4jObject rhs);
/**
*
* Getter method for the COM property "SaveData"
*
*/
@DISPID(692)
@PropGet
boolean saveData();
/**
*
* Setter method for the COM property "SaveData"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(692)
@PropPut
void saveData(
boolean rhs);
/**
*
* Getter method for the COM property "TablesOnlyFromHTML"
*
*/
@DISPID(1594)
@PropGet
boolean tablesOnlyFromHTML();
/**
*
* Setter method for the COM property "TablesOnlyFromHTML"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1594)
@PropPut
void tablesOnlyFromHTML(
boolean rhs);
/**
*
* Getter method for the COM property "EnableEditing"
*
*/
@DISPID(1595)
@PropGet
boolean enableEditing();
/**
*
* Setter method for the COM property "EnableEditing"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1595)
@PropPut
void enableEditing(
boolean rhs);
/**
*
* Getter method for the COM property "TextFilePlatform"
*
*/
@DISPID(1855)
@PropGet
int textFilePlatform();
/**
*
* Setter method for the COM property "TextFilePlatform"
*
* @param rhs Mandatory int parameter.
*/
@DISPID(1855)
@PropPut
void textFilePlatform(
int rhs);
/**
*
* Getter method for the COM property "TextFileStartRow"
*
*/
@DISPID(1856)
@PropGet
int textFileStartRow();
/**
*
* Setter method for the COM property "TextFileStartRow"
*
* @param rhs Mandatory int parameter.
*/
@DISPID(1856)
@PropPut
void textFileStartRow(
int rhs);
/**
*
* Getter method for the COM property "TextFileParseType"
*
*/
@DISPID(1857)
@PropGet
net.rgielen.com4j.office2010.excel.XlTextParsingType textFileParseType();
/**
*
* Setter method for the COM property "TextFileParseType"
*
* @param rhs Mandatory net.rgielen.com4j.office2010.excel.XlTextParsingType parameter.
*/
@DISPID(1857)
@PropPut
void textFileParseType(
net.rgielen.com4j.office2010.excel.XlTextParsingType rhs);
/**
*
* Getter method for the COM property "TextFileTextQualifier"
*
*/
@DISPID(1858)
@PropGet
net.rgielen.com4j.office2010.excel.XlTextQualifier textFileTextQualifier();
/**
*
* Setter method for the COM property "TextFileTextQualifier"
*
* @param rhs Mandatory net.rgielen.com4j.office2010.excel.XlTextQualifier parameter.
*/
@DISPID(1858)
@PropPut
void textFileTextQualifier(
net.rgielen.com4j.office2010.excel.XlTextQualifier rhs);
/**
*
* Getter method for the COM property "TextFileConsecutiveDelimiter"
*
*/
@DISPID(1859)
@PropGet
boolean textFileConsecutiveDelimiter();
/**
*
* Setter method for the COM property "TextFileConsecutiveDelimiter"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1859)
@PropPut
void textFileConsecutiveDelimiter(
boolean rhs);
/**
*
* Getter method for the COM property "TextFileTabDelimiter"
*
*/
@DISPID(1860)
@PropGet
boolean textFileTabDelimiter();
/**
*
* Setter method for the COM property "TextFileTabDelimiter"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1860)
@PropPut
void textFileTabDelimiter(
boolean rhs);
/**
*
* Getter method for the COM property "TextFileSemicolonDelimiter"
*
*/
@DISPID(1861)
@PropGet
boolean textFileSemicolonDelimiter();
/**
*
* Setter method for the COM property "TextFileSemicolonDelimiter"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1861)
@PropPut
void textFileSemicolonDelimiter(
boolean rhs);
/**
*
* Getter method for the COM property "TextFileCommaDelimiter"
*
*/
@DISPID(1862)
@PropGet
boolean textFileCommaDelimiter();
/**
*
* Setter method for the COM property "TextFileCommaDelimiter"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1862)
@PropPut
void textFileCommaDelimiter(
boolean rhs);
/**
*
* Getter method for the COM property "TextFileSpaceDelimiter"
*
*/
@DISPID(1863)
@PropGet
boolean textFileSpaceDelimiter();
/**
*
* Setter method for the COM property "TextFileSpaceDelimiter"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1863)
@PropPut
void textFileSpaceDelimiter(
boolean rhs);
/**
*
* Getter method for the COM property "TextFileOtherDelimiter"
*
*/
@DISPID(1864)
@PropGet
java.lang.String textFileOtherDelimiter();
/**
*
* Setter method for the COM property "TextFileOtherDelimiter"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1864)
@PropPut
void textFileOtherDelimiter(
java.lang.String rhs);
/**
*
* Getter method for the COM property "TextFileColumnDataTypes"
*
*/
@DISPID(1865)
@PropGet
java.lang.Object textFileColumnDataTypes();
/**
*
* Setter method for the COM property "TextFileColumnDataTypes"
*
* @param rhs Mandatory java.lang.Object parameter.
*/
@DISPID(1865)
@PropPut
void textFileColumnDataTypes(
java.lang.Object rhs);
/**
*
* Getter method for the COM property "TextFileFixedColumnWidths"
*
*/
@DISPID(1866)
@PropGet
java.lang.Object textFileFixedColumnWidths();
/**
*
* Setter method for the COM property "TextFileFixedColumnWidths"
*
* @param rhs Mandatory java.lang.Object parameter.
*/
@DISPID(1866)
@PropPut
void textFileFixedColumnWidths(
java.lang.Object rhs);
/**
*
* Getter method for the COM property "PreserveColumnInfo"
*
*/
@DISPID(1867)
@PropGet
boolean preserveColumnInfo();
/**
*
* Setter method for the COM property "PreserveColumnInfo"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1867)
@PropPut
void preserveColumnInfo(
boolean rhs);
/**
*
* Getter method for the COM property "PreserveFormatting"
*
*/
@DISPID(1500)
@PropGet
boolean preserveFormatting();
/**
*
* Setter method for the COM property "PreserveFormatting"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1500)
@PropPut
void preserveFormatting(
boolean rhs);
/**
*
* Getter method for the COM property "AdjustColumnWidth"
*
*/
@DISPID(1868)
@PropGet
boolean adjustColumnWidth();
/**
*
* Setter method for the COM property "AdjustColumnWidth"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1868)
@PropPut
void adjustColumnWidth(
boolean rhs);
/**
*
* Getter method for the COM property "CommandText"
*
*/
@DISPID(1829)
@PropGet
java.lang.Object commandText();
/**
*
* Setter method for the COM property "CommandText"
*
* @param rhs Mandatory java.lang.Object parameter.
*/
@DISPID(1829)
@PropPut
void commandText(
java.lang.Object rhs);
/**
*
* Getter method for the COM property "CommandType"
*
*/
@DISPID(1830)
@PropGet
net.rgielen.com4j.office2010.excel.XlCmdType commandType();
/**
*
* Setter method for the COM property "CommandType"
*
* @param rhs Mandatory net.rgielen.com4j.office2010.excel.XlCmdType parameter.
*/
@DISPID(1830)
@PropPut
void commandType(
net.rgielen.com4j.office2010.excel.XlCmdType rhs);
/**
*
* Getter method for the COM property "TextFilePromptOnRefresh"
*
*/
@DISPID(1869)
@PropGet
boolean textFilePromptOnRefresh();
/**
*
* Setter method for the COM property "TextFilePromptOnRefresh"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1869)
@PropPut
void textFilePromptOnRefresh(
boolean rhs);
/**
*
* Getter method for the COM property "QueryType"
*
*/
@DISPID(1831)
@PropGet
net.rgielen.com4j.office2010.excel.XlQueryType queryType();
/**
*
* Getter method for the COM property "MaintainConnection"
*
*/
@DISPID(1832)
@PropGet
boolean maintainConnection();
/**
*
* Setter method for the COM property "MaintainConnection"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1832)
@PropPut
void maintainConnection(
boolean rhs);
/**
*
* Getter method for the COM property "TextFileDecimalSeparator"
*
*/
@DISPID(1870)
@PropGet
java.lang.String textFileDecimalSeparator();
/**
*
* Setter method for the COM property "TextFileDecimalSeparator"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1870)
@PropPut
void textFileDecimalSeparator(
java.lang.String rhs);
/**
*
* Getter method for the COM property "TextFileThousandsSeparator"
*
*/
@DISPID(1871)
@PropGet
java.lang.String textFileThousandsSeparator();
/**
*
* Setter method for the COM property "TextFileThousandsSeparator"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1871)
@PropPut
void textFileThousandsSeparator(
java.lang.String rhs);
/**
*
* Getter method for the COM property "RefreshPeriod"
*
*/
@DISPID(1833)
@PropGet
int refreshPeriod();
/**
*
* Setter method for the COM property "RefreshPeriod"
*
* @param rhs Mandatory int parameter.
*/
@DISPID(1833)
@PropPut
void refreshPeriod(
int rhs);
/**
*/
@DISPID(1834)
void resetTimer();
/**
*
* Getter method for the COM property "WebSelectionType"
*
*/
@DISPID(1872)
@PropGet
net.rgielen.com4j.office2010.excel.XlWebSelectionType webSelectionType();
/**
*
* Setter method for the COM property "WebSelectionType"
*
* @param rhs Mandatory net.rgielen.com4j.office2010.excel.XlWebSelectionType parameter.
*/
@DISPID(1872)
@PropPut
void webSelectionType(
net.rgielen.com4j.office2010.excel.XlWebSelectionType rhs);
/**
*
* Getter method for the COM property "WebFormatting"
*
*/
@DISPID(1873)
@PropGet
net.rgielen.com4j.office2010.excel.XlWebFormatting webFormatting();
/**
*
* Setter method for the COM property "WebFormatting"
*
* @param rhs Mandatory net.rgielen.com4j.office2010.excel.XlWebFormatting parameter.
*/
@DISPID(1873)
@PropPut
void webFormatting(
net.rgielen.com4j.office2010.excel.XlWebFormatting rhs);
/**
*
* Getter method for the COM property "WebTables"
*
*/
@DISPID(1874)
@PropGet
java.lang.String webTables();
/**
*
* Setter method for the COM property "WebTables"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(1874)
@PropPut
void webTables(
java.lang.String rhs);
/**
*
* Getter method for the COM property "WebPreFormattedTextToColumns"
*
*/
@DISPID(1875)
@PropGet
boolean webPreFormattedTextToColumns();
/**
*
* Setter method for the COM property "WebPreFormattedTextToColumns"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1875)
@PropPut
void webPreFormattedTextToColumns(
boolean rhs);
/**
*
* Getter method for the COM property "WebSingleBlockTextImport"
*
*/
@DISPID(1876)
@PropGet
boolean webSingleBlockTextImport();
/**
*
* Setter method for the COM property "WebSingleBlockTextImport"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1876)
@PropPut
void webSingleBlockTextImport(
boolean rhs);
/**
*
* Getter method for the COM property "WebDisableDateRecognition"
*
*/
@DISPID(1877)
@PropGet
boolean webDisableDateRecognition();
/**
*
* Setter method for the COM property "WebDisableDateRecognition"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1877)
@PropPut
void webDisableDateRecognition(
boolean rhs);
/**
*
* Getter method for the COM property "WebConsecutiveDelimitersAsOne"
*
*/
@DISPID(1878)
@PropGet
boolean webConsecutiveDelimitersAsOne();
/**
*
* Setter method for the COM property "WebConsecutiveDelimitersAsOne"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(1878)
@PropPut
void webConsecutiveDelimitersAsOne(
boolean rhs);
/**
*
* Getter method for the COM property "WebDisableRedirections"
*
*/
@DISPID(2162)
@PropGet
boolean webDisableRedirections();
/**
*
* Setter method for the COM property "WebDisableRedirections"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2162)
@PropPut
void webDisableRedirections(
boolean rhs);
/**
*
* Getter method for the COM property "EditWebPage"
*
*/
@DISPID(2163)
@PropGet
java.lang.Object editWebPage();
/**
*
* Setter method for the COM property "EditWebPage"
*
* @param rhs Mandatory java.lang.Object parameter.
*/
@DISPID(2163)
@PropPut
void editWebPage(
java.lang.Object rhs);
/**
*
* Getter method for the COM property "SourceConnectionFile"
*
*/
@DISPID(2079)
@PropGet
java.lang.String sourceConnectionFile();
/**
*
* Setter method for the COM property "SourceConnectionFile"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(2079)
@PropPut
void sourceConnectionFile(
java.lang.String rhs);
/**
*
* Getter method for the COM property "SourceDataFile"
*
*/
@DISPID(2080)
@PropGet
java.lang.String sourceDataFile();
/**
*
* Setter method for the COM property "SourceDataFile"
*
* @param rhs Mandatory java.lang.String parameter.
*/
@DISPID(2080)
@PropPut
void sourceDataFile(
java.lang.String rhs);
/**
*
* Getter method for the COM property "RobustConnect"
*
*/
@DISPID(2081)
@PropGet
net.rgielen.com4j.office2010.excel.XlRobustConnect robustConnect();
/**
*
* Setter method for the COM property "RobustConnect"
*
* @param rhs Mandatory net.rgielen.com4j.office2010.excel.XlRobustConnect parameter.
*/
@DISPID(2081)
@PropPut
void robustConnect(
net.rgielen.com4j.office2010.excel.XlRobustConnect rhs);
/**
*
* Getter method for the COM property "TextFileTrailingMinusNumbers"
*
*/
@DISPID(2164)
@PropGet
boolean textFileTrailingMinusNumbers();
/**
*
* Setter method for the COM property "TextFileTrailingMinusNumbers"
*
* @param rhs Mandatory boolean parameter.
*/
@DISPID(2164)
@PropPut
void textFileTrailingMinusNumbers(
boolean rhs);
/**
* @param odcFileName Mandatory java.lang.String parameter.
* @param description Optional parameter. Default value is com4j.Variant.getMissing()
* @param keywords Optional parameter. Default value is com4j.Variant.getMissing()
*/
@DISPID(2082)
void saveAsODC(
java.lang.String odcFileName,
@Optional java.lang.Object description,
@Optional java.lang.Object keywords);
/**
*
* Getter method for the COM property "ListObject"
*
*/
@DISPID(2257)
@PropGet
net.rgielen.com4j.office2010.excel.ListObject listObject();
/**
*
* Getter method for the COM property "TextFileVisualLayout"
*
*/
@DISPID(2245)
@PropGet
net.rgielen.com4j.office2010.excel.XlTextVisualLayoutType textFileVisualLayout();
/**
*
* Setter method for the COM property "TextFileVisualLayout"
*
* @param rhs Mandatory net.rgielen.com4j.office2010.excel.XlTextVisualLayoutType parameter.
*/
@DISPID(2245)
@PropPut
void textFileVisualLayout(
net.rgielen.com4j.office2010.excel.XlTextVisualLayoutType rhs);
/**
*
* Getter method for the COM property "WorkbookConnection"
*
*/
@DISPID(2544)
@PropGet
net.rgielen.com4j.office2010.excel.WorkbookConnection workbookConnection();
/**
*
* Getter method for the COM property "Sort"
*
*/
@DISPID(880)
@PropGet
net.rgielen.com4j.office2010.excel.Sort sort();
// Properties:
}