Node.js: Read from Excel File

In this video we show how you can read data from an excel file using node.js.
--------------------------------------------------------------------------------------------------------------
📚 If you want to get better in tech, check out my courses on Udemy with *35% Discount*.
Use Coupon Code "*TH-cam*" or click the links below!
🎓 Mastering PostgreSQL: Learning By Real Examples
www.udemy.com/course/masterin...
🎓 PostgreSQL: The Ultimate Exam
www.udemy.com/course/postgres...
🎓 Algorithm and Data Structures: The Ultimate Exam
www.udemy.com/course/algorith...

[@datboi765]

That's what I wanted. Searched for this for hours for such a simple thing. Thanks

[@kaigoat5265]

Thank u so much, i like short and clear videos, so helpfull

[@celine.3749]

Thank you for making this video, it really helps me

[@chrisyemenijian6039]

Thanks! This was very useful

[@lopezrunco]

Very useful!

[@Abhi-ow6xe]

Thanks very useful

[@souravsinha5330]

Thanks a lot !!!

[@NIRAJKUMAR-ri9jb]

Why you have used .v in the for loop ?

[@negociosonline40]

how to import excel data and insert into a js file?

[@handlebest]

pal, do u know how to read ole object like images, .docx files, .pdf files that attached inside an xlsx file?

[@bijeyta1028]

Can we do reverse of this i.e fetching terminal data to Msexcel

[@poojaj8081]

how to get only value of json array

[@dasarisahith3540]

for me it is getting error as .v is undefined

[@diyvideos9737]

noob

[@singiri697]

Can you give this code?

[@felipevasconcelos869]

var XLSX = require("xlsx");
var workbook = XLSX.readFile('C:/Users/Conferente/Documents/excel/arquivo.xlsx');
let worksheet = workbook.Sheets[workbook.SheetNames[0]];
for(let i = 2; i < 7; i++){
const id = worksheet[`A${i}`].v;
const name = worksheet[`B${i}`].v;
console.log({
id:id, name:name})
}

[@felipevasconcelos869]

my code erro
C:\Users\Conferente\Documents\curso> node ./index.js
{ id: 200, name: 'felipe' }
C:\Users\Conferente\Documents\curso\index.js:7
const id = worksheet[`A${i}`].v;
^
TypeError: Cannot read properties of undefined (reading 'v')
at Object. (C:\Users\Conferente\Documents\curso\index.js:7:31)
at Module._compile (node:internal/modules/cjs/loader:1376:14)
at Module._extensions..js (node:internal/modules/cjs/loader:1435:10)
at Module.load (node:internal/modules/cjs/loader:1207:32)
at Module._load (node:internal/modules/cjs/loader:1023:12)
at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:135:12)
at node:internal/main/run_main_module:28:49

[@felipevasconcelos869]

my code erro C:\Users\Conferente\Documents\curso> node ./index.js
{ id: 200, name: 'felipe' }
C:\Users\Conferente\Documents\curso\index.js:7
const id = worksheet[`A${i}`].v;
^
TypeError: Cannot read properties of undefined (reading 'v')
at Object. (C:\Users\Conferente\Documents\curso\index.js:7:31)
at Module._compile (node:internal/modules/cjs/loader:1376:14)
at Module._extensions..js (node:internal/modules/cjs/loader:1435:10)
at Module.load (node:internal/modules/cjs/loader:1207:32)
at Module._load (node:internal/modules/cjs/loader:1023:12)
at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:135:12)
at node:internal/main/run_main_module:28:49