Reading Excel file using node js

Question

Okay so i am using the FileUploader module to upload my file from angular to my REST API   var uploader    scope uploader   new FileUploader       url  api getUrl  uploadCompetence  null        This is sent to the following POST function           router route   api uploadCompetence            post function  req  res                This is where i want to read the file              var competence   Competence build req body location               competence add function  success                        res json  message   quote created                                         function  err                        res status err  send err                                    Now my goal is to read the excel file and then add each row to my database   However im not quite sure how i can read the file from Node js i have debugged my server and couldnt find the file anywhere but the the api is being called from my Angular application  Can anyone push me in the right direction

User · Answer

You can use read-excel-file npm   In that  you can specify JSON Schema to convert XLSX into JSON Format   const readXlsxFile   require  read-excel-file node     const schema          Segment             prop   Segment           type  String             Country             prop   Country           type  String             Product             prop   Product           type  String          readXlsxFile  sample xlsx     schema    then    rows  errors      gt        console log rows

User · Answer

There are a few different libraries doing parsing of Excel files   xlsx   I will list two projects I find interesting and worth looking into   Node-xlsx  Excel parser and builder  It s kind of a wrapper for a popular project JS-XLSX  which is a pure javascript implementation from the Office Open XML spec    node-xlsx project page   Example for parsing file  var xlsx   require  node-xlsx     var obj   xlsx parse   dirname     myFile xlsx       parses a file  var obj   xlsx parse fs readFileSync   dirname     myFile xlsx        parses a buffer   ExcelJS  Read  manipulate and write spreadsheet data and styles to XLSX and JSON  It s an active project  At the time of writing the latest commit was 9 hours ago  I haven t tested this myself  but the api looks extensive with a lot of possibilites   exceljs project page   Code example      read from a file var workbook   new Excel Workbook    workbook xlsx readFile filename       then function                use workbook             pipe from stream var workbook   new Excel Workbook    stream pipe workbook xlsx createInputStream

User · Answer

install exceljs and use the following code   var Excel   require  exceljs     var wb   new Excel Workbook    var path   require  path    var filePath   path resolve   dirname  sample xlsx     wb xlsx readFile filePath  then function         var sh   wb getWorksheet  Sheet1         sh getRow 1  getCell 2  value   32      wb xlsx writeFile  sample2 xlsx        console log  Row-3   Cell-2 -   sh getRow 3  getCell 2  value        console log sh rowCount         Get all the rows data  1st and 2nd column      for  i   1  i  lt   sh rowCount  i              console log sh getRow i  getCell 1  value           console log sh getRow i  getCell 2  value

User · Answer

Useful link  https   ciphertrick com read-excel-files-convert-json-node-js    var express   require  express         var app   express         var bodyParser   require  body-parser        var multer   require  multer        var xlstojson   require  xls-to-json-lc        var xlsxtojson   require  xlsx-to-json-lc        app use bodyParser json         var storage   multer diskStorage     multers disk storage settings         destination  function  req  file  cb                cb null     uploads                       filename  function  req  file  cb                var datetimestamp   Date now                cb null  file fieldname    -    datetimestamp         file originalname split      file originalname split      length -1                         var upload   multer     multer settings                     storage  storage                      fileFilter   function req  file  callback      file filter                         if    xls    xlsx   indexOf file originalname split      file originalname split      length-1       -1                                return callback new Error  Wrong extension type                                                       callback null  true                                            single  file            API path that will upload the files        app post   upload   function req  res            var exceltojson          upload req res function err               if err                    res json  error code 1 err desc err                     return                                Multer gives us file info in req file object                if  req file                   res json  error code 1 err desc  No file passed                     return                                Check the extension of the incoming file and                  use the appropriate module                             if req file originalname split      req file originalname split      length-1       xlsx                    exceltojson   xlsxtojson                else                   exceltojson   xlstojson                            try                   exceltojson                       input  req file path                      output  null    since we don t need output json                     lowerCaseHeaders true                    function err result                       if err                            return res json  error code 1 err desc err  data  null                                               res json  error code 0 err desc null  data  result                                      catch  e                   res json  error code 1 err desc  Corupted excel file                                           app get     function req res           res sendFile   dirname     index html                app listen  3000   function            console log  running on 3000

User · Answer

You can also use this node module called  js-xlsx  1  Install module npm install xlsx 2  Import module   code snippet  var XLSX   require  xlsx   var workbook   XLSX readFile  Master xlsx    var sheet name list   workbook SheetNames  var xlData   XLSX utils sheet to json workbook Sheets sheet name list 0     console log xlData

User · Answer

Install  spread sheet  node module it will both add and fetch row from local spreadsheet

[javascript] Reading Excel file using node.js

Examples related to javascript

Examples related to angularjs

Examples related to node.js

Examples related to import-from-excel