NodeJS has become one of the famous backend frameworks for development. So in this article, we’ll see one of its use to convert CSV into Excel
We will use CSVtoExcel npm package to do the conversion of files. It provides convertCsvToXlsx function to implement the conversion.
convertCsvToXlsx(source, destination);
Steps to Implement:
- Import path and csv-to-xlsx module.
- Specify the source and destination directory and the file name with path module function.
- Use try catch block for error detection.
- Call the convert function to convert csv to excel function.
- Check the destination directory, you’ll see excel file.
Modules Required:
- path: This module is used to join the path.
- csv-to-xlsx: This module provides functionality to convert csv to excel file.
Creating Nodejs Application And Installing Module:
-
Step 1: Run NPM init in cli and Enter the basic information
npm init
-
Step 2:Now, create app.js or index.js or anything in which we’ll implement our function
touch app.js
-
Step 3: After creating the Nodejs application, Install the required modules using the following command:
npm i path @aternur/csv-to-xlsx
Project Structure: It will look like the following.
Report.csv File
Code:
// Importing modules const path = require( 'path' );
const convertCsvToXlsx = require( '@aternus/csv-to-xlsx' );
// Specifying source directory + file name let source = path.join(__dirname, 'report.csv' );
// Specifying destination directory + file name let destination = path.join(__dirname, 'converted_report.xlsx' );
// try-catch block for handling exceptions try {
// Functions to convert csv to excel
convertCsvToXlsx(source, destination);
} catch (e) {
// Handling error
console.error(e.toString());
} |
Output:
Excel File: