Office Scripts: Introduction to the make-up of a script

Content:
0:00 Introduction to scripts
13:57 Switch to the Excel web app and access Office Scripts (Automate tab)
14:48 Start a new script - introduction to `main` function
15:28 Getter methods
19:06 Method chaining
21:49 Checking for `undefined` type and handling that condition
25:15 getCollection getter methods and collection handling
30:22 Using functions to organize your code, optional and required arguments
35:00 Setter methods and actions
37:48 Static-typing, implicit-any, explicit-any types

[johnlug]

Absolutely logical, organized and beautiful training. Great presentation! Thank you for the clarity.

[chrisouellet]

best explanation yet of Office Script, and by far - you cover all the things to know to be able to start to understand this language - many thanks for the effort and time!

[Sai-tek]

i was looking for a proper resource to learn office scripts
Thank you

[tomonetruth]

This is a really excellent series of lectures, thanks for sharing - just what I was looking for.

[waterbubbler]

Great introduction and very structured. thanks for doing this.

[aaa-lupq]

Hello. THanks for the video. How do you get the color value of an individual cell? TIA.

[topetony]

Hi Sudhi! This is a great video. I really appreciate you doing this. So I have been trying to create a table using office script recorder but the script usually returns an error
"Line 4: Workbook addTable: You cannot perform the requested operation." What can I do to fix this? Thanks

[anwarkrg]

Hi Sudhi, thanks for sharing the video. Would you share the script how to open other file and do vlookup of data from active worksheet to worksheet from that different excel file.

[PRuijters]

I too, got stuck on various locations when trying to reproduce the code. It started with the array declaration. What does work here is: const sheetNames = Array<String>(); But furtheron I got stuck as well in the forEach parameters.

[excelswift]

Hey Sudhi, I love your Office Script vedio, it's helpful. I have a problum at min 26:54 that you defined a blank array.When i wrote your codes, it throw a error with this msg:"Office Scripts cannot infer the data type of this variable. Please declare a type for the variable." I don't know why.Could you guide me a solution? thanks a lot.

[jamesrobertson]

I am trying to write a script that when we hit a button the script will save the file based on information in a certain cell is this possible in scripts i was able to do it in VBA

[khala]

hello, Sudhi. thank you for your valuable clips. I have learnt much on that. however, I stuck at some point at min 26:39 that you define blank array. I repeated your step but my excel show error and suggest as this quote 'Office Scripts cannot infer the data type of this variable. Please declare a type for the variable.'. could you guide me a solution? thanks in advance.

[Ethan-ddln]

Hey Sudhi, I love your videos and I appreciate you taking the time to create them. I have been having a problem with Office Scripts trying to delete rows from a table. Every time I try to delete more than 100 rows, it always seems to fail. I tried removing duplicates but it keeps the blank rows. There doesn’t seem to be a setResizedRange() capability. Do you know how i could delete more than 100 rows in a table? Thanks