Visual Basic (Declaration) | |
---|---|
Public Overloads Sub LoadTextFileRange( _ ByVal fileName As String, _ ByVal cellRange As CellRange, _ ByVal textFileFlags As TextFileFlags _ ) |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As SheetView Dim fileName As String Dim cellRange As CellRange Dim textFileFlags As TextFileFlags instance.LoadTextFileRange(fileName, cellRange, textFileFlags) |
C# | |
---|---|
public void LoadTextFileRange( string fileName, CellRange cellRange, TextFileFlags textFileFlags ) |
Parameters
- fileName
- Path and name of the file to load
- 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# | Copy Code |
---|---|
private void button1_Click(object sender, EventArgs e) { fpSpread1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, "c:\\test.txt", FarPoint.Win.Spread.TextFileFlags.IncludeFooter, FarPoint.Win.Spread.Model.IncludeHeaders.None, "\r", ",", ""); } private void Form1_Load(object sender, EventArgs e) { fpSpread1.Sheets[0].Cells[0, 0, 3, 3].Text = "Test"; } private void button2_Click(object sender, EventArgs e) { FarPoint.Win.Spread.Model.CellRange cr = new FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3); fpSpread1.ActiveSheet.LoadTextFileRange("c:\\test.txt", cr, FarPoint.Win.Spread.TextFileFlags.None); } |
VB.NET | Copy Code |
---|---|
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click FpSpread1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, "c:\test.txt", FarPoint.Win.Spread.TextFileFlags.IncludeFooter, FarPoint.Win.Spread.Model.IncludeHeaders.None, Chr(13), ",", "") End Sub Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load FpSpread1.Sheets(0).Cells(0, 0, 3, 3).Text = "Test" End Sub Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click Dim cr As New FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3) FpSpread1.ActiveSheet.LoadTextFileRange("c:\test.txt", cr, FarPoint.Win.Spread.TextFileFlags.None) End Sub |
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8