Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / OpenExcel Method / OpenExcel(String,ExcelOpenFlags,String) Method
Path and name of file
Open flag
Password of file
Example


In This Topic
    OpenExcel(String,ExcelOpenFlags,String) Method
    In This Topic
    Opens an Excel-compatible file and loads it into Spread.
    Syntax
    'Declaration
     
    Public Overloads Function OpenExcel( _
       ByVal fileName As String, _
       ByVal openFlags As ExcelOpenFlags, _
       ByVal password As String _
    ) As Boolean
    'Usage
     
    Dim instance As FpSpread
    Dim fileName As String
    Dim openFlags As ExcelOpenFlags
    Dim password As String
    Dim value As Boolean
     
    value = instance.OpenExcel(fileName, openFlags, password)
    public bool OpenExcel( 
       string fileName,
       ExcelOpenFlags openFlags,
       string password
    )

    Parameters

    fileName
    Path and name of file
    openFlags
    Open flag
    password
    Password of file
    Exceptions
    ExceptionDescription
    Specified file is not found
    No file name is specified (or specified file name is null)
    No file name is specified (or specified file name is empty)
    Example
    This example uses the OpenExcel method.
    string f;  
    f = "D:\\mptest.xls";  
    fpSpread1.OpenExcel(f, FarPoint.Excel.ExcelOpenFlags.DataOnly, "test");
    Dim f As String 
    f = "D:\mptest.xls"
    FpSpread1.OpenExcel(f, FarPoint.Excel.ExcelOpenFlags.DataOnly, "test")
    Requirements

    Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

    See Also