Spread Windows Forms 7.0 Product Documentation
LoadTextFile(String,TextFileFlags) Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class > LoadTextFile Method : LoadTextFile(String,TextFileFlags) Method


fileName
Path and name of the file to load
textFileFlags
Specifies how to process the data when loading from a text file

Glossary Item Box

Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding.

Syntax

Visual Basic (Declaration) 
Public Overloads Sub LoadTextFile( _
   ByVal fileName As String, _
   ByVal textFileFlags As TextFileFlags _
) 
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim fileName As String
Dim textFileFlags As TextFileFlags
 
instance.LoadTextFile(fileName, textFileFlags)
C# 
public void LoadTextFile( 
   string fileName,
   TextFileFlags textFileFlags
)

Parameters

fileName
Path and name of the file to load
textFileFlags
Specifies how to process the data when loading from a text file

Example

This example loads a text file.
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;
   fpSpread1.ActiveSheet.LoadTextFile(s, true);
}
Visual BasicCopy 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
 FpSpread1.ActiveSheet.LoadTextFile(s, FarPoint.Win.Spread.TextFileFlags.Unformatted)
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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.