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

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

Reference

User-Task Documentation

External