OpenExcel(Stream,ExcelOpenFlags,String) Method

Visual Basic
C#

'Declaration
 
Public Overloads Sub OpenExcel( _
   ByVal stream As System.IO.Stream, _
   ByVal openFlags As ExcelOpenFlags, _
   ByVal password As System.String _
)

'Usage
 
Dim instance As GcSpreadSheet
Dim stream As System.IO.Stream
Dim openFlags As ExcelOpenFlags
Dim password As System.String
 
instance.OpenExcel(stream, openFlags, password)

public void OpenExcel( 
   System.IO.Stream stream,
   ExcelOpenFlags openFlags,
   System.string password
)

Parameters

stream: The file stream.
openFlags: The flag used to open the file.
password: The file password.

This example uses the OpenExcel method.

C#

OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Excel File (.xlsx)|*.xlsx";
bool? useClick = openFileDialog.ShowDialog();
if (useClick == true)
{
    var stream = openFileDialog.File.OpenRead();
    stream.Seek(0, System.IO.SeekOrigin.Begin);
     gcSpreadSheet1.OpenExcel(stream);
    //gcSpreadSheet1.OpenExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.DataOnly);
    //gcSpreadSheet1.OpenExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.DataOnly, "12Test9");
    //gcSpreadSheet1.OpenExcel(stream, "12Test9");
    stream.Dispose();
}

VB.NET

Dim openFileDialog = New OpenFileDialog()
openFileDialog.Filter = "Excel File(.xlsx)|*.xlsx"
Dim useClick As Boolean = openFileDialog.ShowDialog()
If (useClick = True) Then
    Dim stream = openFileDialog.File.OpenRead()
    stream.Seek(0, IO.SeekOrigin.Begin)
    GcSpreadSheet1.OpenExcel(stream)
    'GcSpreadSheet1.OpenExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.DataOnly)
    'GcSpreadSheet1.OpenExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.DataOnly, "12Test9")
    'GcSpreadSheet1.OpenExcel(stream, "12Test9")
End If

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

Reference

GcSpreadSheet Class
GcSpreadSheet Members
Overload List