Excel Macros with JavaScript & Node JS - Read Excel File to JSON, Modify & Write Back to Excel
Вставка
- Опубліковано 5 вер 2024
- Learn how to create Excel scripts with JavaScript & Node.js. In this tutorial we'll read an Excel file to JSON object, modify the data & write to a new Excel file using the new data.
nodejs.org/
code.visualstu...
docs.sheetjs.com/
#excel #javascript #nodejs
Great tutorial! Btw 5:56 is when he starts coding the script if you are already familiar with Node workflow.
Thanks a lot ! I was fast forwarding the thing until i seen this !
This video was AWESOME!!!!! I learned sooo much from the video than from hours of reading documentation. Thanks!
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!
Thank you for this video, it helps me to apply it with test driven with selenium. Greetings from Buenos Aires, Argentina
You should check this out ua-cam.com/play/PLRmEk9smitaXljDN2CjwZ96o4Aj87iuC5.html
Great video! Clear and concise - the best one I've found on this topic! I am going to check out your other automation tutorials.
Thanks!
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!
👍
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.
No udemy courses, but maybe check out my advanced channel if you are interested in more programming videos ua-cam.com/channels/JebzvfCuA5ymtb79DQm36A.html
fabulous very well explained stip by stip, just what I was looking for
saved me..tq🙂Hoping for more vedios
😊
Thank you very much, the explanation is very clear. it really help me a lot .
thanqq very much dude u saved my job
super helpful for new programmers and out of season. thanks so much for posting this video.
this was the easy peazy method ever on xlsx
Very useful, super clear explanation and easy to learn, thank you!
Great to hear!
Awesome video! Very practical.
so useful, straight to the point! thanks
Thank you so much, this was really helpful !
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?
Very nice, easy and understandable explanation, smooth and simple program compilation. Thanks
Neat and simple. It works perfectly fine from Terminal. But how do I call this from an HTML file? Thanks a lot
Really good for me Thank you Sir.
Thank you!
Thank You! One question: is it possible to keep style of 1st file during modifying? I mean cells: background color, width, borders and ect
Great video sir. Thanks a lot
👍
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?
Awesome video! Thanks
Thanks dude! This great video helped so much!
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?
Very nice video my friend. Thanks.
thank you , Great video , super helpful , Very practical
Just saved me. Thank you!!
Well done and super useful. Thanks! Are you planning on creating a series about using Excel Javascript API?
Will be doing videos about Excel online scripts, which is based on Javascript API.
Thanks a lot for sharing
Thank you so much for your time and effort. Explained so neatly..
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.
Thank you for this video, it really helped me a lot :)
Very good Video Sir. I am Waiting for more!
thank crack , greeting from Colombia
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?
Crisp and concise!!
Great job, let me also know how we can create customized function so that excel can call like formula
Thank you so much!!
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. :)
It was a great video, but how can I save the file as json ?
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?
Excellent merci pour ce tuto
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??
thanks
awesome explanation... great video... thank you very much :)
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?
How would I keep the design (styles) of the xlsx file?
Great tutorial !
Thank you!
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
Great video . I have question how do you target all sheets in excel file instead of one.
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?
tks you for your sharing video.
Thanks for the video.
Bravo!
👍
thx man this helped very much
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.
👍
thankew so much ...i's actuALLY HELPFULL
A great video indeed 🙌🏻
can we do the same for .xslm in node.js
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
Thank you so much.....
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 Please help on how to update particular cell value using node js and java script
How to Append data in same sheet "New Data"? For Ex. insert anything in same sheet. (My error : New Data already exist.)
how do i import data from excel and add it to a node.js file?
How to handle End of data reached error in xlsx or excel js
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.
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
Can you please tell me how to read from that sheets and write it into a google doc
Awesome ❤️
Good learning, but always share github link with every tutorial.
i want this for m.s Word docs.
modify then and keep the format file.
not matter if create a new file.
Hi, how can I delete the worksheet? I can't see any method can u help me
Thanks in a million.
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
Check my other channel for help with nodejs and vscode installation ua-cam.com/channels/JebzvfCuA5ymtb79DQm36A.html
Is there any tutorial with CRUD and angular included
Are you using any extension to open "Excel" files in Visual Studio Code?
sir , how to use json_to_sheet in apps script
sir, can you give an example about this? by browsing or uploading a file?
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.
Edit: Just found out online that as it is an array, I have to write it as ["Sheet Name"].
if you want to read data from specific row then what should we do?
Hi, i just had one question, can we do the changes in the same worksheet itself without creating a new one??
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 ua-cam.com/video/Yso6-jWFATo/v-deo.html
Can I do everything that VBA does in JS and Node JS as excel plans to move to this?
Not really, at least not at the moment.
Hey if we are adding a link to Excell file on OneDrive in xlsx.readFile(" ")
I think reduce instead of map would be better for performance. I work with millions of records and performance is key
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...} })
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.
nice tutorial ! :))))
how can I delete a row from an excel file
what about macros ?
anyone else having issues with node script.js?
what i keep getting
ReferenceError: readFile is not defined
Is there any file with dummy data excel
How do i reference this array in html, i wanna create a table from that array
Depends on what you use for your server back-end and front-end.
How the hell can you guys read cells that are (sum()..). I'm using the library, it simply ignores it.
is this can be applicable to any excel file type? like csv/xls ??
Thanks for the video, but this map() function is through exception in angular as "data.map is not a function", pls suggest!
has nothing to do with angular. that usually means that data at that point was not populated with an array.