Spread Windows Forms 6.0 Product Documentation
IsExcelStream(Stream,ExcelWorkbookType) Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class > IsExcelStream Method : IsExcelStream(Stream,ExcelWorkbookType) Method


stream
Stream
workbookType
Workbook type

Glossary Item Box

Opens the specified file and determines whether it meets the minimal requirements to be considered a stream containing an Excel workbook.

Syntax

Visual Basic (Declaration) 
Public Overloads Function IsExcelStream( _
   ByVal stream As Stream, _
   ByRef workbookType As ExcelWorkbookType _
) As Boolean
Visual Basic (Usage)Copy Code
Dim instance As FpSpread
Dim stream As Stream
Dim workbookType As ExcelWorkbookType
Dim value As Boolean
 
value = instance.IsExcelStream(stream, workbookType)
C# 
public bool IsExcelStream( 
   Stream stream,
   ref ExcelWorkbookType workbookType
)

Parameters

stream
Stream
workbookType
Workbook type

Exceptions

ExceptionDescription
System.ArgumentNullExceptionNo stream specified or specified stream is null
System.ArgumentExceptionNo stream specified or specified stream is empty

Example

This example opens the excel file if it is determined to be one.
C#Copy Code
string s = "c:\\test.xls";
System.IO.FileStream str = new System.IO.FileStream(s, IO.FileMode.Open, IO.FileAccess.ReadWrite);
bool b = fpSpread1.IsExcelStream(str, FarPoint.Excel.ExcelWorkbookType.BIFF);
if (b)
{
fpSpread1.OpenExcel(s);
}
Visual BasicCopy Code
Dim s As String = "c:\test.xls"
Dim str As New System.IO.FileStream(s, IO.FileMode.Open, IO.FileAccess.ReadWrite)
Dim b As Boolean = FpSpread1.IsExcelStream(str, FarPoint.Excel.ExcelWorkbookType.BIFF)
If b Then
FpSpread1.OpenExcel(s)
End If

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.