Stack Overflow
Stack Overflow

Questions tagged [excel-web-addins]

212 questions
0
votes
1 answer

How to get created row groups info from selected range in office-js (Excel AddIn)?

How to get the grouped row details in Office.JS excel add-in from the selected range. Any kind of help will much appreciated!
Rajath
  • 2,611
  • 8
  • 27
  • 43
0
votes
1 answer

Filter Column by Color - Excel Javascript

I'm trying to filter a column for text that is Red Font but I can't quite get it. Ive read these docs which show its possible, but I can't get it to work-->…
FreeSoftwareServers
  • 2,271
  • 1
  • 33
  • 57
0
votes
0 answers

Office-Addin Single Sign In, How to manually add MSOffice15 consent and Error 13005

How do I add or remove the consent that is granted to "MSOffice15" to access my profile? The Office Addin provides the client front end (angular/typescript) function OfficeRuntime.auth.getAccessToken(). When executed, this function firstly brings up…
JimbobTheSailor
  • 1,441
  • 1
  • 12
  • 21
0
votes
1 answer

Is it possible to modify power query connection strings (e.g. dsn-less odbc, odata) from an Excel Add-in?

I'm thinking about an Excel add-in based on office.js technology (https://learn.microsoft.com/en-us/office/dev/add-ins/overview/office-add-ins) , to handle OAuth authentication against a generic IDP, get an access token, generate new power queries…
trick73
  • 1
0
votes
1 answer

Getting the sourceString of all pivot tables in a workbook

I'm trying to run through all pivottables in an Excel workbook and list their sources, but I'm not succeeding. I'm using code like this: async function SearchInPivots( context, wb: Excel.Workbook) { let foundPivots = new foundCollection(); …
jkpieterse
  • 2,727
  • 1
  • 9
  • 18
0
votes
2 answers

Office-Addin Single Sign On and API Scopes

The Office Addin for Excel provides the method: OfficeRuntime.auth.getAccessToken(OfficeRuneTime.authOptions) to call the Azure Active Directory, log in the user and gain access to the users profile. The method brings up a dialog box asking the…
JimbobTheSailor
  • 1,441
  • 1
  • 12
  • 21
0
votes
3 answers

How to remove/delete inserted Yeoman Excel Developer Add-ins?

I am developing customer functions with Yeoman for Excel Add-in. We can use cmd, the npm run build to build add-in and insert to excel, and we also can insert the add-in by upload the "manifest". But once we uploaded/insert the add-ins, how can we…
user15410844
  • 61
  • 1
  • 7
0
votes
1 answer

How can I get OfficeRuntime.Storage to work on Macs (so 2 open add-ins in different apps can exchange data)?

My add-in shares data between Excel and Word. I'm trying to use OfficeRuntime.Storage with sharedRuntime to do this. It works great on Windows (where the Office version is supported), but I can't get it to fully work on Macs (it doesn't share data…
Andrew Hall
  • 549
  • 6
  • 17
0
votes
1 answer

How to loop over selected sheets in Excel add-in JS API?

I'm writing an MS Excel add-in. And I need to do some actions trough all selected sheets in a workbook. The problem is... I can't find any API that allows me to get access of selected sheets in the documentation. Neither for sheet collections, not…
Maxym Marchenko
  • 13
  • 1
  • 3
0
votes
0 answers

Excel addin office.js - How to track row changes

I'm develping an Excel addin with office.js and I want to track row change events. I'm fetching data from a DBMS with technical Ids but I don't want to print ids into the sheet. My main issue is to identify univocally the edited row: when user…
Claudio
  • 3,060
  • 10
  • 17
0
votes
2 answers

How to list comments in a worksheet - Excel JS

I am trying to list all comments and their positions of a excel workbook or sheet. I have found this resource but it does not explain how to get all comments of the workbook/worksheet. Could you get me a hint on how to do this? Clarification: I am…
Anselm Scholz
  • 478
  • 9
  • 20
0
votes
1 answer

Office not Showing Taskpane

I have created a code which will open taskpane automatically when add-in loaded successfully. As per the documentation i have passed the resid in the office.addin.showAsTaskpane() , but when i run the project it will always open first default…
Shiv Yadav
  • 467
  • 2
  • 11
0
votes
0 answers

Running Excel.run() from inside a web worker

I've seen that is possible to use a web worker for doing heavy stuff and not blocking the UI thread. But from what I've tested there is no possiblity to call Excel.run() from within the worker. The thing is: How can I run thousands of Excel.run()…
user1532809
  • 21
  • 5
0
votes
1 answer

deployment of custom addin into the microsoft office 365 store

I have created a custom addin in react for some excel sheet operations so, how can I deploy the custom addin in the Microsoft office 365 store?
Vikash Choudhary
  • 125
  • 7
0
votes
1 answer

Events in Excel for the web

I am using script in Excel for the Web and it is working fine. Now I try to use events but it does not seem to work there, are the events in excel Excel web supported ? Something like this from the tutorial: const sheet =…
laloune
  • 548
  • 1
  • 9
  • 26
1 2 3
…
14 15