FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class > LoadTextFile Method : LoadTextFile(Stream,TextFileFlags,IncludeHeaders,String,String,String) Method |
'Declaration Public Overloads Sub LoadTextFile( _ ByVal stream As Stream, _ ByVal textFileFlags As TextFileFlags, _ ByVal includeHeaders As IncludeHeaders, _ ByVal rowDelimiter As String, _ ByVal columnDelimiter As String, _ ByVal cellDelimiter As String _ )
'Usage Dim instance As SheetView Dim stream As Stream Dim textFileFlags As TextFileFlags Dim includeHeaders As IncludeHeaders Dim rowDelimiter As String Dim columnDelimiter As String Dim cellDelimiter As String instance.LoadTextFile(stream, textFileFlags, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter)
public void LoadTextFile( Stream stream, TextFileFlags textFileFlags, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter )
Exception | Description |
---|---|
System.ArgumentException | Cell delimiter cannot be contained in a row or column delimiter |
OpenFileDialog ofd = new OpenFileDialog(); System.IO.Stream s; ofd.Filter = "text files (*.txt)|*.txt"; ofd.FilterIndex = 2; ofd.RestoreDirectory = true; if (ofd.ShowDialog() == DialogResult.OK) { s = ofd.OpenFile(); fpSpread1.ActiveSheet.LoadTextFile(s, FarPoint.Win.Spread.TextFileFlags.Unformatted, FarPoint.Win.Spread.Model.IncludeHeaders.None, "\n", ",", ""); s.Close(); }
Dim s As System.IO.Stream 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.OpenFile FpSpread1.ActiveSheet.LoadTextFile(s, FarPoint.Win.Spread.TextFileFlags.Unformatted, FarPoint.Win.Spread.Model.IncludeHeaders.None, Chr(10), ",", "") s.Close() 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