i was looking for a proper resource to learn office scripts Thank you
@johnlug96553 ай бұрын
Absolutely logical, organized and beautiful training. Great presentation! Thank you for the clarity.
@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!
@waterbubbler442 жыл бұрын
Great introduction and very structured. thanks for doing this.
@tomonetruth Жыл бұрын
This is a really excellent series of lectures, thanks for sharing - just what I was looking for.
@harryriley2696 Жыл бұрын
Wow my new favorite channel
@s1ngularityxd642 ай бұрын
on point, awesome
@aaa-lu7pqАй бұрын
Hello. THanks for the video. How do you get the color value of an individual cell? TIA.
@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
@JoanApita3 жыл бұрын
hey thanks man very informative.
@anwarkrg92929 ай бұрын
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.
@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
@Ahmed72552 жыл бұрын
thanks, please make more videos
@PRuijters2 жыл бұрын
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.
@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
@Ethan-dd4ln3 жыл бұрын
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
@s65012r3 жыл бұрын
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-dd4ln3 жыл бұрын
@@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.
@s65012r3 жыл бұрын
@@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-dd4ln3 жыл бұрын
@@s65012r Yes that is the error I am receiving as well
@Ethan-dd4ln3 жыл бұрын
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.
@khala13913 жыл бұрын
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[] = []