Microsoft 365 Community Office Add-ins, 10 Mar 2021

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: Excel JS API v1.13 updates

Description

In this 9-minute Developer-focused demo, Microsoft Senior Program Manager Raymond Lu reviews Excel APIs in Preview today, slated for GA release in July. The APIs presently available in Script lab include: Dependent, Workbook, Range/Table, Event, Pivot Layout and Table style. Quick demos today on Range/Table APIs. Feedback on preview APIs is requested is always appreciated. This PnP Community demo is taken from the Office Add-ins community call - March 2021, recorded on March 10, 2021.

Demo Presenter: Raymond Lu (Microsoft) | Sr. Program Manager

Stay connected:
• Twitter https://twitter.com/microsoft365dev
• YouTube https://aka.ms/M365DevYouTube
• Blogs https://aka.ms/M365DevBlog

A

My name is raymond liu, I'm program manager, I'm focused on excel api at jazz script api. Today, I'm going to give you a little update about the 1.13 requirement set api for the web hunter link requirement set, which will be the um this july.

A

Releasing is july, so among all these api that we got targeting for 1.213 we've. We believe this is one of the most important high requests by external customer, which is insert worksheet from base 64.. So this was the one actually the top user voice.

A

uh He got a lot of votes from the ex user voice, so we prioritize on that, and I would like to recap what we have presented actually a few months ago and we do have some improvements for the api design and to make it um align with all the other application like a word or powerpoint, and also we improve the uh parameter. So you can use that to call this api and um most important they actually um this last week and we're gonna.

A

We have uh share these uh code samples in the script lab you can still you can find. You know you can find uh you can search for the insert from base64 uh api. Then you can have a try. This is the uh code samples and with that you can see what uh how to use that api. um It is available for you. So this api is ready for the preview, especially for excel online.

A

Please try it out and let us know your feedback and uh if there's no major uh issue that this api will be in the requirements 1.13 and uh releasing this and together with what insert from base64 api, we have some other api, like uh in workbook, in dependent um like dependency like the range related api. Also, we have a few events like a formula change and workbook on activated and then also some api related pivot tape, pivot table pivot layout and the table style. Okay.

A

So today I would like to share some um update about the on the api related to range and table so uh before that I would like to share you how to preview our 1.13 api. I believe many people will know just in case that, if you're new to office.js, so you can use that um tips. So you can change this from 1.0 to the beta and also add a preview here, then you can have a capability to call the previous preview api.

A

The range age api actually is including two uh api range extended api and also get range a gpa. So this api actually is simulate the user action. So when you click, um for example, if you, if you are here, you want to move, uh you usually uh hold the control key and move your keyboard like up down left right. So usually people are doing this right. Just keep keep pressing left and right. So it can. You can find edge of the range.

A

So this is what we called um extend, um get the wrench and get the range edge. And meanwhile you, if you are clicking, uh if you hold the control key and then you um you can uh click left they can. They can extend the range so something like that. So that is what we are trying to do. So this api will enable you to get these kind of information, so get range edge and also extend your wrench.

A

So you can have your you can uh input the the parameter can be the um the direction which direction you want to go left right up and down, and also it has an additional parameter, which is active cell and will tell you which you will need to tell them which cell um you want to activate it, and this is actually optional by default. Is the one top left one?

A

Okay and uh here is some sample code. I can you can use that, for example, you can make it extended down and then you can select the extended range by using this code.

A

I will show you a live demo after that, and another api would like to introduce a table resize so user. Sometimes we need to do like this. Okay, we want to resize this table by doing this, and this and also yes, yeah. So this is resize by by clicking this uh little uh little corner. You can do this resize, however uh api uh at this moment the existing api. Don't support that. So we provide the same api to be able to resize okay, so you can also make it make it very easy.

A

So just give it a wrench and then you can use the range to set the new table size. Okay. So now I would like to give you a demo for these two, uh these three api, so demo, one is a wrench, get the range edge and also get extended range.

A

So uh now I'm going to do uh get range edge. If I want to, um if I just simulate what I'm clicking um control aft control up uh hold the arrow key up, then he will go to the the one direct, the edge of this range, uh and then you still can get another uh round of up so go to the next one. It's just similar to your keyboard action.

A

You could hold ctrl key to keep um to moving, and then you can connect another game, so you move to the edge and also it can do one more time and it goes to the top of these okay and you can also do down down down down yeah. It's pretty much of that.

A

uh You can do all the direction you want to like you want to do yeah and meanwhile, um as we also can do selection. If you hold control and shift, then you can do that we can simulate by api, for example. If I want to do the and if I want to to write and then extend it from to right, then it goes to this selection.

A

Let me go again and again: that's like the whole row, uh similar to the down thing, yeah, it's the same down and if I go to extend it and extend it. If I stand, this is every every row um in this table. Okay, that's pretty much of what we are. What I'm going to demo to you, the range uh edge and I'll get extended range and another demo is the table resize api. So I uh what I show you is to how you can do it manually.

A

Api can also do it now, for example, if I want to make it law a bigger size, I can um and then I can. Click reset.

A

Size, it can read, so can.

A

Choose a bigger you can resize, so here yeah. This is a get range edge and also just get extended, and this is the um this is really size very easy, just just using the range avengers. What I suppose my selection, so you can use that to resize the range uh yeah. That's pretty much of my my demo um yeah, please!

A

Let me know if you have any questions.