Opening Different Microsoft Excel Versions Files

Opening Files of Different Microsoft Excel Versions

An application often has to be able to open Microsoft Excel files created in different versions, for example, Microsoft Excel 95, 97, or Microsoft Excel 2007/2010/2013/2016/2019 and Office 365. You might need to load a file in any one of several formats, including XLS, XLSX, XLSM, XLSB, SpreadsheetML, Tab‑Delimited or TSV, CSV, ODS, and so on. Use the constructor, or specify the Workbook class' SetFileFormat method to specify the format using the FileFormatType enumeration.

The FileFormatType enumeration contains many pre‑defined file formats, some of which are given below.

File Format Types Description
FileFormatType_CSV Represents a CSV file
FileFormatType_Excel97To2003 Represents an Excel 97‑2003 file
FileFormatType_Xlsx Represents an Excel 2007/2010/2013/2016/2019 and Office 365 XLSX file
FileFormatType_Xlsm Represents an Excel 2007/2010/2013/2016/2019 and Office 365 XLSM file
FileFormatType_Xltx Represents an Excel 2007/2010/2013/2016/2019 and Office 365 XLTX template file
FileFormatType_Xltm Represents an Excel 2007/2010/2013/2016/2019 and Office 365 XLTM macro‑enabled template file
FileFormatType_Xlsb Represents an Excel 2007/2010/2013/2016/2019 and Office 365 XLSB binary file
FileFormatType_SpreadsheetML Represents a SpreadsheetML file
FileFormatType_Tsv Represents a Tab‑separated values file
FileFormatType_TabDelimited Represents a Tab‑Delimited text file
FileFormatType_Ods Represents an ODS file
FileFormatType_Html Represents an HTML file
FileFormatType_MHtml Represents an MHTML file

Opening Microsoft Excel 95/5.0 Files

To open a Microsoft Excel 95/5.0 file, use LoadOptions and set the related attribute for the LoadOptions class for the template file to be loaded. A sample file for testing this feature can be downloaded from the following link:

Excel95 File

Opening Microsoft Excel 97‑2003 Files

To open a Microsoft Excel 97‑2003 file, use LoadOptions and set the related attribute for the LoadOptions class for the template file to be loaded.

Opening Microsoft Excel 2007/2010/2013/2016/2019 and Office 365 XLSX Files

To open a Microsoft Excel 2007/2010/2013/2016/2019 and Office 365 format, that is, XLSX or XLSB, specify the file path. You can also use LoadOptions and set the related attributes/options of the LoadOptions class for the template file to be loaded.

Aspose.Cells also supports opening password‑protected Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Office 365 files.

Different Ways to Open Files Managing Document Properties