Questions tagged [excel-web-addins]
212 questions
0
votes
0 answers
When accessing Workbook.load("name") in Excel Add-in Excel 2019 Commercial using IE 11
I am trying to develop an extension that runs on a Windows machine and supports a commercial Office 2019 Excel. Excel uses IE11 perpetual browser for this. When trying to load the name using
workbook.load("name"); await context.sync();
It gives "The…
na1taneja2821
- 66
- 5
0
votes
1 answer
Url opening in Web browser instead of taskpane
I have developed an excel custom function. I have added the helpurl in the custom function. When I click on that function it opens the URL in the web browser. I want to open that URL in the excel task pane. I am getting problems with that. Here is…
Shiv Yadav
- 467
- 2
- 11
0
votes
1 answer
Information Section in Excel Custom Function
In excel function we have a by default help section for any function like SUM, COUNT.
I have created excel custom function but in my function I am not able to add the help section for that.
Default Function
I have implemented the following code for…
Shiv Yadav
- 467
- 2
- 11
0
votes
1 answer
How to do print console in excel custom function
How can I print console any thing in excel custom function. I have tried many things but it not displaying anything in the console.
Any documentation available then please, suggest it. or share the link for that.
I have tried this code.
/**
…
Shiv Yadav
- 467
- 2
- 11
0
votes
1 answer
Excel React Add-in: How to access undo stack?
I am trying to identify if a cell's data was copy or pasted in an excel sheet within a React Excel Add-in. To do this I found that this can be done in VBA using undo stack: Excel VBA How to detect if something was pasted in a Worksheet
However, same…
na1taneja2821
- 66
- 5
0
votes
0 answers
Custom Function going disable after importing anything
I have created a addin project for creating excel custom function. When I am importing anything like module or file in function.js file, my custom functions are going disable. After going disable its working fine. So my question is why its going…
Shiv Yadav
- 467
- 2
- 11
0
votes
1 answer
Delete Tracking In Excel Worksheet
I'm currently working on Angular Based Office Add-in for Excel where data tables are moved in and out of a server. Based on the microsoft documentation, I'm using the shown method for tracking changes in a given worksheet for any type of change…
ZuhairMakda
- 1
- 1
0
votes
2 answers
Is there a way to determine if Shared Runtime is used?
I am working to migrate an Excel Add-in from the old Custom Functions runtime to the new Shared Runtime. We have noticed some of our users don't receive the updated manifest as quickly as others. Therefore, there will be a cross-over period where…
BardOfBronze
- 3
- 3
0
votes
2 answers
Store user credentials on Excel add-in
I have an Excel add-in published that allows customers to retrieve/send data from a Spreadsheet to my application. The first add-in screen asks the users to provide valid credentials (of my app) before proceeding. These credentials are a user name…
Bruno
- 25
- 6
0
votes
1 answer
Office JS add in Network Share
We are trying to deploy an office excel addin for testing purposes on a network share. We tried using the preferred approach of Microsoft Admin Center. It loads the adding successfully for Excel online, but for some reason it does not work for the…
Ivan May
- 1
- 1
0
votes
1 answer
Can I open a workbook using Excel.createWorkbook(base64) that has been encrypted?
I know how to use the base64-encoded bytes of a file to create an excel workbook using office.js. The bytes I'm using represent a password-protected (encrypted) Excel workbook. When I use
Excel.createWorkbook(base64)
it prompts the user to enter a…
Gove
- 1,745
- 10
- 11
0
votes
2 answers
Office Excel JS - Find and replace
I just wonder whether we can find and replace using Office Excel JS? I have read through their doc but it does not mention about this functionality.
Steve Fagan
- 39
- 4
0
votes
1 answer
Excel add-in authentication failing for on-premise clients
I have an Excel365 add-in that allows importing and exporting data from an online application to Excel. However, I'm facing problems when trying to connect to a local server.
The problem happens when the add-in sends the initial GET command to the…
Bruno
- 25
- 6
0
votes
1 answer
Office Addin - reading web.config appsettings for debug and release
I am developing an Office Addin for excel using Visual Studio 2019. I have different settings like API urls, default user etc for debug and release. I want to save these settings in web.debug.config and web.release.config and let visual studio pick…
Kashif
- 85
- 8
0
votes
1 answer
Problem with action function in commands.js from Excel add-in tutorial
I have been trying to learn the basics for developing an Office add-in for Excel using the tutorial Microsoft provides: Excel Add-in Tutorial. My primary goal was to learn how to execute functions directly from a button on the ribbon. So, I skipped…
