/Javascript/Node.js/Nodejs read excel file to json

Nodejs read excel file to json

Convert excel file to json using node js

let express = require('express'),
    app = express(),
    bodyParser = require('body-parser'),
    multer = require('multer'),
    crypto = require('crypto'),
    xlsxtojson = require('xlsx-to-json'),
    xlstojson = require("xls-to-json");

let fileExtension = require('file-extension');

    app.use(bodyParser.json());  

    let storage = multer.diskStorage({ //multers disk storage settings
        destination: function (req, file, cb) {
            cb(null, './input/')
        },
        filename: function (req, file, cb) {
            crypto.pseudoRandomBytes(16, function (err, raw) {
                cb(null, raw.toString('hex') + Date.now() + '.' + fileExtension(file.mimetype));
                });
        }
    });

    let upload = multer({storage: storage}).single('file');

    /** Method to handle the form submit */
    app.post('/sendFile', function(req, res) {
        let excel2json;
        upload(req,res,function(err){
            if(err){
                 res.json({error_code:401,err_desc:err});
                 return;
            }
            if(!req.file){
                res.json({error_code:404,err_desc:"File not found!"});
                return;
            }

            if(req.file.originalname.split('.')[req.file.originalname.split('.').length-1] === 'xlsx'){
                excel2json = xlsxtojson;
            } else {
                excel2json = xlstojson;
            }

           //  code to convert excel data to json  format
            excel2json({
                input: req.file.path,  
                output: "output/"+Date.now()+".json", // output json 
                lowerCaseHeaders:true
            }, function(err, result) {
                if(err) {
                  res.json(err);
                } else {
                  res.json(result);
                }
            });

        })

    });
    // load index file to upload file on http://localhost:3000/
    app.get('/',function(req,res){
        res.sendFile(__dirname + "/index.html");
    });

    app.listen('3000', function(){
        console.log('Server running on port 3000');
    });

-2

Source: stackoverflow.com

Similar codes

8 votes171 views1 answer
How to split index.js to routes nodejs
Javascript Node.js
6 votes174 views2 answers
Nodejs event
Javascript Node.js
1 vote175 views1 answer
Node js starting template
Javascript Node.js
8 votes178 views1 answer
Set cookie in node
Javascript Node.js
0 vote182 views1 answer
How to get file tree of specific folder in node js
Javascript Node.js
1 vote168 views1 answer
Nodejs redis setex
Javascript Node.js
0 vote159 views1 answer
Node js list all installed modules
Javascript Node.js
3 votes180 views2 answers
Nodejs how to use await in foreach loop
Javascript Node.js
4 votes257 views2 answers
Node log without newline
Javascript Node.js
0 vote192 views2 answers
Client.connect is not a function node js mongodb
Javascript Node.js