How to Convert CSV to Excel in Node.js ?
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:
Javascript
const path = require( 'path' );
const convertCsvToXlsx = require( '@aternus/csv-to-xlsx' );
let source = path.join(__dirname, 'report.csv' );
let destination = path.join(__dirname, 'converted_report.xlsx' );
try {
convertCsvToXlsx(source, destination);
} catch (e) {
console.error(e.toString());
}
|
Output:
Excel File:
Last Updated :
30 Jun, 2021
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...