Questions tagged [excel-addins]
Excel add-ins are self-contained programs that extend or add functionality to Microsoft Office Excel.
excel-addins
1,349
questions
0
votes
0
answers
15
views
How to restrict worksheet deletion in excel using office js
I want to restrict delete worksheet option from worksheet tab.
I couldn't find any thing about this so that I use one event which is available in office-js documentation. onDeleted
For that I use this ...
0
votes
0
answers
22
views
Excel.FormattedNumberCellValue is not working with custom formula response
{
type: Excel.CellValueType.formattedNumber,
basicValue: Number(value),
numberFormat: '#,##0.00',
};
this is how I am formatting my response in custom formula response returning in excel ...
0
votes
0
answers
33
views
Issues Running Macro with Cap IQ Plugin via PowerShell Script
I need assistance with automating an Excel process that involves running a macro which utilizes functions from the Cap IQ plugin. Here’s the scenario:
Objective:
Generate an email from an Excel ...
1
vote
1
answer
39
views
Excel Add-in API functionality for storage, identity, and notes
I was directed to ask this question in this forum from here.
We are developing an Excel Add-in in Javascript and want to understand the API better.
Our application needs to store data in a way ...
0
votes
0
answers
28
views
Getting around CORS with Excel Add In
Preface: I'm super new to CORS and this whole concept.
I'm building an Excel add in through which I want to call the unstructured.io api (https://api.unstructured.io/general/v0/general). However, ...
0
votes
0
answers
37
views
Replace old add-in custom function with new custom functions syntax in cell
Is there any way to replace old version of excel add-in custom formulas to the new version of add-in custom formula using excel javascript api and angular ?
like this : =OLD.GET(A5,B5,C5)
to this : =...
0
votes
0
answers
26
views
How do I reassemble an unzipped xlam file?
I am trying to change the name of the tab that appears in the ribbon of Excel 2016 of a custom addin (xlam file) that was created before me. I found a stack overflow answer (How do you rename the tab ...
0
votes
0
answers
24
views
Automatically running javascript Excel add-in code without manual approval
I want to implement a javascript add-in for Excel that automatically runs when I open any Excel file on my computer, without the need of the user to manually activate it and without opening any right ...
0
votes
0
answers
19
views
In a Excel Pivot how to get details of cell's grouped value like drilldown but with JavaScript API?
In an Excel Add-in that I'm working on I'm able to create a Pivot by the Excel JavaScript API from a Data worksheet and it works like a charm... but now I need to retrieve the single values from a ...
1
vote
0
answers
20
views
How can I make my Excel add-in appear on iPad without sideloading?
I've developed an Office.js Excel add-in which has recently been deployed by my organisation through Integrated Apps. The add-in works perfectly on MacOS and through the browser, but I would like it ...
0
votes
0
answers
25
views
update xlwings with custom addin
how Do I update a custom excel addin made from xlwings?
I updated xlwings package version from 0.24.x to 0.29.x, but now my custom addin (xlam file) still references the old xlwings versions.
How to ...
0
votes
0
answers
33
views
Automate Analysis for Excel Prompts using VBA
I am trying to update the prompts in Analysis - which I do currently manually every month - for Excel; however, despite I am getting the value from technical name (which I guess is correct though), I ...
-2
votes
2
answers
42
views
Call a function from another script
I am trying to develop an Excel addin that would use Three.js.
For that, I have several files :
Home.html, my main html
3dModel.js, the script using three to create and display my 3d model
Home.js, ...
1
vote
1
answer
31
views
WPF window Doesn't acquire keyboard inputs when created from VSTO Add-in
I have an Excel add-in that displays a WPF window on the startup
private void ThisAddIn_Startup(object sender, EventArgs e)
{
GetOfficeVersion();
Application....
0
votes
0
answers
15
views
Is there any way to disable Excel's automatic addition of fully qualified references (absolute file path) to UDFs in xlam add-ins?
I have written several UDFs that I want to be able to use on multiple computers. To avoid copying these to every single computer every single time I add or improve one, my current solution is to store ...