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

How can I get a list of other users in the current excel sheet?

I am the author of an Excel add-in that loads data from an internal api. What I want to do is avoid having many users run the StreamingInvocations concurrently to reduce load on my api and reduce updates on the sheet. Want I want to do is detect all…
celluj34
  • 11
  • 1
1
vote
0 answers

Consecutive HTTP API call returns VALUE! error in EXCEL using Office JS Custom function

I'm using Office JS framework to get data from a REST API server endpoint using "Custom Function" in Excel(part of Office 365). I'm using the YO generator mentioned in the…
Jomy Ambookan
  • 11
  • 1
1
vote
1 answer

Cookie is not shared between taskpane and custom functions in Excel on the web

I am having problem sharing cookie between the custom functions and the taskpane when deploying my Excel add-in to the web. I followed this guide to share runtime and cookie between taskpane and custom function. I tested in offline Excel (in both…
Steve Fagan
  • 39
  • 4
1
vote
1 answer

Excel Add in - Refresh all custom functions in a specific sheet

I am just curious how do I manually refresh all custom functions of my addin in a specific sheet using JavaScript? I have tried to search online through Microsoft docs but could not find any docs mentioning this. Thanks
Square9627
  • 869
  • 3
  • 10
  • 15
1
vote
1 answer

How to transform DATEVALUE into date using excel javascript api

I'm newly developing with the office.js and I would like to know if there is a way to convert serial numbers (Date Values) into date formatted using Excel Javascript API. I have this custom function: /* * @customfunction * @param {number} first *…
DeSanterra
  • 81
  • 1
  • 1
  • 8
1
vote
2 answers

How to handle date format in Custom function officejs excel add-in

I have this custom function (shared runtime): /* * @customfunction * @param {number} first * @param {number} second * @param {string} third * @returns {number[][]} */ function GETDADOS(first, second, third) { var promise = new…
DeSanterra
  • 81
  • 1
  • 1
  • 8
1
vote
1 answer

Excel JS Addin from existing web service

I am trying to develop an Excel add-in with custom functions and a task pane that interacts with an existing remote web application, to which I have added pages that load OfficeJS and my custom functions. The service uses cookie-based session…
Andrew
  • 1,698
  • 14
  • 15
1
vote
1 answer

Excel API call with custom function

I'm trying to create a custom function calling method from Excel.js API. I have followed the Excel custom function tutorial. But I always obtained the error value #VALUE! on the worksheet, and this error on the debug: Verbose Runtime [Console] [Log]…
Sami.S
  • 267
  • 1
  • 13
1
vote
1 answer

Excel JS Add-Ins: Storing non-sensitive data in a hidden worksheet vs in workbook settings

Our legacy Excel add-in stores some non-sensitive workbook-related data inside a "very hidden" worksheet. We are developing a port of the add-in using Office JS, and are weighing the pros and cons of storing the data in a "very hidden" worksheet…
sshukurov
  • 11
  • 1
1
vote
0 answers

Excel JS API - Custom Functions Refresh Disables Excel Undo

We are using the Excel JS API custom formulas to build reports for our users. We found that users cannot undo changes like they can in any standard Excel file. It looks like any calls to the Excel API clears the undo stack. This is very tough…
Tony Hunter
  • 31
  • 4
1
vote
0 answers

Excel Custom Functions not visible when validated by Microsoft validation team during certification

We have developed a add-in for excel with custom functions and the app is hosted on S3 bucket. When we test it from our end on both Excel Desktop and Excel Web (all browsers) we are able to see the custom functions available. After publishing the…
praveennc
  • 11
  • 1
1
vote
0 answers

Cannot require('ffi') in my office javascript add-in custom functions

I have created a Excel Custom Function JS add-in by using Yeoman generator for Office Add-ins. I have followed the template and tried to add one more custom functions in the ./src/functions/functions.js file. The added function comes from a dll…
HQiu
  • 11
  • 1
1
vote
2 answers

Excel Custom Functions using Add-Ins: "This add-in is no longer available" error

I followed all of the steps here to try and load in a basic excel custom function add in. Everything in the setup stages seems to work, however, when I run 'npm run start:desktop' and Excel opens, there is an error on the side that says: ADD-IN…
Will DuCharme
  • 21
  • 2
1
vote
0 answers

Using Excel context in Excel custom function

I'm trying to use var context = new Excel.RequestContext() in an Excel custom function as specified in the documentation, but the browser keeps complaining the Excel object does not exist. Anyone managed to call Excel object functions from custom…
user1098381
  • 81
  • 2
1
vote
2 answers

How can you configure functions by environment within the Custom Functions Runtime?

We are attempting to determine the environment of execution dynamically within the Custom Functions runtime in order to set a group of environment variables. We have multiple environments where our custom functions…
jorshali
  • 11
  • 2
1 2
3
…
9 10