XlToDb

XlToDb is a node package that collects data from an excel file and adds the collected rows to the MongoDB database. The package uses the column header or the 1st row as the key elements and forms an object with each row. Quick and easy to implement.

Installation

Use the node npm to install XlToDb.

1npm install xltodb

Example Usage

1const xltodb = require('xltodb')
2
3// initiate mongo client
4const { MongoClient } = require("mongodb");
5const client = new MongoClient('mongodb_connection_string')
6
7// Instantiate Transify
8let XlToDb = new xltodb('./test_sheet.xlsx')
9
10// Convert the excel data to json object
11let dataInJson = XlToDb.xlToJson()
12
13// Save the data to MongoDB
14XlToDb.saveToDb(client, "DataBase_Name", "collection_name").then((result)=>{
15    console.log(result)
16})

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

Please make sure to update tests as appropriate.