Read xls, xlsx and csv files and return json object (inside a hapijs handler)

route.js

handler: function (request, reply) {

		const path = require('path');

		const response = reply('success').hold();

		const fileExtension = path.extname(request.payload.file.filename);

		if (fileExtension === '.csv') {

			const csv = require('csv-to-json');

			csv.parse( { filename: request.payload.file.path }, (err, json) => {

				response.source = json;

				return response.send();

			});

		}
		else if (fileExtension === '.xls' || fileExtension === '.xlsx') {

			const xls = require('xlsx');

			const workbook = xls.readFile(request.payload.file.path);

			response.source = xls.utils.sheet_to_json(workbook.Sheets[Object.keys(workbook.Sheets)[0]]);

			return response.send();

		}
		else {

			response.statusCode = 500;

			return response.send();

		}

	}

Packages:

npm install csv-to-json
npm install xlsx