Hello Sudhi, Thank you so much for your quick tutorial on the Basics of Office Scripts. I guess the object model is ditto and methods and properties are also the same with a prefix of the nature of the method like get & set. Is it possible to interact with external libraries? Like if I want to scrap some information using XMLHttp and then want to Email using the outlook without using Power Automate! Is it possible?
You can do limited HTTP Requests. Un-authenticated requests are possible (that is you can't Oauth/sign-in, etc.). If you know the keys / tokens to an API, you can use HTTP methods (GET/POST, etc.). We are looking into external library access - but that's not possible yet.
Hey Sudhi! I have a question related to the office script, :) Let's assume we have 2 workbooks, and we want to copy some data or get a worksheet from one to another workbook by using Script. By Using VBA it is possible, but I haven't done this execution by using Office Script for the files stored in the cloud. Does Office script capable to do this action?
Hi Serbay, As you know Office Scripts offers 2 modes of execution: 1. In-app (where user is interacting with the Excel web app): Currently it is not possible to get the data from another workbook within the script. We have a new API coming up which can work with the external workbook links feature Excel introduced. Once this API is available, you'd be able to do this for in-app automation. 2. Offline (through Power Automate) execution based on triggers or manual: It is possible to read data from other workbooks now. I have couple of videos that show-cases how to achieve this. Check out this: ruclips.net/video/dVwqBf483qo/видео.html
Nice videos! thanks so much. Question: can you read text files stored on disk? Can you use imports/libraries?
hey sudhi! i am trying to select the filteredvalues only for using calculations .But i am not able to get the range .Could you please help
Hello Sudhi, Thank you so much for your quick tutorial on the Basics of Office Scripts. I guess the object model is ditto and methods and properties are also the same with a prefix of the nature of the method like get & set.
Is it possible to interact with external libraries? Like if I want to scrap some information using XMLHttp and then want to Email using the outlook without using Power Automate! Is it possible?
You can do limited HTTP Requests. Un-authenticated requests are possible (that is you can't Oauth/sign-in, etc.). If you know the keys / tokens to an API, you can use HTTP methods (GET/POST, etc.). We are looking into external library access - but that's not possible yet.
@@s65012r Hi Sudhi, Can you show , in another video, what you mean by "use HTTP methods (GET/POST)"?
@@analysiscloud Sure -- will do that sometime this week.
ruclips.net/video/fulP29J418E/видео.html
Hey Sudhi! I have a question related to the office script, :)
Let's assume we have 2 workbooks, and we want to copy some data or get a worksheet from one to another workbook by using Script.
By Using VBA it is possible, but I haven't done this execution by using Office Script for the files stored in the cloud.
Does Office script capable to do this action?
Hi Serbay, As you know Office Scripts offers 2 modes of execution:
1. In-app (where user is interacting with the Excel web app): Currently it is not possible to get the data from another workbook within the script. We have a new API coming up which can work with the external workbook links feature Excel introduced. Once this API is available, you'd be able to do this for in-app automation.
2. Offline (through Power Automate) execution based on triggers or manual: It is possible to read data from other workbooks now. I have couple of videos that show-cases how to achieve this. Check out this: ruclips.net/video/dVwqBf483qo/видео.html