Hello. THanks for the video. How do you get the color value of an individual cell? TIA.
@s1ngularityxd64
Ай бұрын
on point, awesome
@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
@waterbubbler44
2 жыл бұрын
Great introduction and very structured. thanks for doing this.
@Sai-tek
4 ай бұрын
i was looking for a proper resource to learn office scripts Thank you
@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!
@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
@johnlug9655
3 ай бұрын
Absolutely logical, organized and beautiful training. Great presentation! Thank you for the clarity.
@anwarkrg9292
8 ай бұрын
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
@PRuijters
2 жыл бұрын
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.
@tomonetruth
11 ай бұрын
This is a really excellent series of lectures, thanks for sharing - just what I was looking for.
@harryriley2696
Жыл бұрын
Wow my new favorite channel
@JoanApita
3 жыл бұрын
hey thanks man very informative.
@Ahmed7255
2 жыл бұрын
thanks, please make more videos
@khala1391
3 жыл бұрын
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
3 жыл бұрын
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.
Пікірлер: 31