How to: Programmatically Open Text Files as Workbooks

Cikk
04/28/2015

You can open a text file as a workbook. You must pass in the name of the text file you want to open. You can specify several optional parameters, such as which row number to start parsing on and the column format of the data in the file.

Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2013 and Excel 2010. For more information, see Features Available by Office Application and Project Type.

Example

Me.Application.Workbooks.OpenText("C:\Test.txt", _
    StartRow:=3, _
    DataType:=Excel.XlTextParsingType.xlDelimited, _
    TextQualifier:=Excel.XlTextQualifier.xlTextQualifierNone, _
    Comma:=True)

this.Application.Workbooks.OpenText(@"C:\Test.txt",
    missing, 3,
    Excel.XlTextParsingType.xlDelimited,
    Excel.XlTextQualifier.xlTextQualifierNone,
    missing, missing, missing, true, missing, missing, missing, 
    missing, missing, missing, missing, missing, missing);

Compiling the Code

This example requires the following components:

A comma-delimited text file named Test.txt that contains at least three lines of text.
The text file Test.txt to be stored on drive C.

Megosztás a következőn keresztül:

How to: Programmatically Open Text Files as Workbooks

Example

Compiling the Code

See Also

Tasks

Concepts

További források