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

[@DanhWasHere]

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

[@OrbitTurner]

Thanks a lot ! I was fast forwarding the thing until i seen this !

[@nickersonlauriston1582]

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

[@reallyefficient]

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!

[@blessinagolle1473]

saved me..tq🙂Hoping for more vedios

[@ExcelGoogleSheets]

😊

[@JuanMartinRuiz]

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

[@ExcelGoogleSheets]

You should check this out kzbin.info/aero/PLRmEk9smitaXljDN2CjwZ96o4Aj87iuC5

[@onderyurdaer]

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

[@keithpowell8123]

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

[@ExcelGoogleSheets]

Thanks!

[@ameensams]

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.

[@ExcelGoogleSheets]

No udemy courses, but maybe check out my advanced channel if you are interested in more programming videos kzbin.info/door/JebzvfCuA5ymtb79DQm36A

[@animeshkr29]

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

[@dokedoke0426]

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!

[@ExcelGoogleSheets]

👍

[@armandocontreras8563]

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

[@sampratamarizky]

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

[@sabrinamckinney512]

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

[@vamsikonduru4841]

thanqq very much dude u saved my job

[@iand954]

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

[@sephiroLord]

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?

[@akshitha2110]

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?

[@chengqinglow4034]

Thank you!

[@MrXuFan]

Awesome video! Very practical.

[@muthunatarajan4498]

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

[@mohammadalmokdad1309]

Thank you so much, this was really helpful !

[@gastondev4919]

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

[@ExcelGoogleSheets]

Great to hear!

[@BlackZero880]

this was the easy peazy method ever on xlsx

[@hengkilodwig]

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?

[@edjaeger356]

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

[@ExcelGoogleSheets]

Will be doing videos about Excel online scripts, which is based on Javascript API.

[@gabrielbatista3676]

Just saved me. Thank you!!

[@omnarayan7066]

Really good for me Thank you Sir.

[@guilhermexavier2803]

Awesome video! Thanks

[@sciences-sci]

Excellent merci pour ce tuto

[@h.h3296]

so useful, straight to the point! thanks

[@mohamedkhalilarfaoui5682]

thank you , Great video , super helpful , Very practical

[@Orafasb]

Thanks dude! This great video helped so much!

[@manuelcasares7270]

Thank you so much!!

[@jameskalenga7546]

Thanks a lot for sharing

[@naveenr9563]

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

[@muzamilhussain2550]

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?

[@anudeepsyamprasad6586]

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

[@easy-draw]

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

[@ΒασίληςΖ-σ4υ]

Very nice video my friend. Thanks.

[@televisedfeedback6660]

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. :)

[@TheEnzoachi]

Great video sir. Thanks a lot

[@ExcelGoogleSheets]

👍

[@sreekanthreddy1976]

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?

[@sanjayeshwar6904]

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.

[@DavidMartin-iq9ix]

You can send the data to your front end using JSON.parse(data, null, 2) and display it inside of a pre tag. To display a single row you would just return the index of the object/row you're trying to render

[@GuilhermeHenrique-vo1sk]

Great tutorial !

[@ExcelGoogleSheets]

Thank you!

[@mitulvaghela906]

Crisp and concise!!

[@starktv8646]

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

[@frankmyatthu2406]

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

[@juanpablovelandia8930]

thank crack , greeting from Colombia

[@lorenzobandinelli2638]

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?

[@vincerolf1]

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.

[@ace.mccloud5425]

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

[@computerrcat870]

thanks

[@crypto4ever525]

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 :-)

[@juliusdx]

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??

[@drekforder2952]

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?

[@fullStackInKannada]

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

[@josericardo3015]

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. 👍

[@minhazahmed128]

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

[@click2gopal]

Thanks for the video.

[@sushmaajitjalady2285]

Thank you so much.....

[@cedrio1027]

thx man this helped very much

[@SarthakKumar]

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

[@ExcelGoogleSheets]

Not with this library. To make changes in the same file you'll need Windows with Excel installed and basically hook into VBA code though Python to make changes to the file and save. If you are 365 Business user you may want to look into Excel Automate kzbin.info/www/bejne/j6TSZ2CgjKt0itE

[@thankinhaithankinhaisystem2318]

tks you for your sharing video.

[@K3N_L33]

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

[@ahmedchouihi]

Is there any tutorial with CRUD and angular included

[@bhattaraitheaxe]

Awesome ❤️

[@mc-ti5uq]

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

[@monalishaswain9932]

thankew so much ...i's actuALLY HELPFULL

[@negociosonline40]

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

[@baluprasad3794]

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

[@ajayzz8175]

A great video indeed 🙌🏻

[@tiwarirr]

Very good Video Sir. I am Waiting for more!

[@КлимСомов-х6с]

Bravo!

[@ExcelGoogleSheets]

👍

[@jaiviksoftweb1863]

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

[@muzamilhussain2550]

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

[@nasirahmad4324]

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

[@vaulinaapriyani1573]

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

[@ExcelGoogleSheets]

Check my other channel for help with nodejs and vscode installation kzbin.info/door/JebzvfCuA5ymtb79DQm36A

[@amritgupta1540]

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

[@niteshkedia]

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

[@lestermaravilla2767]

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

[@johng5295]

Thanks in a million.

[@paarthsoin3615]

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

[@granand]

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

[@ExcelGoogleSheets]

Not really, at least not at the moment.

[@rajat420420]

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

[@bhaskarroy3364]

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.

[@bhaskarroy3364]

Edit: Just found out online that as it is an array, I have to write it as ["Sheet Name"].

[@AyushSharma-iw9do]

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

[@ExcelGoogleSheets]

has nothing to do with angular. that usually means that data at that point was not populated with an array.

[@sahoo.subrat]

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

[@ahmedchouihi]

Is there any file with dummy data excel

[@xchrisbradley]

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

[@xchrisbradley]

I would also be careful about delete. You should use a reduce function then return a new array with only the keys you want to use. cont updated = data.reduce(record => { return {record.net: record.Sales - record.Cost, record.Brand, so on...} })

[@ExcelGoogleSheets]

Can you explain why reduce would have any preformance benefits in this case? I'm not summing up a column, I'm iterating row by row and get a result for each row.

[@rogercolque]

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

[@hablu]

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

[@kevincamarillo1152]

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

[@shriniwasbhardwaz2949]

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

[@Akash-sq2cs]

sir , how to use json_to_sheet in apps script

[@reynaldonovard718]

it's great tutorial, i try to call it using VBA Shell, but it doesn't work, its just blink without any output. Can u help me? Thankyou

[@ExcelGoogleSheets]

start by including the full path to the script. Instead of node main.js Use node "C\:folder\folder\main.js" depending on your environment you may even need the full path to node

[@reynaldonovard718]

@@ExcelGoogleSheets i deploy main.js into exe file and try execute that file using excel VBA Shell. Its just blink without any output, but if i double click thats file its can run perfectly, the problem just if i try to execute using VBA Shell. Please help meee :(, Thankyou

[@reynaldonovard718]

​@@ExcelGoogleSheets​ when i try with command prompt : D:\PPIC\PROJECT-PPIC>sheets-api-project\main-win Connected! C:\snapshot\sheets-api-project ode_modules\exceljs\lib\xlsx\xlsx.js:51 throw new Error(`File not found: ^ ${filename}`); Error: File not found: Test API.xlsm at XLSX.readFile (C:\snapshot\sheets-api- project ode_modules\exceljs\lib\xlsx\xlsx.js:51:13) at async gsrun (C:\snapshot\sheets-api-project\main.js)

[@ExcelGoogleSheets]

Sounds like when you created your executable, it didn't bundle modules in it, it's still trying to find modules folder and it fails to find at in that location. If you only run this script on this machine, just run the node script in the shell and don't worry about the executable. Otherwise I would rebundle it the right way.

[@reynaldonovard718]

@@ExcelGoogleSheets Thankyou very much

[@therealprince777]

Is node a dependency here if I create a web app and want to use on a different PC?

[@ExcelGoogleSheets]

If you use node then yes. You'll have to install node on the other PC as well to be able to run the same script. You can use things like electronjs or something similar to build an app out of it that will run platform independent.

[@nicolecaday1201]

im using windows and it's showing me cmd in the terminal. Whats the cmb keywords for it?

[@ExcelGoogleSheets]

Should be the same.

[@dangkhanhlinh476]

nice tutorial ! :))))

[@abdullahalmanasseer4360]

How do i reference this array in html, i wanna create a table from that array

[@ExcelGoogleSheets]

Depends on what you use for your server back-end and front-end.

[@la_pulga8224]

how can I delete a row from an excel file