Spread WPF Documentation
OpenExcel(String,ExcelOpenFlags) Method
Example 


GrapeCity.Windows.SpreadSheet.UI Namespace > GcSpreadSheet Class > OpenExcel Method : OpenExcel(String,ExcelOpenFlags) Method
The path to load the file from.
The flags used to open the file.
Opens an Excel Compound Document File and loads it into GcSpreadSheet.
Syntax
'Declaration
 
Public Overloads Sub OpenExcel( _
   ByVal file As System.String, _
   ByVal openFlags As ExcelOpenFlags _
) 
'Usage
 
Dim instance As GcSpreadSheet
Dim file As System.String
Dim openFlags As ExcelOpenFlags
 
instance.OpenExcel(file, openFlags)
public void OpenExcel( 
   System.string file,
   ExcelOpenFlags openFlags
)

Parameters

file
The path to load the file from.
openFlags
The flags used to open the file.
Example
This example uses the OpenExcel method.
gcSpreadSheet1.OpenExcel("c:\\zipfile\\test.xlsx");
//gcSpreadSheet1.OpenExcel("c:\\zipfile\\test.xlsx", "1NaMe5");
//gcSpreadSheet1.OpenExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.DataAndFormulasOnly, "1NaMe5");
//gcSpreadSheet1.OpenExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.RowAndColumnHeaders);
GcSpreadSheet1.OpenExcel("c:\zipfile\test.xlsx")
'GcSpreadSheet1.OpenExcel("c:\zipfile\test.xlsx", "1NaMe5")
'GcSpreadSheet1.OpenExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.DataAndFormulasOnly, "1NaMe5")
'GcSpreadSheet1.OpenExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.RowAndColumnHeaders)
See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members
Overload List