Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / OpenExcel Method


In This Topic
    OpenExcel Method (FpSpread)
    In This Topic
    Opens an Excel Compound Document File and loads it into Spread.
    Opens Excel-formatted (BIFF8) content and loads it into the Spread component.
    Overload List
    OverloadDescription
    OpenExcel(Stream,ExcelOpenFlags) Opens an Excel Compound Document File and loads it into Spread.  
    OpenExcel(Stream,ExcelOpenFlags,String) Opens an Excel Compound Document File and loads it into Spread.  
    OpenExcel(Stream,ExcelOpenFlags,ExcelWarningList) Opens an Excel Compound Document File and loads it into Spread with a list of warnings.  
    OpenExcel(Stream,ExcelOpenFlags,ExcelWarningList,String) Opens an Excel Compound Document File and loads it into Spread with a list of warnings.  
    OpenExcel(Stream,ExcelOpenFlags,ExcelWarningList,String,Boolean) Opens an Excel Compound Document File and loads it into Spread with a list of warnings.  
    OpenExcel(Stream) Opens an Excel Compound Document File and loads it into Spread.  
    OpenExcel(Stream,Boolean) Opens an Excel Compound Document File and loads it into Spread.  
    OpenExcel(Stream,String) Opens an Excel Compound Document File and loads it into Spread.  
    OpenExcel(Stream,ExcelWarningList) Opens an Excel Compound Document File and loads it into Spread with a list of warnings.  
    OpenExcel(String,ExcelOpenFlags) Opens an Excel-compatible file and loads it into Spread.  
    OpenExcel(String,ExcelOpenFlags,String) Opens an Excel-compatible file and loads it into Spread.  
    OpenExcel(String,ExcelOpenFlags,ExcelWarningList) Opens an Excel-compatible file and loads it into Spread with a list of warnings.  
    OpenExcel(String,ExcelOpenFlags,ExcelWarningList,String) Opens an Excel-compatible file and loads it into Spread with a list of warnings.  
    OpenExcel(String,ExcelOpenFlags,ExcelWarningList,String,Boolean) Opens an Excel-compatible file and loads it into Spread with a list of warnings.  
    OpenExcel(String) Opens an Excel-compatible file and loads it into Spread.  
    OpenExcel(String,Boolean) Opens an Excel-compatible file and loads it into Spread.  
    OpenExcel(String,String) Opens an Excel-compatible file and loads it into Spread.  
    OpenExcel(String,ExcelWarningList) Opens an Excel-compatible file and loads it into Spread with a list of warnings.  
    Remarks

    This overload provides various ways to specify the Excel file to open and the destination in Spread. You may specify the entire Excel file or a specific sheet. You may specify the sheet by index number or by name.

    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).

    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...

    See Also

    Reference

    FpSpread Class
    FpSpread Members
    SaveExcel Method

    User-Task Documentation

    Opening Files

     

     

    Copyright © 2003-2020 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page