Excel Macros with JavaScript & Node JS – Read Excel File to JSON, convert excel file into JSON
Requirements 1. Node must be installed 2. Java must be installed 3. xlsx pakage must be installed 4. Visual Studio code is optional Code : var xlsx = require(“xlsx”) var dataPathExcel = “testExcel.xlsx” var wb = xlsx.readFile(dataPathExcel); var sheetName = wb.SheetNames; //console.log(sheetValue); var excelData = xlsx.utils.sheet_to_json(sheetValue); console.log(excelData); 0:00 – Introduction to the video 0:24 –…
