Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / LoadTextFile Method / LoadTextFile(String,Boolean,IncludeHeaders,String,String,String,Encoding,Boolean) Method
Path and name of the file from which to load the sheet
Whether to load the data unformatted
Which header cells to load data from
Row delimiter string
Column delimiter string
Cell delimiter string
Encoding
Whether to load formulas
Example


In This Topic
    LoadTextFile(String,Boolean,IncludeHeaders,String,String,String,Encoding,Boolean) Method
    In This Topic
    Loads a text file with data (and perhaps headers) into the sheet with the specified delimiters.
    Syntax
    'Declaration
     
    Public Overloads Sub LoadTextFile( _
       ByVal fileName As String, _
       ByVal unformatted As Boolean, _
       ByVal includeHeaders As IncludeHeaders, _
       ByVal rowDelimiter As String, _
       ByVal columnDelimiter As String, _
       ByVal cellDelimiter As String, _
       ByVal encoding As Encoding, _
       ByVal loadFormulas As Boolean _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim fileName As String
    Dim unformatted As Boolean
    Dim includeHeaders As IncludeHeaders
    Dim rowDelimiter As String
    Dim columnDelimiter As String
    Dim cellDelimiter As String
    Dim encoding As Encoding
    Dim loadFormulas As Boolean
     
    instance.LoadTextFile(fileName, unformatted, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter, encoding, loadFormulas)
    public void LoadTextFile( 
       string fileName,
       bool unformatted,
       IncludeHeaders includeHeaders,
       string rowDelimiter,
       string columnDelimiter,
       string cellDelimiter,
       Encoding encoding,
       bool loadFormulas
    )

    Parameters

    fileName
    Path and name of the file from which to load the sheet
    unformatted
    Whether to load the data unformatted
    includeHeaders
    Which header cells to load data from
    rowDelimiter
    Row delimiter string
    columnDelimiter
    Column delimiter string
    cellDelimiter
    Cell delimiter string
    encoding
    Encoding
    loadFormulas
    Whether to load formulas
    Example
    This example uses the LoadTextFile method.
    FpSpread1.Sheets[0].LoadTextFile("c:\\controls\\textfile1.txt", true, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^");
    //FpSpread1.Sheets[0].LoadTextFile("c:\\controls\\textfile1.txt", true, FarPoint.Web.Spread.Model.IncludeHeaders.None, false, "#", "", "^");
    //FpSpread1.Sheets[0].LoadTextFile("c", "^", System.Text.Encoding.ASCII);
    //FpSpread1.Sheets[0].LoadTextFile("c:\\controls\\textfile1.txt", true, FarPoint.Web.Spread.Model.IncludeHeaders.None, false, "#", "", "^", System.Text.Encoding.ASCII);
    //FpSpread1.Sheets[0].LoadTextFile("c", "^", System.Text.Encoding.ASCII, false);
    //FpSpread1.Sheets[0].LoadTextFile("c:\\controls\\textfile1.txt", true, FarPoint.Web.Spread.Model.IncludeHeaders.None, false, "#", "%", "^", System.Text.Encoding.ASCII, false);
    FpSpread1.Sheets(0).LoadTextFile("c:\controls\textfile1.txt", True, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^")
    'FpSpread1.Sheets(0).LoadTextFile("c:\controls\textfile1.txt", True, FarPoint.Web.Spread.Model.IncludeHeaders.None, False, "#", "", "^")
    'FpSpread1.Sheets(0).LoadTextFile("c", "^", System.Text.Encoding.ASCII)
    'FpSpread1.Sheets(0).LoadTextFile("c:\controls\textfile1.txt", True, FarPoint.Web.Spread.Model.IncludeHeaders.None, False, "#", "", "^", System.Text.Encoding.ASCII)
    'FpSpread1.Sheets(0).LoadTextFile("c", "^", System.Text.Encoding.ASCII, False)
    'FpSpread1.Sheets(0).LoadTextFile("c:\controls\textfile1.txt", True, FarPoint.Web.Spread.Model.IncludeHeaders.None, False, "#", "%", "^", System.Text.Encoding.ASCII, False)
    See Also