Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / OpenExcel Method


In This Topic
    OpenExcel Method (FpSpread)
    In This Topic
    Opens an Excel file and loads it into the Spread component.
    Opens an Excel-formatted (BIFF8) file.
    Overload List
    OverloadDescription
    OpenExcel(String)Opens an Excel file and loads it into the Spread component.  
    OpenExcel(String,String)Opens an Excel file and loads it into the Spread component.  
    OpenExcel(String,ExcelWarningList)Opens an Excel file into the Spread component keeping track of warnings.  
    OpenExcel(String,Int32,String)Opens an Excel file and loads the specified Excel sheet (by name) into the specified sheet of the Spread component (by index).  
    OpenExcel(String,String,String)Opens an Excel file and loads the specified Excel sheet (by name) into the specified sheet of the Spread component (by name).  
    OpenExcel(String,Int32,Int32)Opens an Excel file and loads the specified Excel sheet (by index) into the specified sheet of the Spread component (by index).  
    OpenExcel(String,Int32,Int32,ExcelWarningList)Opens an Excel file and loads the specified Excel sheet into the specified sheet of the Spread component keeping track of warnings.  
    OpenExcel(String,ExcelOpenFlags)Opens an Excel file into the Spread component including the specified parts of the spreadsheet.  
    OpenExcel(String,ExcelOpenFlags,ExcelWarningList)Opens an Excel file into the Spread component including the specified parts and keeps track of warnings.  
    OpenExcel(String,ExcelOpenFlags,ExcelWarningList,String)Opens an Excel file into the Spread component including the specified parts and keeps track of warnings.  
    OpenExcel(String,Int32,String,ExcelOpenFlags)Opens an Excel file and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts.  
    OpenExcel(String,Int32,String,ExcelOpenFlags,String)Opens an Excel file and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts.  
    OpenExcel(String,String,String,ExcelOpenFlags)Opens an Excel file and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts.  
    OpenExcel(String,String,String,ExcelOpenFlags,String)Opens an Excel file and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts.  
    OpenExcel(String,Int32,Int32,ExcelOpenFlags)Opens an Excel file and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts.  
    OpenExcel(String,Int32,Int32,ExcelOpenFlags,ExcelWarningList)Opens an Excel file and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts and keeps track of warnings.  
    OpenExcel(String,Int32,Int32,ExcelOpenFlags,ExcelWarningList,String)Opens an Excel file and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts and keeps track of warnings.  
    OpenExcel(Stream)Opens an Excel stream and loads it into the Spread component.  
    OpenExcel(Stream,String)Opens an Excel stream and loads it into the Spread component.  
    OpenExcel(Stream,ExcelWarningList)Opens an Excel stream into the Spread component keeping track of warnings.  
    OpenExcel(Stream,Int32,String)Opens an Excel stream and loads the specified Excel sheet (by name) into this sheet of the Spread component (by index).  
    OpenExcel(Stream,String,String)Opens an Excel stream and loads the specified Excel sheet (by name) into this sheet of the Spread component (by name).  
    OpenExcel(Stream,Int32,Int32)Opens an Excel stream and loads the specified Excel sheet (by index) into this sheet of the Spread component (by index).  
    OpenExcel(Stream,Int32,Int32,ExcelWarningList)Opens an Excel stream and loads the specified Excel sheet (by index) into this sheet of the Spread component (by index) keeping track of warnings.  
    OpenExcel(Stream,ExcelOpenFlags)Opens an Excel stream into the Spread component including the specified parts of the spreadsheet.  
    OpenExcel(Stream,ExcelOpenFlags,ExcelWarningList)Opens an Excel stream into the Spread component including the specified parts keeping track of warnings.  
    OpenExcel(Stream,ExcelOpenFlags,ExcelWarningList,String)Opens an Excel stream into the Spread component including the specified parts keeping track of warnings.  
    OpenExcel(Stream,Int32,String,ExcelOpenFlags)Opens an Excel stream and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts.  
    OpenExcel(Stream,Int32,String,ExcelOpenFlags,String)Opens an Excel stream and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts.  
    OpenExcel(Stream,String,String,ExcelOpenFlags)Opens an Excel stream and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts.  
    OpenExcel(Stream,String,String,ExcelOpenFlags,String)Opens an Excel stream and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts.  
    OpenExcel(Stream,Int32,Int32,ExcelOpenFlags)Opens an Excel file from a stream and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts.  
    OpenExcel(Stream,Int32,Int32,ExcelOpenFlags,ExcelWarningList)Opens an Excel file from a stream and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts and keeps track of warnings.  
    OpenExcel(Stream,Int32,Int32,ExcelOpenFlags,ExcelWarningList,String)Opens an Excel file from a stream and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts and keeps track of warnings.  
    Remarks

    These methods open a Microsoft Excel-compatible BIFF (Binary Interchange File Format) file. BIFF8 (Binary Interchange File Format, version 8 from Microsoft) is the file format for several versions of Microsoft Excel (Excel 97, Excel 2000, and Excel XP).

    For opening a Spread XML file, refer to the Open method. For opening a text file, refer to the SheetView LoadTextFile method.

    Document caching (ExcelOpenFlags) allows users to open, edit, and save without the loss of advanced document content and formatting. The content can be lossless only if the opening file format is similar to the saving file format. If the advanced document content uses files besides the xls(x) file, then the additional files need to be in the same folder with the xls(x) file. Advanced content could be macros, ActiveX controls, data connections, etc.

    In order to keep any document caching settings (changes would be lost during a postback), open the original file with the document caching only setting and then save the file using the document caching setting.

    See Also

    Reference

    FpSpread Class
    FpSpread Members

    User-Task Documentation

    Saving to an Excel-Formatted File

    External

    Microsoft Excel