Spread ASP.NET 6.0 Product Documentation
OpenExcel(String,ExcelOpenFlags,ExcelWarningList,String) Method
See Also Example Send Feedback

FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class > OpenExcel Method : OpenExcel(String,ExcelOpenFlags,ExcelWarningList,String) Method

Visual Basic (Declaration)
Visual Basic (Usage)
C#

fileName: Path and name of file to open

excelOpenFlags: Which parts of the spreadsheet to load

warningList: List of warning messages that occur during this operation

password: The password

Opens an Excel file into the Spread component including the specified parts and keeping track of warnings.

Syntax

Visual Basic (Declaration)
Public Overloads Function OpenExcel( _ ByVal fileName As String, _ ByVal excelOpenFlags As ExcelOpenFlags, _ ByVal warningList As ExcelWarningList, _ ByVal password As String _ ) As Boolean

Visual Basic (Usage)	Copy Code
Dim instance As FpSpread Dim fileName As String Dim excelOpenFlags As ExcelOpenFlags Dim warningList As ExcelWarningList Dim password As String Dim value As Boolean value = instance.OpenExcel(fileName, excelOpenFlags, warningList, password)

Visual Basic (Usage)

Copy Code

Dim instance As FpSpread
Dim fileName As String
Dim excelOpenFlags As ExcelOpenFlags
Dim warningList As ExcelWarningList
Dim password As String
Dim value As Boolean
 
value = instance.OpenExcel(fileName, excelOpenFlags, warningList, password)

C#
public bool OpenExcel( string fileName, ExcelOpenFlags excelOpenFlags, ExcelWarningList warningList, string password )

Parameters

fileName: Path and name of file to open
excelOpenFlags: Which parts of the spreadsheet to load
warningList: List of warning messages that occur during this operation
password: The password

Example

This example loads an Excel-formatted file.

C#	Copy Code
FpSpread1.OpenExcel("C:\\savedinexcel.xls", FarPoint.Excel.ExcelOpenFlags.DataOnly, new FarPoint.Excel.ExcelWarningList, "test");

	Copy Code
FpSpread1.OpenExcel("C:\savedinexcel.xls", FarPoint.Excel.ExcelOpenFlags.DataOnly, New FarPoint.Excel.ExcelWarningList, "test")

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

Syntax

Parameters

Example

Requirements

See Also

Reference