Syntax
| Visual Basic (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 _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
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) | |
| C# | |
|---|---|
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.
| C# | Copy Code |
|---|---|
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); | |
| VB.NET | Copy Code |
|---|---|
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) | |
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