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

See here for more details and additional samples: github.com/sumurthy/officescr...
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

[@johnlug9655]

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

[@Sai-tek]

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

[@waterbubbler44]

Great introduction and very structured. thanks for doing this.

[@chrisouellet2832]

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!

[@tomonetruth]

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

[@harryriley2696]

Wow my new favorite channel

[@JoanApita]

hey thanks man very informative.

[@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(); But furtheron I got stuck as well in the forEach parameters.

[@movieclips7511]

thanks, please make more videos

[@topetony1431]

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

[@anwarkrg9292]

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.

[@jamesrobertson7396]

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

[@khala1391]

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.

[@JackieChung-eo3il]

I've the same problem. Please help...

[@excelswift2643]

I found the answer, bro, you can try this code: const sheetNames:string[] = []

[@AdelAbdoh060]

@@excelswift2643 thank you 😀

[@Ethan-dd4ln]

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

[@s65012r]

You should use deleteRowsAt() API -- let me know if it works.
function main(workbook: ExcelScript.Workbook) {
const table = workbook.getActiveWorksheet().getTables()[0];
table.deleteRowsAt(5, 500)
}

[@Ethan-dd4ln]

@@s65012r hi Sudhi, yes that’s what I tried. Every time I try it in power automate, it will fail. I am never able to actually delete multiple rows unless it’s a small number.

[@s65012r]

@@Ethan-dd4ln I'm getting a different error "We were unable to run the script. Please try again.
Runtime error: Line 3: Table deleteRowsAt: The request is aborted." in Power Automate. IS that what you are seeing as well?

[@Ethan-dd4ln]

@@s65012r Yes that is the error I am receiving as well

[@Ethan-dd4ln]

So since I had the same error as you, I then tried to just clear the contents of the range that i wanted to delete, which it did successfully. Then I tried to Remove Duplicates with all the blank rows, and the Remove Duplicates doesn’t work like it does when you use “Record Script” and remove duplicates.

[@excelswift2643]

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.

[@excelswift2643]

OK, I found the answer, try this code instead: const sheetNames:string[] = []

[@AdelAbdoh060]

@@excelswift2643 Thank You