Spread Windows Forms 8.0 Product Documentation
LoadTextFileRange(String,CellRange,TextFileFlags) Method
Example 


Path and name of the file to load
Specifies range process the data when loading from a text file
Specifies how to process the data when loading from a text file
Loads delimited text from a specified file into the sheet.
Syntax
'Declaration
 
Public Overloads Sub LoadTextFileRange( _
   ByVal fileName As String, _
   ByVal cellRange As CellRange, _
   ByVal textFileFlags As TextFileFlags _
) 
'Usage
 
Dim instance As SheetView
Dim fileName As String
Dim cellRange As CellRange
Dim textFileFlags As TextFileFlags
 
instance.LoadTextFileRange(fileName, cellRange, textFileFlags)
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
Example
This example uses the LoadTextFileRange method.
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);
}
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
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

See Also

Reference

SheetView Class
SheetView Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.