Partager via


_QueryTable.TextFileStartRow Property

Returns or sets the row number at which text parsing will begin when you import a text file into a query table. Valid values are integers from 1 through 32,767. The default value is 1. Read/write Integer.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property TextFileStartRow As Integer
    Get
    Set
'Usage
Dim instance As _QueryTable
Dim value As Integer

value = instance.TextFileStartRow

instance.TextFileStartRow = value
int TextFileStartRow { get; set; }

Property Value

Type: System.Int32

Remarks

Use this property only when your query table is based on data from a text file (with the QueryType property set to xlTextImport).

See Also

Reference

_QueryTable Interface

_QueryTable Members

Microsoft.Office.Interop.Excel Namespace