1.0.6 • Published 5 years ago
simple-excel-reader v1.0.6
Simple Excel Reader (simple-excel-reader)
Simple node.js excel file (.xlsx) data extractor for "row oriented" data files
Installation
npm install --save simple-excel-reader
Usage
// SETUP
const ExcelReader = require('simple-excel-reader')
const filePath = './directory/filename.xlsx'
const excelReader = new ExcelReader(filePath)
// DATA EXTRACTION
// get the full workbook recordsets
excelReader
.getWorkbook()
.then(recordsets => {
console.log(recordsets)
// get the name of each worksheet
return excelReader.getWorksheetNames()
})
.then(worksheetNames => {
console.log(worksheetNames)
// get the records from a particular worksheet
return excelReader.getWorksheet(worksheetNames[2])
})
.then(records => console.log(records))
.catch(error => console.error(error))