Stack Overflow
Stack Overflow

Questions tagged [custom-functions-excel]

For custom functions in Excel, written with JavaScript

For custom functions in Excel, written with JavaScript. Custom functions (similar to “user-defined functions”, or “UDFs”) are JavaScript functions built as part of an add-in. Users can see and run those functions in Excel alongside built-in functions like =SUM or =VLOOKUP. The functions will work on platforms that support add-ins: Excel for PC, Mac, and iPad, and also in Excel Online. See http://aka.ms/customfunctions for details.

147 questions
1
vote
1 answer

Function: call API for JSON data, show rates of desired parameter --> IMPORTJSON(url,xpath) ex. IMPORTJSON(x.com, rates.f) --> 0.042

So I'm using googlesheets. They have a scripteditor using google apps script https://developers.google.com/apps-script/guides/sheets. Basically JavaScript. I wanted to create a function that runs down a JSON file outputting what I specifically…
Vertic
  • 11
  • 1
1
vote
1 answer

Office JS: Problems when Addin is executed in multiple Excel instances

I have problems executing an office addin in multiple Excel instances. One stops running when both are executed hat the same time. I did 2 quick ScriptLab samples, where you can reproduce some issues (I pasted them). One contains an UDF-Function,…
Marco Siebert
  • 109
  • 10
1
vote
1 answer

Calling a function defined in an existing add-in using Script Lab

I can call custom functions inside cells that are part of an add-in which I installed using the Office Add-ins dialog. I know I can call built-in Excel functions using the Context object. However, I don't think I can use the same method to call…
Dogans
  • 11
  • 2
1
vote
1 answer

Await an excel calculate full of formulas, triggered by OfficeJS

I want to execute some code after Excel finished a calculate full which I triggered myself. So currently I'm calling the calculate full this way. context.workbook.application.calculate('Full'); But it seems this just triggers Excel to calculate and…
Developer
  • 186
  • 3
  • 19
1
vote
3 answers

How to match XLL for XLL compatible custom functions [Spoiler: you don't]

To enable compatibility with an existing XLL, I want to identify the equivalent XLL in the manifest of my Excel add-in. My existing add-in is using XLL technology, but it does this by using 3rd party libraries of Add-In Express. So in my case the…
Developer
  • 186
  • 3
  • 19
1
vote
2 answers

Unable to get POST request working in Excel custom functions

We are currently implementing custom functions in our app, and have been unable to get POST requests working. What we have tried: POST using fetch (exact function works in latest Chrome) POST using axios, and transpiling down (exact function works…
John Young
  • 27
  • 1
  • 6
1
vote
1 answer

Performance of excel custom functions - disable auto safe in Excel online?

While creating and testing custom functions for an Office JS add in, I measured the performance for different platforms and get quite different results. I'm looking for chances to improve, in particular I would like to know if or how it is possible…
Developer
  • 186
  • 3
  • 19
1
vote
1 answer

How to see excel API results, custom functions in excel sheet(cell) through Script Lab, instead of console log?

I am using Script lab in office 365 and facing difficulty in writing a function which fetches data from API(url). I need help in merging the below code with custom function in Java Script. from the below code that I am able to get API results in…
Vishwesh
  • 11
  • 5
1
vote
1 answer

How to make a custom function code for excel to sum the arrays from multiple columns

I'm setting up a google sheet/excel sheet for my mother. To give an example of how she tallies her business goods manually, here below is what she does every day: Hotel1 Hotel2 Total Tomatoes for Hotel (e.g. Tomatoes…
Bear
  • 11
  • 2
1
vote
2 answers

Angular excel add-in with built-in custom functions

I'm trying to start developing Office Add-ins. For sake of simplicity I'll use public code samples. Also I'm only testing with the web version of Excel. So I take the sample Excel add-in with Angular framework using Typescript and the sample custom…
Jim B
  • 21
  • 4
1
vote
1 answer

Excel JS API: write, calculate and load values from cells with custom functions

The intention is to write the formula (custom function) to the cell, calculate it, load values and retrieve them in a single function. function myFunc() { Excel.run(function (ctx) { var fExcel = '=SUM(1,2)'; var fCustom =…
Oleg Shirokikh
  • 3,447
  • 4
  • 33
  • 61
1
vote
1 answer

Fetch Post request not working in Custom functions Office Addin [TypeError: Network request failed]

I having been facing this error in custom functions excel Add-in, where I'm trying to call an external service inside a custom function. It works fine for a GET request such as this: function stockPrice(ticker) { var url =…
Zohaib
  • 363
  • 2
  • 4
  • 15
1
vote
1 answer

Call Custom Functions from add-in commands in manifest file Office JS

I started to work with the Custom Functions with office js api, and I have a few questions. I have a scenario, where I might need to refresh all the custom function formulas values after clicking on the add-in button in the excel Ribbon. Is there a…
Zohaib
  • 363
  • 2
  • 4
  • 15
1
vote
1 answer

Add custom functions to task pane add-in

Would it be possible to have custom functions and a taskpane using the same html page? We would like to call and set custom functions on the worksheet based on certain actions/parameters coming from the taskpane.
geochr
  • 241
  • 1
  • 3
  • 15
1
vote
1 answer

Custom Functions office js office insider

I have office insider subscription and developed a sample for custom function and published in iis and it is working fine in my excel as I have office insider subscription. Other than me, will the other end users who use the excel without office…
KASA
  • 15
  • 5
1 2 3
…
9 10