In this simple topic, we will focus on how to convert CSV to Excel in Node.js. We will make use of the Workbook class object to access the source CSV file along with the newly created LoadOptions object. You can use the simple code in Node.js to convert CSV to Excel and then save the resultant file as an XLSX or XLS on the disk.
Steps to Convert CSV to Excel in Node.js
- Establish the system environment by configuring Aspose.Cells for Node.js via Java to convert a CSV to an Excel file
- Create an instance of the LoadOptions class and set the input file LoadFormat to CSV
- Create an instance of the Workbook class by providing the CSV file path and the LoadOptions object
- Save the loaded workbook as an XLSX file on the disk
The aforementioned basic steps show how easy it is to convert CSV to XLSX in Node.js using a few lines of code. The API offers efficient conversion performance that it consumes optimal CPU resources and time for creating the output XLSX file. The CSV to Excel conversion is beneficial to perform calculations on numeric values from a CSV file because Excel files offer a more convenient way to perform mathematical calculations.
Code to Convert CSV to XLSX in Node.js
In the example code above, the LoadOptions class instance is used to specify the load format of the input file to CSV. You can also improve the Node.js code by inserting additional lines of code to set different metadata properties for the output Excel file including Author’s name, modification details, etc.
This brief tutorial has focused on how using Node.js convert CSV to Excel. However, if you are interested in converting an Excel file to a CSV, refer to the article on how to convert Excel to CSV using Node.js.