다음을 통해 공유

QueryTableClass Members

  • 아티클

Include Protected Members
Include Inherited Members

Reserved for internal use.

The QueryTableClass type exposes the following members.

Constructors

  Name Description
Public method QueryTableClass

Top

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 add_AfterRefresh
Public method add_BeforeRefresh
Public method CancelRefresh
Public method Delete
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method Refresh
Public method remove_AfterRefresh
Public method remove_BeforeRefresh
Public method ResetTimer
Public method SaveAsODC
Public method ToString (Inherited from Object.)

Top

Events

  Name Description
Public event AfterRefresh
Public event BeforeRefresh

Top

See Also

Reference

QueryTableClass Class

Microsoft.Office.Interop.Excel Namespace