Spread Silverlight Documentation
OpenTextFile(Stream,TextFileOpenFlags,String,String,String) Method
Example 


The stream from which to load.
The import flags.
The row delimiter string.
The column delimiter string.
The cell delimiter string.
Loads the CSV file with the specified separator.
Syntax
'Declaration
 
Public Overloads Sub OpenTextFile( _
   ByVal stream As System.IO.Stream, _
   ByVal flags As TextFileOpenFlags, _
   ByVal rowDelimiter As System.String, _
   ByVal columnDelimiter As System.String, _
   ByVal cellDelimiter As System.String _
) 
'Usage
 
Dim instance As Worksheet
Dim stream As System.IO.Stream
Dim flags As TextFileOpenFlags
Dim rowDelimiter As System.String
Dim columnDelimiter As System.String
Dim cellDelimiter As System.String
 
instance.OpenTextFile(stream, flags, rowDelimiter, columnDelimiter, cellDelimiter)
public void OpenTextFile( 
   System.IO.Stream stream,
   TextFileOpenFlags flags,
   System.string rowDelimiter,
   System.string columnDelimiter,
   System.string cellDelimiter
)

Parameters

stream
The stream from which to load.
flags
The import flags.
rowDelimiter
The row delimiter string.
columnDelimiter
The column delimiter string.
cellDelimiter
The cell delimiter string.
Example
This example uses the OpenTextFile method.
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Text File (.txt)|*.txt";
bool? useClick = openFileDialog.ShowDialog();
if (useClick == true)
{
    var stream = openFileDialog.File.OpenRead();
    stream.Seek(0, System.IO.SeekOrigin.Begin);
gcSpreadSheet1.Sheets[0].OpenTextFile(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, "\r", ",", "");
//gcSpreadSheet1.Sheets[0].OpenTextFile(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, "\r", ",", "", System.Text.Encoding.UTF8);
//gcSpreadSheet1.OpenTextFile(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, "\r", ",", "");
stream.Dispose();
}
Dim openFileDialog = New OpenFileDialog()
openFileDialog.Filter = "Text File(.txt)|*.txt"
Dim useClick As Boolean = openFileDialog.ShowDialog()
If (useClick = True) Then
    Dim stream = openFileDialog.File.OpenRead()
    stream.Seek(0, IO.SeekOrigin.Begin)
GcSpreadSheet1.Sheets(0).OpenTextFile(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, Chr(13), ",", "")
'GcSpreadSheet1.Sheets(0).OpenTextFile(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, Chr(13), ",", "", System.Text.Encoding.UTF8)
'GcSpreadSheet1.OpenTextFile(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, Chr(13), ",", "")
End If
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

Worksheet Class
Worksheet Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.