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 using the Workbook class.
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Excel File (.xls)|*.xls";
bool? useClick = openFileDialog.ShowDialog();
if (useClick == true)
{
var stream = openFileDialog.File.OpenRead();
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 OpenFileDialog()
openFileDialog.Filter = "Excel File(.xls)|*.xls"
Dim useClick As Boolean = openFileDialog.ShowDialog()
If (useClick = True) Then
Dim stream = openFileDialog.File.OpenRead()
stream.Seek(0, IO.SeekOrigin.Begin)
Dim test As New GrapeCity.Windows.SpreadSheet.Data.Workbook(2)
test.OpenExcel(stream)
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