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!
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!
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.
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
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?
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??
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
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
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. :)
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?
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.
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
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 :-)
In my case, when I tried to execute "var data = xlsx.utils.sheet_to_json(ws);" "console.log(data);" I got an error. TypeError: Cannot read property 'length' of undefined could someone help me resolve this error?
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?
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.
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
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. 👍
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
@@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
@@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)
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.
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!
saved me..tq🙂Hoping for more vedios
😊
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!
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
Each and every step is from the scratch ,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?
Very nice, easy and understandable explanation, smooth and simple program compilation. 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!
👍
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"].
fabulous very well explained stip by stip, just what I was looking for
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
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?
super helpful for new programmers and out of season. thanks so much for posting this video.
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?
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??
how do i import data from excel and add it to a node.js file?
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?
Thank you very much, the explanation is very clear. it really help me a lot .
How would I keep the design (styles) of the xlsx file?
Thank You! One question: is it possible to keep style of 1st file during modifying? I mean cells: background color, width, borders and ect
Awesome video! Very practical.
Very useful, super clear explanation and easy to learn, thank you!
Great to hear!
thanqq very much dude u saved my job
so useful, straight to the point! thanks
Thanks dude! This great video helped so much!
Hi, how can I delete the worksheet? I can't see any method can u help me
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
Thank you so much, this was really helpful !
How to detect duplicate cells in a sheet and merge those duplicate cells only
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.
thank you , Great video , super helpful , Very practical
How to handle End of data reached error in xlsx or excel js
How to Append data in same sheet "New Data"? For Ex. insert anything in same sheet. (My error : New Data already exist.)
sir , how to use json_to_sheet in apps script
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.
what if instead of simple key pair data is in form of key: array of objects
Very nice video my friend. Thanks.
Awesome video! Thanks
Can you please tell me how to read from that sheets and write it into a google doc
how can I delete a row from an excel file
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
Just saved me. Thank you!!
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.
can we do the same for .xslm in node.js
Really good for me Thank you Sir.
Is there any file with dummy data excel
i want this for m.s Word docs.
modify then and keep the format file.
not matter if create a new file.
It was a great video, but how can I save the file as json ?
Very good Video Sir. I am Waiting for more!
Hey if we are adding a link to Excell file on OneDrive in xlsx.readFile(" ")
Crisp and concise!!
Hi Please help on how to update particular cell value using node js and java script
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. :)
Great video sir. Thanks a lot
👍
Thank you so much for your time and effort. Explained so neatly..
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?
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?
Are you using any extension to open "Excel" files in Visual Studio Code?
Neat and simple. It works perfectly fine from Terminal. But how do I call this from an HTML file? Thanks a lot
Great video . I have question how do you target all sheets in excel file instead of one.
Thank you for this video, it really helped me a lot :)
A great video indeed 🙌🏻
anyone else having issues with node script.js?
what i keep getting
ReferenceError: readFile is not defined
Is there any tutorial with CRUD and angular included
im using windows and it's showing me cmd in the terminal. Whats the cmb keywords for it?
Should be the same.
what about macros ?
Great tutorial !
Thank you!
Thank you!
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.
if you want to read data from specific row then what should we do?
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
Please explain how we can read multiple worksheets from one excel file
this was the easy peazy method ever on xlsx
thank crack , greeting from Colombia
Great job, let me also know how we can create customized function so that excel can call like formula
How the hell can you guys read cells that are (sum()..). I'm using the library, it simply ignores it.
Thank you so much!!
How can I start reading from a specific row? 🙏🏼
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 :-)
awesome explanation... great video... thank you very much :)
is there any free package similar to sheetjs?
xlsx is another one. sheetjs isn't working our for you?
@@ExcelGoogleSheets yeah, it worked, but I have not read through license term, in case I need to use it in future commercial product…
Excellent merci pour ce tuto
In my case, when I tried to execute
"var data = xlsx.utils.sheet_to_json(ws);"
"console.log(data);"
I got an error.
TypeError: Cannot read property 'length' of undefined
could someone help me resolve this error?
did you defined "ws" correctly as shown in the video?
@@lorenzobandinelli2638 of course bro
is this can be applicable to any excel file type? like csv/xls ??
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 a lot for sharing
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.
Awesome ❤️
thx man this helped very much
Is node a dependency here if I create a web app and want to use on a different PC?
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.
There is no macro in the excel file
Thanks for the video.
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
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.
👍
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
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
@@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
@@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)
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.
@@ExcelGoogleSheets Thankyou very much
How to send this file to client without saving it ?
sir, can you give an example about this? by browsing or uploading a file?
thankew so much ...i's actuALLY HELPFULL