Why would app-script work here? It is literally a google product, specifically for their ecosystem. While it is based of of JavaScript the API calls are all google cloud based.
You have to admit, if you're not a programmer, it's hard to distinguish the difference. You look at them, it's the same JavaScript and even methods are very similar. But, yea, there is no App Script outside of google ecosystem.
Yes, through Power Automate "When a SharePoint file is created or updated" Action. Each time a file is opened it updates its metadata and , thus, triggers that Action.
Here is the code to add a row to the end of a formatted table: Make field1, field2, field3 the names of variables. FormattedTableName.addRow(-1, [field1, field2, field3]);
Learn by watching my Office Scripts UA-cam Playlist! 59 videos, for free! Post a question, Subscribe, Like and Share! ua-cam.com/video/xWPnQhJJ8H8/v-deo.html
Not exactly. It depends on what you do in Apps script. Office Scripts are currently constrained to the object you work with. You'll need to use Power Automate or something to get other things involved, which makes it quite convoluted.
How do you add the Automate tab ( at the top next to View tab)? My last two top tabs are View and help. Let me say thanks for showing us how use Javascript in excel. I also just recently learn Python coding can also be intergrated in Excel.
thank you for the amazing effort ❤it's really the best tutorial i've seen so far
Wonderful video! Im really starting in typescript and this video was very helpfull!
Hi Thank you so much for all the tutorials and it is very helpful.
can you please add CRUD tutorial for office script?
Hi can you please include the other link of this tutorial in your description?
Best of the Best!
Thank You!
Thanks! More office script tutorials, please.
Thank you!
Excellent! Thank you!
:)
Thank you. Does app-script works here with excel? If not, is there an advanced full course for Online Excel script you recommend?
Why would app-script work here? It is literally a google product, specifically for their ecosystem. While it is based of of JavaScript the API calls are all google cloud based.
You have to admit, if you're not a programmer, it's hard to distinguish the difference. You look at them, it's the same JavaScript and even methods are very similar.
But, yea, there is no App Script outside of google ecosystem.
Sorry, I can't recommend any. I don't really watch courses other people make, it's easier for me to just read the docs.
is there a way to utilize this within my web app's backend?
Good morning is it possible to run a typescript script when opening an excel file in Teams ? Thank you.
Yes, through Power Automate "When a SharePoint file is created or updated" Action. Each time a file is opened it updates its metadata and , thus, triggers that Action.
Will you cover how we can set the value of cells in the last row on a sheet after getting the values elsewhere?
I will cover how to get the last row.
Here is the code to add a row to the end of a formatted table:
Make field1, field2, field3 the names of variables.
FormattedTableName.addRow(-1, [field1, field2, field3]);
Cools .. Thank You
😀
Thank you!
:)
😎......👍💯
.
how if we learn more about offfice javaScripts?
Learn by watching my Office Scripts UA-cam Playlist!
59 videos, for free!
Post a question, Subscribe, Like and Share!
ua-cam.com/video/xWPnQhJJ8H8/v-deo.html
Thank You
:)
More like this! Btw, can Office Scripts perform all the actions similar to Google Apps Script?
Not exactly. It depends on what you do in Apps script.
Office Scripts are currently constrained to the object you work with. You'll need to use Power Automate or something to get other things involved, which makes it quite convoluted.
How do you add the Automate tab ( at the top next to View tab)? My last two top tabs are View and help. Let me say thanks for showing us how use Javascript in excel. I also just recently learn Python coding can also be intergrated in Excel.
It's available for business subscriptions.
Which excel is this?
365 Business.