CODEWITHSUNDEEP
node.jsexcelmongodbexpress
John Doe
John Doe

Reputation: 215

Upload .xlsx files to express/node and mongoDB

I'm trying to make a web application where a manager can upload a weekly work schedule to the application and then have the application parse out the data into html format.

My question to you guys is how to have the application convert the excel file into JSON while it is being upload. I'm new so I'm not sure how to simultaneously upload the file to Mongo while converting it to JSON.

edit - in my app.js :

  xlsxj = require("xlsx-to-json");
  xlsxj({
    input: "sample.xlsx", 
    output: "output.json"
  }, function(err, result) {
    if(err) {
      console.error(err);
    }else {
      console.log(result);
    }
  });

app.post('/upload' function(req, res) {
  ??? What to put here ???
});

my input where the user selects file to upload:

  .div(style={position: 'absolute', right: '50px', top: '75px'})
    unless user.email == "[email protected]"
      p Upload New Schedule
      #uploadNew
        form(action="...", method="post", enctype="multipart/form-data")
          input(type="file", name="displayImage")

I'm wondering how I go from there to having the input converted to JSON and stored in the DB

Upvotes: 0

Views: 3211

Answers (3)

Vishnu
Vishnu

Reputation: 12313

xlsxj = require("xlsx-to-json");
app.post('/upload' function(req, res) {
/* upload script here */

  xlsxj({
      input: "sample.xlsx", //change this names based on the upload file name
      output: "output.json"
    }, function(err, result) {
      if(err) {
        console.error(err);
      }else {
        console.log(result);
      }
  });
});

Upvotes: 0

prototype
prototype

Reputation: 7965

I recommend using js-xlsx to parse the .xlsx file on Node.js. This is a highly tested library that parses the data into a JSON structure you can iterate over to extract data. It doesn't parse charts or handle macros but you likely do not need to.

You may or may not choose to store the data in MongoDB. Mongo is nice for many reasons, but you have to be sure that no attribute has an embedded $ or . as these are reserved and will generate an error. Another approach you may consider to store the XLSX file or the stringified JSON file on S3, using the aws-sdk

Upvotes: 1

Vishnu
Vishnu

Reputation: 12313

There are several npm packages which can convert xlsx data to json format. You can search them on npm website.

Use this package.

Once the xlsx file is uploaded to the database. Convert it to xlsx and save it to database.

Upvotes: 0

Related Questions