Questions tagged [excel-web-addins]

212 questions
0
votes
2 answers

Excel to PowerPoint using Office Javascript API

I'm developing add-in that copies data from Excel to PowerPoint for Office (office.js) but I can't get the opened PowerPoint presentation to write in it. I know that in the past it was not possible, but I thought that they improved the API, I have…
0
votes
1 answer

"Shared Folder" disappeared in Excel after an Office 365 update

We were pushed a Office update recently and the "Shared Folder" tab that we used for sideloading Office Javascript apps from the network share was completely removed. Does anyone have more information on how to get this folder back or what the work…
0
votes
1 answer

Webpack: Localhost refused to connect

Webpack: Localhost refused to connect A webpack windows opens when I generate a yeoman excel add-in. After the process finishes, I close the window. But then all my add-ins stop working. Leaving the window open lets my add-ins work but is not what…
0
votes
0 answers

Copying function from Script lab to excel js udf project gives errors 'CustomFunctions' is not defined

I am new to office js. I created a udf project with shared runtime which contains clock, currenttime example function. I added below the functions from script lab /** * Returns the #NUM! error as part of a 2-dimensional array. * @customfunction *…
0
votes
1 answer

Office JS - Excel, Add pivot chart

How can I add a PivotChart with office.js? I can see the pivotOptions property for chart (https://learn.microsoft.com/en-us/javascript/api/excel/excel.chart?view=excel-js-preview#excel-excel-chart-pivotoptions-member) but I couldn't find a clear…
yossico
  • 3,421
  • 5
  • 41
  • 76
0
votes
1 answer

On Excel Add-In the function parameters helper is not showing on web browser on my Add-in

I want to have something like this: But on my Excel Add-in that is not showing that and I'm using the yo office template to create the add-in. Question: What I need to do the this help being show? I`m expect to have to this working on the excel…
0
votes
1 answer

OfficeRuntime undefined on custom function on PROD

How to use the OfficeRuntime API on PROD environment. I'm working on a excel add-in using custom function where the function use a OfficeRuntime.auth.getAccessToken() to fetch the token. The excel add-in is deploy in k8s cluster and the manifest is…
0
votes
1 answer

Officejs add-in in Excel 2016 fail with 7000 Permission Denied

I use "Yo Office" to create an add-in for word 2016 which is working fine. And then I use "Yo Office" to create add-in for Excel 2016, when it execute this line "Office.context.document.getFileAsync" it return error with 7000 Permission…
0
votes
1 answer

Show/hide controls in Office JS Addin ribbon

I am creating an Office JS Addin app for Excel in which I have added a custom tab using the manifest. The tab is always visible but a few controls on the tab (i.e. buttons/menus) need to be shown/hidden based on certain conditions. I read the…
0
votes
2 answers

Copy Image from Taskpane to Excel - Office-JS

I'm working on making barcodes via an Excel Add-In. So far, I've got https://github.com/lindell/JsBarcode working to generate a barcode inside the TaskPane, but I'd like to get this onto the Worksheet. My HTML knowledge is somewhat limited, this is…
0
votes
1 answer

Office Excel AddIn Custom functions are not being called on the Windows Excel App

We've created a custom function called TS_BIND that is working fine on Mac and Web but not on Windows. On Windows, any function we create is not called internally when the user tries to use them. We use a shared runtime for this add-in. MS Office…
0
votes
1 answer

How to hook into angular app from Excel custom functions?

Posting this GitHub issue. I want to set up an excel add-in using angular for the taskpane and which also includes ribbon commands and custom functions. I have an existing add-in which does not use angular and includes custom functions and ribbon…
0
votes
0 answers

npm start command returns errors for Excel webAddins

I have generated an Excel WebAddin template (TypeScript / JavaScript) with Yeoman but can run it. It returns the following errors: npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! office-addin-taskpane@0.0.1 start: office-addin-debugging start…
0
votes
1 answer

Officejs How to enable Classic Pivot Layout on Pivot Table

I have created a Pivot Table in my office add-in but I can not figure out how to enable the "Classic PivotTable Layout" in code. The feature of the Pivot table that I am trying to enable is shown below in the screen shot. This would allow the user…
0
votes
0 answers

Files Not Updang During Visual Studio Excel Web Add-in Development

I am developing an Excel Web Add-in in Visual Studio 2022. I have noticed, whenever I change something on the web project, then place a breakpoint in a JavaScript file while the Add-on is running, Visual Studio pulls out the previous version of the…
Adam L. S.
  • 825
  • 1
  • 7
  • 14