OpenTextFile Method (GcSpreadSheet)

Visual Basic
C#

'Declaration
 
Public Sub OpenTextFile( _
   ByVal sheetIndex As System.Integer, _
   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 GcSpreadSheet
Dim sheetIndex As System.Integer
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(sheetIndex, stream, flags, rowDelimiter, columnDelimiter, cellDelimiter)

public void OpenTextFile( 
   System.int sheetIndex,
   System.IO.Stream stream,
   TextFileOpenFlags flags,
   System.string rowDelimiter,
   System.string columnDelimiter,
   System.string cellDelimiter
)

Parameters

sheetIndex: The destination sheet index for loading.
stream: Stream from which to load.
flags: The import flags.
rowDelimiter: Row delimiter string.
columnDelimiter: Column delimiter string.
cellDelimiter: Cell delimiter string.

This example uses the OpenTextFile method.

C#

System.IO.Stream stream;
stream = System.IO.File.Open("c:\\zipfile\\savespreadstream.csv", System.IO.FileMode.Open);
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.ASCII);
//gcSpreadSheet1.OpenTextFile(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, "\r", ",", "");

VB.NET

Dim stream As System.IO.Stream
stream = System.IO.File.Open("c:\zipfile\savespreadstream.csv", System.IO.FileMode.Open)
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.ASCII)
'GcSpreadSheet1.OpenTextFile(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, Chr(13), ",", "")

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

GcSpreadSheet Class
GcSpreadSheet Members