Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overloads Sub LoadTextFileRange( _ ByVal stream As Stream, _ ByVal cellRange As CellRange, _ ByVal textFileFlags As TextFileFlags, _ 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 cellRange As CellRange Dim textFileFlags As TextFileFlags Dim rowDelimiter As String Dim columnDelimiter As String Dim cellDelimiter As String instance.LoadTextFileRange(stream, cellRange, textFileFlags, rowDelimiter, columnDelimiter, cellDelimiter) | |
| C# | |
|---|---|
public void LoadTextFileRange( Stream stream, CellRange cellRange, TextFileFlags textFileFlags, string rowDelimiter, string columnDelimiter, string cellDelimiter ) | |
Parameters
- stream
- Stream to which to load the text of the sheet
- cellRange
- Specifies range process the data when loading from a text file
- textFileFlags
- Specifies how to process the data when loading from a text file
- rowDelimiter
- Row delimiter string
- columnDelimiter
- Column delimiter string
- cellDelimiter
- Cell delimiter string
Exceptions
| Exception | Description |
|---|---|
| System.ArgumentException | Cell delimiter cannot be contained in a row or column delimiter |
Example
This example uses the LoadTextFileRange method.
| C# | Copy Code |
|---|---|
OpenFileDialog ofd = new OpenFileDialog(); string s; ofd.Filter = "text files (*.txt)|*.txt"; ofd.FilterIndex = 2; ofd.RestoreDirectory = true; if (ofd.ShowDialog() == DialogResult.OK) { s = ofd.FileName; FarPoint.Win.Spread.Model.CellRange cr = new FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3); fpSpread1.ActiveSheet.LoadTextFileRange(s, cr,FarPoint.Win.Spread.TextFileFlags.None); //fpSpread1.ActiveSheet.LoadTextFileRange(s, cr, FarPoint.Win.Spread.TextFileFlags.None, "\r", ",", "", System.Text.Encoding.ASCII); //fpSpread1.ActiveSheet.LoadTextFileRange(s, cr, FarPoint.Win.Spread.TextFileFlags.None, "\r", ",", ""); } | |
| VB.NET | Copy Code |
|---|---|
Dim s As String Dim ofd As New OpenFileDialog() ofd.Filter = "text files (*.txt)|*.txt" ofd.FilterIndex = 2 ofd.RestoreDirectory = True If ofd.ShowDialog() = DialogResult.OK Then s = ofd.FileName Dim cr As New FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3) FpSpread1.ActiveSheet.LoadTextFileRange(s, cr, FarPoint.Win.Spread.TextFileFlags.Unformatted) 'FpSpread1.ActiveSheet.LoadTextFileRange(s, cr, FarPoint.Win.Spread.TextFileFlags.Unformatted, Chr(13), ",", "", System.Text.Encoding.ASCII) 'FpSpread1.ActiveSheet.LoadTextFileRange(s, cr, FarPoint.Win.Spread.TextFileFlags.Unformatted, Chr(13), ",", "") End If | |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8