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

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

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!

Great introduction and very structured. thanks for doing this.

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

Wow my new favorite channel

hey thanks man very informative.

thanks, please make more videos

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.

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.

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

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

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 😀

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

3 жыл бұрын

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

3 жыл бұрын

@@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

3 жыл бұрын

@@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

3 жыл бұрын

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

@Ethan-dd4ln

3 жыл бұрын

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.

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