Excel Office Scripts: Range read and write in perf optimized way (small data)

If the range/data you are dealing with is quite large (say 100K cells), you may need to use advanced techniques like breaking-up your read/writes into multiple chunks. This video is really for small-mid size data setup.

[thirupathi]

Great work Sudhi!
Can we add custom functions in office script?
Will it work in excel online?

[kamalam]

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?