I want to read excel to save in MySQL database by using NodeJS. I do not know what library to use. I want to be able to read excel based on certain rows and columns. Please help me.
-
You need to show your work. What have you looked for? Its is not possible that you haven't found a "library" to read excel or connect to mysql unless you didn't look for it. Just googling "nodejs excel" gives a lot of good results. Do that. Choose a library, do some code, and if you are stuck with that, then post that code here. People will help if you show some efforts.Dushyant Bangal– Dushyant Bangal2018-07-10 04:41:57 +00:00Commented Jul 10, 2018 at 4:41
Add a comment
|
2 Answers
There are many libraries that you can use :
- sheetjs/xlsx
- excel.js
etc.
Comments
There's a great library SheetJS/js-xlsx that provides an API for reading Excel documents.
For example, if you are uploading a file, you'll end up with something like this:
var XLSX = require('xlsx');
function importFromExcel(file) {
var reader = new FileReader();
reader.onload = function (e) {
/* read workbook */
var bstr = e.target.result;
var workbook = XLSX.read(bstr, { type: 'binary' });
/* for each sheet, grab a sheet name */
workbook.SheetNames.forEach(function (workSheetName, index) {
var sheetName = workbook.SheetNames[index];
var workSheet = workbook.Sheets[sheetName];
var excelData = (XLSX.utils.sheet_to_json(workSheet, { header: 1 }));
mapExcelData(excelData); // do whatever you want with your excel data
});
};
reader.readAsBinaryString(file);
}
function mapExcelData(data) {...}
