Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overloads Sub LoadTextFile( _ ByVal stream As Stream, _ ByVal unformatted As Boolean, _ ByVal includeHeaders As IncludeHeaders, _ ByVal includeFooter As Boolean, _ ByVal rowDelimiter As String, _ ByVal columnDelimiter As String, _ ByVal cellDelimiter As String _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SheetView Dim stream As Stream Dim unformatted As Boolean Dim includeHeaders As IncludeHeaders Dim includeFooter As Boolean Dim rowDelimiter As String Dim columnDelimiter As String Dim cellDelimiter As String instance.LoadTextFile(stream, unformatted, includeHeaders, includeFooter, rowDelimiter, columnDelimiter, cellDelimiter) | |
| C# | |
|---|---|
public void LoadTextFile( Stream stream, bool unformatted, IncludeHeaders includeHeaders, bool includeFooter, string rowDelimiter, string columnDelimiter, string cellDelimiter ) | |
Parameters
- stream
- Stream from which to load the sheet
- unformatted
- Whether to load the data unformatted
- includeHeaders
- Which header cells to load data from
- includeFooter
- Whether to load the data from the footer cells
- rowDelimiter
- Row delimiter string
- columnDelimiter
- Column delimiter string
- cellDelimiter
- Cell delimiter string
Example
This example uses the LoadTextFile method.
| C# | Copy Code |
|---|---|
System.IO.Stream s; s = System.IO.File.Open("C:\\controls\\textfile1.txt", System.IO.FileMode.Open); FpSpread1.Sheets[0].LoadTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^"); //FpSpread1.Sheets[0].LoadTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, false, "#", "%", "^"); //FpSpread1.Sheets[0].LoadTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^", System.Text.Encoding.ASCII); //FpSpread1.Sheets[0].LoadTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, false, "#", "%", "^", System.Text.Encoding.ASCII); //FpSpread1.Sheets[0].LoadTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^", System.Text.Encoding.ASCII, false); //FpSpread1.Sheets[0].LoadTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, false, "#", "%", "^", System.Text.Encoding.ASCII, false); | |
| VB.NET | Copy Code |
|---|---|
Dim s As System.IO.Stream s = System.IO.File.Open("C:\\controls\\textfile1.txt", System.IO.FileMode.Open) FpSpread1.Sheets(0).LoadTextFile(s, True, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^") 'FpSpread1.Sheets(0).LoadTextFile(s, True, FarPoint.Web.Spread.Model.IncludeHeaders.None, False, "#", "%", "^") 'FpSpread1.Sheets(0).LoadTextFile(s, True, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^", System.Text.Encoding.ASCII) 'FpSpread1.Sheets(0).LoadTextFile(s, True, FarPoint.Web.Spread.Model.IncludeHeaders.None, False, "#", "%", "^", System.Text.Encoding.ASCII) 'FpSpread1.Sheets(0).LoadTextFile(s, True, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^", System.Text.Encoding.ASCII, False) 'FpSpread1.Sheets(0).LoadTextFile(s, True, FarPoint.Web.Spread.Model.IncludeHeaders.None, False, "#", "%", "^", System.Text.Encoding.ASCII, False) | |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6