0

Within an Office Excel JavaScript Add in, I created a custom ribbon. Within that custom ribbon, I would like to include custom excel functions (e.g., remove duplicates).

Is it possible, to include such functions? If yes, what does an exemplary XAML code for the manifest file look like? Where can I find the relevant IDs for Excel?

I did not find any resources on possible code snippets. Further, I did not find any related articles for Excel JS Add-Ins specifically in the documentation?

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45
user21249614
  • 1
  • If you are asking about Excel [custom functions](https://learn.microsoft.com/office/dev/add-ins/excel/custom-functions-overview), they cannot be run from a ribbon button. If that is not what you are talking about, please clarify. (BTW, the XML in the manifest is not XAML.) – Rick Kirkham Feb 20 '23 at 19:39
  • Hey Rick, thank you for your answer! I am not asking about excel custom functions, but rather about including existing excel commands that are accessible in other parts of the XLS Ribbon. I would like to add those to my custom ribbon. Is that possible? If yes, how would I need to adjust the manifest file? Thank you in advance! – user21249614 Feb 22 '23 at 06:55
  • I suspect the user wants to include existing, built-in, Excel ribbon controls on the ribbon tab of the add-in? – jkpieterse Feb 23 '23 at 15:56
  • @user21249614 That is possible in PowerPoint, (see https://learn.microsoft.com/office/dev/add-ins/design/built-in-button-integration), but not in Excel. – Rick Kirkham Feb 24 '23 at 03:12
  • Thank you @jkpieterse, that is correct :). Great, I understand that this is not possible in excel. Thank you for your responses! – user21249614 Feb 25 '23 at 15:14

1 Answers1

0

Ribbon controls can't invoke Excel custom functions directly. If you need to deliver custom functions with custom ribbon UI you need to Configure your Office Add-in to use a shared runtime. It lists all the required modifications you need to make in the manifest file.

You may find the Tutorial: Share data and events between Excel custom functions and the task pane.

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45