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[0] var sheetValue = wb.Sheets[sheetName]; //console.log(sheetValue); var excelData = xlsx.utils.sheet_to_json(sheetValue); console.log(excelData); 0:00 - Introduction to the video 0:24 - Excel Content 1:05 - Creating readExcel.js file 1:24 - Installing xlsx npm package 1:48 - Beginning of the program 2:47 - Creating a workbook object 3:20 - Creating a sheetName Object 3:52 - Creating a sheetValue Object 4:46 - Printing a unformatted excel response 5:44 - Introduction for excel to json method 6:45 - Printing excel to json conversion response 7:54 - Recap of the program 11:41 - End Tags and subscription to the channel Next Steps : --------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------- Must Watch Playlists ► 1. Javascript - https://youtube.com/playlist?list=PLO2l2fYgN805CokP5kaOWOhqP3-2vyXdS ► 2. Puppetter - https://youtube.com/playlist?list=PLO2l2fYgN805E5fbSnvtFM3K9c92ePS8e ► 3. Cypress - https://youtube.com/playlist?list=PLO2l2fYgN807KRpLfvvrqa1MSX8XdYxkV ► 4. Tech works - https://www.youtube.com/watch?v=ZNAdt4Oe5Sw&list=PLO2l2fYgN807CQ5H3ER__7x7LeEA10T2Z ► 5. Vbscript Basics To Advanced - https://www.youtube.com/watch?v=z_ctZDolyG0&list=PLO2l2fYgN805CuD-90ESrxRqX__-YJMym ► 6. Jmeter - https://youtube.com/playlist?list=PLO2l2fYgN806eNr5cr-TMTX8xGTW7Mtcn ► 7. Excel - https://youtube.com/playlist?list=PLO2l2fYgN806piZ2fD0bYNi3ExoPJlcqj --------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------- #readExcel #readExcelthroughjavascrpt #convertexceltojson