Excel Macros with JavaScript & Node JS - Read Excel File to JSON, Modify & Write Back to Excel 

Great tutorial! Btw 5:56 is when he starts coding the script if you are already familiar with Node workflow.

This video was AWESOME!!!!! I learned sooo much from the video than from hours of reading documentation. Thanks!

Thank you for this video, it helps me to apply it with test driven with selenium. Greetings from Buenos Aires, Argentina

I've loved your channel for the last year - you are such a breath of fresh air. I may not understand a LICK of what you are doing but you make it seem so effortless. Thank you for your videos!

Each and every step is from the scratch ,thanks a lot

Wow wow, for a non-pro coder "yet" this is the first video on youtube that made me feel coding isn't only an endeavour of the genius. BTW do you have a course on udemy? Thanks for your insight, this opens up another level of understanding for me. What you did here, I usually do using macros on excel.

Great video! Clear and concise - the best one I've found on this topic! I am going to check out your other automation tutorials.

Man, I am a fulltime student but part time working as a data entry and the work I have to do weighs nearly a million data and it lags every time I run that shit excel file until I found this Video!!! I learnt frontend web dev and a little about node js. And boom! I found this video and now I can just spend too little time on my shitty work and focus on my real career improvement! Thank you brother!

fabulous very well explained stip by stip, just what I was looking for

Thank you very much, the explanation is very clear. it really help me a lot .

saved me..tq🙂Hoping for more vedios

thanqq very much dude u saved my job

super helpful for new programmers and out of season. thanks so much for posting this video.

Awesome video! Very practical.

Thank you!

Very nice, easy and understandable explanation, smooth and simple program compilation. Thanks

Thank you so much, this was really helpful !

Very useful, super clear explanation and easy to learn, thank you!

this was the easy peazy method ever on xlsx

Really good for me Thank you Sir.

so useful, straight to the point! thanks

Awesome video! Thanks

thank you , Great video , super helpful , Very practical

Just saved me. Thank you!!

This is such an amazing video. Really Helpful. How can we access a particular range of cells and how can we give name of the keys instead of taking the first row? Can anyone help on this?

Thanks dude! This great video helped so much!

Great video sir. Thanks a lot

Thanks a lot for sharing

Thank you so much for your time and effort. Explained so neatly..

Thank you so much!!

Very nice video my friend. Thanks.

Thans too for this clear explaination to a from z. It help me. You should continue to make some short exemple of what it is possible to do and usually used in buisness.

Question for you, is it possible to have a workbook as an API source that people with access can retrieve data from it with the right commands? if so is there a tutorial on how to go about it?

Neat and simple. It works perfectly fine from Terminal. But how do I call this from an HTML file? Thanks a lot

Thank you for this video, it really helped me a lot :)

Well done and super useful. Thanks! Are you planning on creating a series about using Excel Javascript API?

Thank You! One question: is it possible to keep style of 1st file during modifying? I mean cells: background color, width, borders and ect

Excellent merci pour ce tuto

Hi , Can you show me if in the cell have a data validation? how you read data validation and make the new sheet with the same data validation?

thank crack , greeting from Colombia

Very good Video Sir. I am Waiting for more!

Crisp and concise!!

thanks

awesome explanation... great video... thank you very much :)

Thanks for the video.

Great tutorial !

Great job, let me also know how we can create customized function so that excel can call like formula

Bravo!

tks you for your sharing video.

thankew so much ...i's actuALLY HELPFULL

thx man this helped very much

A great video indeed 🙌🏻

Great video . I have question how do you target all sheets in excel file instead of one.

Thank you so much.....

Awesome ❤️

Tks for the video! Have you got any video with instructions to get the content (data) from one excelonline workbook, located in onedrive and push this data to a googlesheet? Let me know! Ps: As that excel workbook in onedrive is always refreshed, the idea is to have the googlesheet updated. 👍

What should be the correct way to add a new column with data and write to the existing XLS sheet rather than write and generate a new file?

With the map function you set, record.Sales - record.Cost, how could it be rewritten so that it's record.Sales - record.Sales from a different row? I've used some of this coding and I'm trying to automate measuring change over time. Thank you for your time. :)

in 18:26, when he's writing that function, where does that "record" inside the callback function come from? or is it just a name to refer to itself?

Thanks a lot for this beautiful video!! i am streaming data from an api (server side) and like to convert the live json data in to excel file, so i can see the data updated every 3 seconds. (already have refreshed data in my node console) can you please advice me how to do it? thanks a lot for any help with this one :-)

Hi really a nice video, here's a question how do I append data to the same excel file by adding another column rather than creating new excel file. Could you please help me

can we do the same for .xslm in node.js

Hey bro, your video is awesome. I have one question. If we don't create a new file and add a new row to an existing file and saved data in this file. how can we do this?

Thanks in a million.

Thanks for this video.. it's really very helpful.. one thing, can we display what's there in consol into the web? And is it possible to display a perticular row instead of displaying hole table? Please can u help with this.. this will help me with my project.

is there a way to get value of a certain cell, like I want a value just of a let's say A1 cell. how whould I do that?

Hi for some reason my output file data appears in a different column to the original file? i.e. data in column A in original file appears in column D in the output file.. any ideas??

nice tutorial ! :))))

Are you using any extension to open "Excel" files in Visual Studio Code?

How would I keep the design (styles) of the xlsx file?

Is there any tutorial with CRUD and angular included

Hi Please help on how to update particular cell value using node js and java script

if you want to read data from specific row then what should we do?

sir, can you give an example about this? by browsing or uploading a file?

what if instead of simple key pair data is in form of key: array of objects

How to detect duplicate cells in a sheet and merge those duplicate cells only

Please explain how we can read multiple worksheets from one excel file

how do i import data from excel and add it to a node.js file?

I think reduce instead of map would be better for performance. I work with millions of records and performance is key

It was a great video, but how can I save the file as json ?

How to Append data in same sheet "New Data"? For Ex. insert anything in same sheet. (My error : New Data already exist.)

i want this for m.s Word docs. modify then and keep the format file. not matter if create a new file.

Thanks for the video, but this map() function is through exception in angular as "data.map is not a function", pls suggest!

Can you please tell me how to read from that sheets and write it into a google doc

is this can be applicable to any excel file type? like csv/xls ??

10:30 I cannot proceed as my var ws = wb.Sheets("Sheet Name"); returns an error called Sheets is not a function. I searched online but no specific help on the same.

How to handle End of data reached error in xlsx or excel js

Hi, i just had one question, can we do the changes in the same worksheet itself without creating a new one??

Hi, how can I delete the worksheet? I can't see any method can u help me

sir , how to use json_to_sheet in apps script

Thank you so much much much much

Good learning, but always share github link with every tutorial.

Hi, thank you before with this video. I got problem when view terminal is showing Windows PowerShell, not xlsx-node adm$ I already install nodejs. Can please help me? Thank you

Can I do everything that VBA does in JS and Node JS as excel plans to move to this?

How can I start reading from a specific row? 🙏🏼

Hey if we are adding a link to Excell file on OneDrive in xlsx.readFile(" ")

how can I delete a row from an excel file

what about macros ?

Is there any file with dummy data excel

anyone else having issues with node script.js? what i keep getting ReferenceError: readFile is not defined