Spread WPF Documentation
OpenCsv(String,TextFileOpenFlags,Encoding) Method
Example 


The path and name of the file to load.
The flags.
The encoding.
Loads the CSV (comma-separated values) file.
Syntax
'Declaration
 
Public Overloads Sub OpenCsv( _
   ByVal fileName As System.String, _
   ByVal flags As TextFileOpenFlags, _
   ByVal encoding As System.Text.Encoding _
) 
'Usage
 
Dim instance As Worksheet
Dim fileName As System.String
Dim flags As TextFileOpenFlags
Dim encoding As System.Text.Encoding
 
instance.OpenCsv(fileName, flags, encoding)
public void OpenCsv( 
   System.string fileName,
   TextFileOpenFlags flags,
   System.Text.Encoding encoding
)

Parameters

fileName
The path and name of the file to load.
flags
The flags.
encoding
The encoding.
Example
This example uses the OpenCsv method.
gcSpreadSheet1.OpenCSV(0, "c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None);
//cSpreadSheet1.OpenCSV(0, "c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, System.Text.Encoding.UTF8);
//gcSpreadSheet1.Sheets[0].OpenCsv("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None);
//gcSpreadSheet1.Sheets[0].OpenCsv("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, System.Text.Encoding.UTF8);
GcSpreadSheet1.OpenCSV(0, "c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None)
'GcSpreadSheet1.OpenCSV(0, "c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, System.Text.Encoding.UTF8)
'GcSpreadSheet1.Sheets(0).OpenCsv("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None)
'GcSpreadSheet1.Sheets(0).OpenCsv("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, System.Text.Encoding.UTF8)
Requirements

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)

See Also

Reference

Worksheet Class
Worksheet Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.