Opens an Excel Compound Document File and loads it into GcSpreadSheet.
'Declaration
Public Overloads Sub OpenExcel( _
ByVal As System.IO.Stream _
)
'Usage
Dim instance As Workbook
Dim stream As System.IO.Stream
instance.OpenExcel(stream)
public void OpenExcel(
System.IO.Stream
)
Parameters
- stream
- The stream that contains the Excel Compound Document File.
Return Value
Whether the file opened successfully.
This example opens a file with the Workbook class.
Microsoft.Win32.OpenFileDialog openFileDialog = new Microsoft.Win32.OpenFileDialog();
openFileDialog.Filter = "Excel File (.xls)|*.xls";
bool? useClick = openFileDialog.ShowDialog();
if (useClick == true)
{
var stream = openFileDialog.OpenFile();
stream.Seek(0, System.IO.SeekOrigin.Begin);
GrapeCity.Windows.SpreadSheet.Data.Workbook test = new GrapeCity.Windows.SpreadSheet.Data.Workbook(2);
test.OpenExcel(stream);
stream.Dispose();
}
Dim openFileDialog = New Microsoft.Win32.OpenFileDialog()
openFileDialog.Filter = "Excel File(.xls)|*.xls"
Dim useClick As Boolean = openFileDialog.ShowDialog()
If (useClick = True) Then
Dim stream = openFileDialog.OpenFile()
stream.Seek(0, IO.SeekOrigin.Begin)
Dim test As New GrapeCity.Windows.SpreadSheet.Data.Workbook(2)
test.OpenExcel(stream)
stream.Dispose()
End If
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)