Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overloads Sub LoadTextFile( _ ByVal stream As Stream, _ 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 _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SheetView Dim stream As Stream 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(stream, unformatted, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter, encoding, loadFormulas) | |
| C# | |
|---|---|
public void LoadTextFile( Stream stream, bool unformatted, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding, bool loadFormulas ) | |
Parameters
- stream
- Stream 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.
| 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