Spread Silverlight Documentation
OpenExcel(Stream,String) Method
Example 


GrapeCity.Windows.SpreadSheet.UI Namespace > GcSpreadSheet Class > OpenExcel Method : OpenExcel(Stream,String) Method
The file stream.
The file password.
Opens an Excel Compound Document File and loads it into GcSpreadSheet.
Syntax
'Declaration
 
Public Overloads Sub OpenExcel( _
   ByVal stream As System.IO.Stream, _
   ByVal password As System.String _
) 
'Usage
 
Dim instance As GcSpreadSheet
Dim stream As System.IO.Stream
Dim password As System.String
 
instance.OpenExcel(stream, password)
public void OpenExcel( 
   System.IO.Stream stream,
   System.string password
)

Parameters

stream
The file stream.
password
The file password.
Example
This example uses the OpenExcel method.
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();
}
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
See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members
Overload List