Stack Overflow
Stack Overflow

Questions tagged [excel-web-addins]

212 questions
1
vote
0 answers

Pane not closing properly in Excel JS add-in

I am working on an add-in with multiple task panes. One of the task panes makes multiple HTTP requests to fetch data from a server and populate the worksheet. When there is more than one task pane open, if I close the pane that fetches data from the…
yossico
  • 3,421
  • 5
  • 41
  • 76
1
vote
0 answers

Excel Add-in dialog box not sending data to Excel Desktop

I've created an Excel add-in using Yeoman and it has taskpane and Custom functions. For my custom functions I use a dialog box using displayDialogAsync method to open the dialog box and display a list of data which user can select and that selected…
user21064709
  • 11
  • 2
1
vote
1 answer

How to show prompt alert box in Excel add-ins using Office Js?

I'm new to office js. Just I need to show prompt alert box using office Js but Javascript alert not working inside office js. Can someone help me to do this? Expected alert box
gasp porch
  • 31
  • 1
1
vote
1 answer

Excel Refreshes whole sheet even when a single cell is changed

I am working on an Excel Add-in and have created some custom functions in it. Now my user has created some functions (150+ custom functions) and all of these custom functions have parameters as references to other cells in sheet. When user updates…
Kashif
  • 85
  • 8
1
vote
1 answer

Can't Use Entire Column Range with Excel JavaScript API

I've been working with entire Col rng's and noticed some inconsistencies. For instance, my Excel Spreadsheet has a Col Rng of A1:A1048576, but the following code fails. var ws = context.workbook.worksheets.getActiveWorksheet(); var range =…
FreeSoftwareServers
  • 2,271
  • 1
  • 33
  • 57
1
vote
2 answers

Excel JavaScript workbook open event

Is there any way to have some code in an Excel JavaScript add-in that runs when a workbook is opened? It looks like there is no workbook open event and onActivated event specifies that it doesn't run when workbook is opened.
user2285985
  • 79
  • 1
  • 6
1
vote
1 answer

How to add a print functionality to Office Add-in?

I am building an Excel Add-in with the Office JS API. Is there a way to handle printing with the Add-in or open a printing window? I have been going through the documentation but can't find any methods for this. Am I missing something? Edit: To be…
Marko Cubic
  • 11
  • 4
1
vote
1 answer

Excel Custom functions inside Excel Add-in

I have a office add-in generated using Yeoman template for Taskpane type using Angular Framework. How do I add custom functions to this project and what changes do I have to make ? I have already tried this using shared runtime and followed these…
Ruturaj Maggirwar
  • 9
  • 3
1
vote
1 answer

Office excel add ins onNameChanged event on "context.workbook.worksheets" not working

Using below code to identify worksheet rename event and perform activity after rename. Same is working fine in online version of excel(online office365) on Chrome/edge browser but its not working on desktop version of excel(Microsoft 365 MSO…
sagar
  • 464
  • 4
  • 13
1
vote
2 answers

Using third-party node modules with Excel JS Add-In

I am trying to create an Excel plug-in to generate custom functions (aka UDFs) to pull data from a web data source that uses a OAUTH1 Three-Step process to gather the data. It's similar to an OAUTH2 process, but can connect to the localhost. I have…
Eric Levy
  • 11
  • 2
1
vote
1 answer

Block add-in from being loaded in Excel Web

Before making the add-in available we have to add the following in the manifest to prevent the add-in for being loaded in Excel Web: …
user1532809
  • 21
  • 5
1
vote
2 answers

Excel AddIn customize title bar

I need to customize title bar in Excel AddIn, for example change background color, add border radius, delete url etc. Is it possible? If it is, how do I make it? Excel AddIn title bar
Eugene Hodasevich
  • 11
  • 1
1
vote
1 answer

Calculated PivotFields in the Excel Javascript add-in API

I'm attempting to create a pivot table through the Excel Javascript API, based off of some old code. With VBA, I could write something like Worksheets(1).PivotTables(1).CalculatedFields.Add "PxS", _ "= Product * Sales" to add a calculated field…
plckrt
  • 11
  • 2
1
vote
0 answers

cache storage in Excel Custom Function

I want to store my searched values in key and pair in excel custom function. and when I search again with the same value it should return from the cache storage. How can I do that? When I use office runtime storage it shows me error that is "wrong…
Shiv Yadav
  • 467
  • 2
  • 11
1
vote
1 answer

Title of Office.context.ui.disaplogAsync

I want to change the title of dialog box of office. I am not able to change the name of title. It display the whole url. How to add the title instead of URL.
Shiv Yadav
  • 467
  • 2
  • 11
1 2
3
…
14 15