Hi Sudhi, this is Kamal, (you commented on my article on LinkedIn on VBA vs Office.JS) for me being a developer, I would look for the BEST PRACTICE to write or code into Office Script. Just like what you did in this video, where you showed you used variable/object and you have manipulated it and then placed it in the sheet instead of directly working on the Excel objects. That's clear many things. But there are still small tricks and tips we need to know like, what did you do to comment out multiple lines? Requesting you to upload videos on small things that let us be comfortable with the UI of Script IDE. One more thing, could we expect an evolution in IDE in near future or it will look similar throughout?
Great work Sudhi!
Can we add custom functions in office script?
Will it work in excel online?
you saved my day
Hi Sudhi, this is Kamal, (you commented on my article on LinkedIn on VBA vs Office.JS)
for me being a developer, I would look for the BEST PRACTICE to write or code into Office Script. Just like what you did in this video, where you showed you used variable/object and you have manipulated it and then placed it in the sheet instead of directly working on the Excel objects. That's clear many things. But there are still small tricks and tips we need to know like, what did you do to comment out multiple lines?
Requesting you to upload videos on small things that let us be comfortable with the UI of Script IDE.
One more thing, could we expect an evolution in IDE in near future or it will look similar throughout?
Sure.. will do one for that. Often overlook the beginning parts due to familiarity.. but will work on a starter step video
Early starter video -- github.com/sumurthy/officescripts-projects/tree/main/Getting%20Started