Microsoft 365 and Office Development Office JavaScript API

0 answers

Cloning an Office JS add-in control from the ribbon to a document-level customUI definition

I have a simple Office.JS add-in that includes a button in the home tab to activate the add-in's taskpane. Using the Office ribbon customisation UI (right click anywhere on the ribbon and select "Customize the Ribbon..." I can clone that…

asked

Jamie Garroch MVP 6 MVP

commented

Jamie Garroch MVP 6 MVP

1 answer

Applying AutoFilters to Excel table slow

We are building an Excel-specific addin that retrieves data from an external source and puts it into an Excel table for viewing. This table can range from 1 row x 5 columns to 500k rows x 100 columns. When a user specifies a filter on the table and…

asked

Jacob Calkins 1

answered

Guangshuai Liu 1 Microsoft Employee

1 answer

Get replies to bug reports on current Microsoft email account, not my previous email account?

Years ago, I changed the principal email address of my Microsoft account (from hotmail to gmail). However, any time I submit a bug report to Microsoft, they reply to my hotmail email address, which I normally don't look at any more. I can't see anywhere…

asked

Bill Fulton 6

commented

Anonymous

2 answers

Custom XML support PowerPoint via Office JS

We are building Office JS taskpane addin for (Word, Excel, PowerPoint) and we are heavily relying on the data stored into the document (custom XML). In Word and Excel there are API's to access that information, but it seems that in PowerPoint the support…

asked

Miikka Laakso 41

commented

Miikka Laakso 41

1 answer

How to use a ConditionalTextOperator in ExcelScript

I am new to ExcelScript and trying to write a script that determines whether a cell contains a space. I'm not sure how to use the ExcelScript.ConditionalTextOperator enum. I know there is a "contains" value, but what do I use with this operator…

asked

Josie 1

answered

Brian Gonzalez 76

5 answers

I want to learn Office scripts. Which Book should I start with?

https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel I want to learn the above Tool. Where should I start with? Is there a Book available? Please reply. Thank You. With Hope, Prabhakaran

asked

Prabhakaran Karuppaih 21

answered

عايد مخلد المطيري 16

0 answers

Pinch Zoom breaks touch accuracy when opening Excel through Microsoft.Office.Interop.Excel

Good Morning, I'm using 'Microsoft Excel 14.0 Object Library' just to open and close a specific workbook and I'm running in to a possible bug with the library. If I open a workbook 'Workbooks.Open' it opens fine and runs fine however when using pinch…

asked

CFoster 1

1 answer

Update PowerPoint slide with controls built on server

Hi, I have an issue when trying to update a PowerPoint slide, more exactly I want to build on the server the controls that are not available on the frontend version of PowerPoint and then insert them into the slide. Is there any way of doing this…

asked

Popa Daniel Viorel 1

answered

Luyi Han 1 Microsoft Employee

0 answers

createDocument() from base64 or url result in RichApi.Error: GeneralException

I am trying to open an existing document from within a Word add-in. I tried: var newDoc = context.application.createDocument(base64Image) newDoc.open() context.sync() but I'm am getting an error: Uncaught (in promise) RichApi.Error:…

asked

AG 1

1 answer

Clearing the Wef directory

On this page, it says that to clear the Office cache you should "delete the contents of" %LOCALAPPDATA%\Microsoft\Office\16.0\Wef. Does that include subdirectories, or just files at the top level?

asked

T.J. Crowder 1

answered

T.J. Crowder 1

2 answers

RegSvr32 ok pop-up should click automatically.

Hello There, I have an issue with pop-up of regvsr32, that should be click on ok automatically, please tell me the PowerShell command line. Hint: Notify or tag a user in this post by typing @Anonymous .

asked

anil lucky 1

commented

Castorix31 90,681

0 answers

InsertBookmark Api in OfficeJS

Hi Team, We want to use insertBookmark method but it is not supported by wordApi 1.3 As per docs it says wordapi beta, when it will be added in wordapi 1.3. Can any one update for this? Thank You. @office-js-dev @officeaddin

asked

Ankit Gaikwad 1

1 answer

insert Bookmark using office js

In office js docs their is a method insertBookmark but it is not supported by wordapi 1.3. As per docs it says wordapi beta, when it will be added in wordapi 1.3. Can any one please help in this case.

asked

Shraddhesh Dongare 6

answered

Ankit Gaikwad 1

1 answer

Handle for close event of PowerPoint app in the add-in (JS)

Hello, I was looking for a way to handle the closing event of the PowerPoint when developing an Add-in. The only ones that were a bit close was the fact that we can detect the visibility change of the add-in with …

asked

Popa Daniel Viorel 1

answered

Luyi Han 1 Microsoft Employee

1 answer

excel plugin, what is the best place to store accessToken

Excel add-in, invokes enterprise apps page via dialog api and are able to get access token, i want to know what's the best place to store in case of excel add-in, as it is needed to invoke backend REST API?

asked

theaiwork 1

answered

Rick Kirkham 281 Microsoft Employee

0 answers

Reliably Clear Desktop Excel Addin Cache During Dev

I'm struggling to work on a custom functions Office JS addin because Desktop Excel keeps using old copies of the files. (I am, of course, stuck working on a Desktop-specific bug.) I've cleared %LOCALAPPDATA%\Microsoft\Office\16.0\Wef. I've cleared…

asked

T.J. Crowder 1

commented

T.J. Crowder 1

0 answers

Is there a way to load "n" number of rows from table iteratively in excel table office js api

I am working on developing add-in which business users will use to interact with enterprise apps. User can have thousands of records in excel sheet in table, we need to call backend API, want to do it iteratively by n (say equal 100 rows), is there a way…

asked

theaiwork 1

0 answers

content control

Is it possible to put an existing table inside a content control? Right now, the content controls, which were created with "table.insertContentControl()", disappear after page reloading. The reasoning for such functionality is to be able to…

asked

Mariia Kunieva 1

1 answer

office-addin-sso with @azure/msal-browser

Is there any difference between these 2 approaches: (1) Using @azure/msal-browser to get an Access Token [and then using this to access MS Graph] or (2) Using OfficeRuntime.auth.getAccessToken() to get an Identity Token which can then be swapped…

asked

BetterSolutions.com 121

accepted

BetterSolutions.com 121

0 answers

Unit test cases for Office js library using Angular13 framework

We are developing outlook add-in using Angular 13 framework and trying to write unit test cases for it. We have tried and tested the examples which is mentioned in official documentation. Unable to execute test cases using Jest/Jasmine framework…

asked

SK 1

Microsoft 365 and Office | Development | Office JavaScript API

Filter

Content

1,066 questions with Microsoft 365 and Office | Development | Office JavaScript API tags

Cloning an Office JS add-in control from the ribbon to a document-level customUI definition

Applying AutoFilters to Excel table slow

Get replies to bug reports on current Microsoft email account, not my previous email account?

Custom XML support PowerPoint via Office JS

How to use a ConditionalTextOperator in ExcelScript

I want to learn Office scripts. Which Book should I start with?

Pinch Zoom breaks touch accuracy when opening Excel through Microsoft.Office.Interop.Excel

Update PowerPoint slide with controls built on server

createDocument() from base64 or url result in RichApi.Error: GeneralException

Clearing the Wef directory

RegSvr32 ok pop-up should click automatically.

InsertBookmark Api in OfficeJS

insert Bookmark using office js

Handle for close event of PowerPoint app in the add-in (JS)

excel plugin, what is the best place to store accessToken

Reliably Clear Desktop Excel Addin Cache During Dev

Is there a way to load "n" number of rows from table iteratively in excel table office js api

content control

office-addin-sso with @azure/msal-browser

Unit test cases for Office js library using Angular13 framework