Open Different Microsoft Excel Versions Files with Node.js via C++

Aspose.Cells can open a range of different Microsoft Excel Versions Files, such as Microsoft Excel 95/97 - 2003, SpreadsheetML, Opening Microsoft Excel 2007/2010/2013/2016/2019 and Office 365 XLSX or Encrypted Excel Files.

How to Open 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, TabDelimited or TSV, CSV, ODS and so on. Use the constructor, or specify the Workbook class' getFileFormat() type attribute that specifies 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
Csv	Represents a CSV file
Excel97To2003	Represents an Excel 97 - 2003 file
Xlsx	Represents an Excel 2007/2010/2013/2016/2019 and Office 365 XLSX file
Xlsm	Represents an Excel 2007/2010/2013/2016/2019 and Office 365 XLSM file
Xltx	Represents an Excel 2007/2010/2013/2016/2019 and Office 365 template XLTX file
Xltm	Represents an Excel 2007/2010/2013/2016/2019 and Office 365 macro-enabled XLTM file
Xlsb	Represents an Excel 2007/2010/2013/2016/2019 and Office 365 binary XLSB file
SpreadsheetML	Represents a SpreadsheetML file
Tsv	Represents a Tab-separated values file
TabDelimited	Represents a Tab Delimited text file
Ods	Represents an ODS file
Html	Represents an HTML file
Mhtml	Represents an MHTML file

Open 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

const path = require("path");
const fs = require("fs");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "Excel95_5.0.xls");

// Get the Excel file into stream
const stream = fs.readFileSync(filePath);

// Instantiate LoadOptions specified by the LoadFormat.
const loadOptions1 = new AsposeCells.LoadOptions(AsposeCells.LoadFormat.Auto);

// Create a Workbook object and opening the file from the stream
const wbExcel95 = new AsposeCells.Workbook(stream, loadOptions1);
console.log("Microsoft Excel 95/5.0 workbook opened successfully!");

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

const path = require("path");
const fs = require("fs");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "Book_Excel97_2003.xls");
// Get the Excel file into stream
const stream = fs.readFileSync(filePath);

// Instantiate LoadOptions specified by the LoadFormat.
const loadOptions1 = new AsposeCells.LoadOptions(AsposeCells.LoadFormat.Excel97To2003);

// Create a Workbook object and opening the file from the stream
const wbExcel97 = new AsposeCells.Workbook(stream, loadOptions1);
console.log("Microsoft Excel 97 - 2003 workbook opened successfully!");

Open 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 attribute/options of the LoadOptions class for the template file to be loaded.

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
// Opening Microsoft Excel 2007 Xlsx Files
// Instantiate LoadOptions specified by the LoadFormat.
const loadOptions = new AsposeCells.LoadOptions(AsposeCells.LoadFormat.Xlsx);

// Create a Workbook object and opening the file from its path
const workbook = new AsposeCells.Workbook(path.join(dataDir, "Book_Excel2007.xlsx"), loadOptions);
console.log("Microsoft Excel 2007 - Office365 workbook opened successfully!");

Open Encrypted Excel Files

It’s possible to create encrypted Excel files using Microsoft Excel. To open an encrypted file, use the LoadOptions and set its attributes and options (for example, give a password) for the template file to be loaded. A sample file for testing this feature can be downloaded from the following link:

Encrypted Excel

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "encryptedBook.xls");

// Instantiate LoadOptions
const loadOptions = new AsposeCells.LoadOptions();

// Specify the password
loadOptions.setPassword("1234");

// Create a Workbook object and opening the file from its path
const wbEncrypted = new AsposeCells.Workbook(filePath, loadOptions);
console.log("Encrypted excel file opened successfully!");

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

Different Ways to Open Files with Node.js via C++ Opening Files with Different Formats with Node.js via C++