LoadTextFileRange(Stream,CellRange,TextFileFlags) Method

Visual Basic
C#

'Declaration
 
Public Overloads Sub LoadTextFileRange( _
   ByVal stream As Stream, _
   ByVal cellRange As CellRange, _
   ByVal textFileFlags As TextFileFlags _
)

'Usage
 
Dim instance As SheetView
Dim stream As Stream
Dim cellRange As CellRange
Dim textFileFlags As TextFileFlags
 
instance.LoadTextFileRange(stream, cellRange, textFileFlags)

public void LoadTextFileRange( 
   Stream stream,
   CellRange cellRange,
   TextFileFlags textFileFlags
)

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

This example uses the LoadTextFileRange method.

C#

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

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

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SheetView Class
SheetView Members
Overload List