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
0
votes
1 answer

Problem with using OfficeRuntime.storage in existing Excel Add-in

I'm trying to share some data between my existing Excel Add-in taskpane and newly added custom-functions. When I'm trying to set/get value I get "NotImplemented: Not implemented." error. I'm referencing this package in my taskpane page:
margosmat
  • 5
  • 3
0
votes
1 answer

Single-Sign-On (SSO) for JavaScript Excel custom functions?

Custom functions (https://learn.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-overview) execute in a runtime different from the usual office-js runtime for, i.e., task pane add-ins. Task pane add-ins can use…
J.R.
  • 1,880
  • 8
  • 16
0
votes
1 answer

How do you include external JavaScript for use in Excel custom functions?

EDIT: Added simplified scenario and steps to reproduce at the end of the question. Please note that the objective is to include external script on Excel-Desktop, and not to get the simplified scenario working by some other means. We all know and…
J.R.
  • 1,880
  • 8
  • 16
0
votes
1 answer

Call external service once for all the rows in Custom Functions Excel Add-in

Consider this example from this link: https://learn.microsoft.com/en-us/office/dev/add-ins/excel/excel-tutorial-custom-functions#create-a-custom-function-that-requests-data-from-the-web function stockPrice(ticker) { var url =…
Zohaib
  • 363
  • 2
  • 4
  • 15
0
votes
2 answers

How to register custom functions add in with different view in excel

I was trying to run the sample project with custom functions add-in using this link: https://github.com/OfficeDev/Excel-Custom-Functions. I made sure that I meet all the prerequisites for running the project. I installed the certificates, and run…
Zohaib
  • 363
  • 2
  • 4
  • 15
0
votes
2 answers

Office.js Import custom functions in existing add-in

I am trying to incorporate custom functions in Excel from the preview feature of Office.js into an existing Excel add-in that I wrote. The Excel add-in is using Angular. Right now, both projects are separated in their folder and work great when run…
David Rubino
  • 5
  • 3
0
votes
1 answer

Office-add in online sideload

We followed the steps mentioned in "Sideload an Office Add-in on Office online" to work custom function for desktop or online users but still custom functions not appearing for both. Manifest file able to upload without any error but function not…
Muruga ananth
  • 89
  • 11
0
votes
1 answer

Create custom functions in Excel (Preview)

We have Microsoft Office 365 ProPlus Subscription. Version 1806(Build 10228.20021 Click-to-Run) Monthly Channel(Targeted). I have downloaded the Custom Function sample from https://github.com/OfficeDev/Excel-Custom-Functions and deployed that in…
KASA
  • 15
  • 5
0
votes
1 answer

How to dynamically update cell reference in double quotes?

I'm using a custom function that I found here to retroactively set values in other cells based on new information in later cells. The issue is, however, that the input of SetCellValue is a cell reference in quotes, like…
Brandon Sipe
  • 1
  • 2
-1
votes
1 answer

Testing Custom Functions

After building a project and installing all the required dependencies, uploading the manifest of an Excel custom function over excel-web produces an error. The excel custom function is a yeoman generated office add-in which has custom functions…
Ruturaj Maggirwar
  • 9
  • 3
-1
votes
1 answer

Excel Custom Function in reactjs

I want to create a excel custom function in reactjs. I am not getting any idea about it. If any one have idea about custom function in reactjs. plz share that. if anyone have any documentation link plz share that. Plz share any github link of…
Shiv Yadav
  • 467
  • 2
  • 11
-2
votes
1 answer

How to get macAddress using reactjs or gettting error in package

I want to use macAddress in reactJS Component. But when I am using the getmac package i am getting error. Can any one help me to do this or refer any documentation about macAddress. [Package Error] [1]: https://i.stack.imgur.com/kV0hr.png
Shiv Yadav
  • 467
  • 2
  • 11
1 2 3
…
9
10