編輯

共用方式為


QueryTableClass Class

Definition

Reserved for internal use.

public ref class QueryTableClass : Microsoft::Office::Interop::Excel::QueryTable
[System.Runtime.InteropServices.ClassInterface(0)]
[System.Runtime.InteropServices.Guid("59191DA1-EA47-11CE-A51F-00AA0061507F")]
public class QueryTableClass : Microsoft.Office.Interop.Excel.QueryTable
Public Class QueryTableClass
Implements QueryTable
Inheritance
QueryTableClass
Attributes
Implements

Constructors

QueryTableClass()

Properties

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

Methods

CancelRefresh()
Delete()
Refresh(Object)
ResetTimer()
SaveAsODC(String, Object, Object)

Events

AfterRefresh
BeforeRefresh

Applies to