共用方式為

_IQueryTable Members

  • 發行項

Include Protected Members
Include Inherited Members

Reserved for internal use.

The _IQueryTable type exposes the following members.

Properties

  Name Description
Public property AdjustColumnWidth
Public property Application
Public property BackgroundQuery
Public property CommandText
Public property CommandType
Public property Connection
Public property Creator
Public property Destination
Public property EditWebPage
Public property EnableEditing
Public property EnableRefresh
Public property FetchedRowOverflow
Public property FieldNames
Public property FillAdjacentFormulas
Public property HasAutoFormat
Public property ListObject
Public property MaintainConnection
Public property Name
Public property Parameters
Public property Parent
Public property PostText
Public property PreserveColumnInfo
Public property PreserveFormatting
Public property QueryType
Public property Recordset
Public property Refreshing
Public property RefreshOnFileOpen
Public property RefreshPeriod
Public property RefreshStyle
Public property ResultRange
Public property RobustConnect
Public property RowNumbers
Public property SaveData
Public property SavePassword
Public property Sort
Public property SourceConnectionFile
Public property SourceDataFile
Public property Sql
Public property TablesOnlyFromHTML
Public property TextFileColumnDataTypes
Public property TextFileCommaDelimiter
Public property TextFileConsecutiveDelimiter
Public property TextFileDecimalSeparator
Public property TextFileFixedColumnWidths
Public property TextFileOtherDelimiter
Public property TextFileParseType
Public property TextFilePlatform
Public property TextFilePromptOnRefresh
Public property TextFileSemicolonDelimiter
Public property TextFileSpaceDelimiter
Public property TextFileStartRow
Public property TextFileTabDelimiter
Public property TextFileTextQualifier
Public property TextFileThousandsSeparator
Public property TextFileTrailingMinusNumbers
Public property TextFileVisualLayout
Public property WebConsecutiveDelimitersAsOne
Public property WebDisableDateRecognition
Public property WebDisableRedirections
Public property WebFormatting
Public property WebPreFormattedTextToColumns
Public property WebSelectionType
Public property WebSingleBlockTextImport
Public property WebTables
Public property WorkbookConnection

Top

Methods

  Name Description
Public method CancelRefresh
Public method Delete
Public method Refresh
Public method ResetTimer
Public method SaveAsODC

Top

See Also

Reference

_IQueryTable Interface

Microsoft.Office.Interop.Excel Namespace