Stack Overflow
Stack Overflow

Questions tagged [excel-web-addins]

212 questions
0
votes
0 answers

(Office 365 online) How to run add-ins when opening file

I would like to automate code execution when opening the file. It means that I don't want the part "Code" Code part, only the part "Run" like this Run part And if it's possible block access to "Code" part. I've tried to use Office.onReady(() => {});…
iKroZz44
  • 1
0
votes
0 answers

Excel API using onChange function to write a static date to another cell in Excel WebApp

I have done hours of research and cannot figure out how to do this. Please help. I have an Excel for Web worksheet with many columns of data. Each column is an individual entry in the data series with each row corresponding to different data points…
cdude20
  • 1
  • 1
0
votes
3 answers

How to create an installer for Excel Add-in?

I have created Excel Add-in in Javascript (Node.js), I used Yeoman generator. My add-in adds custom formulas to Excel. How can I create installer for this? I don't want to publish it in Office Store, I want to publish it on GitHub on or my…
slon474
  • 1
  • 3
0
votes
1 answer

Is there a Workbook Closed or a similar event in Office JS (Excel)?

I want to clear out data validations before a workbook closes. Is there a Workbook Closed or an event that fires when a user closes out Excel? I tried looking through the Workbook and Office object and didnt see anything available to use like in…
Javier
  • 3
  • 2
0
votes
0 answers

Hosting Office Add-in Manifest.xml File in Cloud Storage Platforms like Google Drive

Is it possible to host the Office Add-in Manifest.xml file in cloud storage platforms such as Google Drive or OneDrive? Even though I have shared the Manifest.xml files in Google Drive storage and manually added the shared URL to the Excel Trusted…
Bassem
  • 23
  • 2
  • 7
0
votes
2 answers

Is it possible to execute an excel function from an office dialog?

I have built an excel add-in in react typescript using the yeoman generator. My dialog is only opened through a button found within the custom tab I've created. As a developer, I want to allow a user run an excel function from a dialog that will…
Tariq
  • 5
  • 2
0
votes
1 answer

How to disable contextual tab menu in officejs

I want to disable the menu of the ribbon. I tried the below code but it's showing an error that RichApi.Error: ControlIdNotFound. I'm executing the code on button click. Is my hierarchy structure wrong for updating the ribbon? I had tried the below…
Shiv Yadav
  • 467
  • 2
  • 11
0
votes
0 answers

How to change the default header labels of Pivot Tables with Office JS

I am printing the Pivot table using office JS API. I want to replace/change the header labels by code using Office JS.
Poojan3037
  • 310
  • 1
  • 9
0
votes
1 answer

Add Icons to Excel cells using OfficeJS

I am trying to build a web-addin for Excel using OfficeJS. I've added Icons to a range of cells using the following code. async function addIcon() { await Excel.run(async (context) => { const sheet =…
WorksOnMyLocal
  • 1,617
  • 3
  • 23
  • 44
0
votes
1 answer

Hide or Disable 'Reopen thread' and 'Delete thread' options in excel comments using OfficeJS

My requirement was to add notes to cells in Excel using OfficeJS. However since Microsoft confirmed that adding notes using OfficeJS is not possible in the current version, as a workaround I am trying to use the Comments feature. I could add…
WorksOnMyLocal
  • 1,617
  • 3
  • 23
  • 44
0
votes
1 answer

How to execute excel formula without using sheet range with office JS

I am executing formulas with the help of the Office JS API. For this, I am following the below steps to execute the formula. I am first getting the Excel range and executing the formula in that…
Poojan3037
  • 310
  • 1
  • 9
0
votes
1 answer

Excel Office.js - Enable/Disable Multiple Context Menu Items on right click

I'm working on a new feature for an existing Excel office add-in. This feature requires a new context menu item and Sub-menu Items under the menu item. I want to enable/disable the Sub-Menu Item based on the worksheet or a specific cell within a…
WorksOnMyLocal
  • 1,617
  • 3
  • 23
  • 44
0
votes
1 answer

Check a given row, and hide all the columns with blank cells - Office.js

I have a macro (VBA) that checks a given row/range, and hide the column if the given cell is blank. Is this possible to do in office.js? Sub Hide() Dim c As Range For Each c In Range("A1:Z1").Cells If c.Value = "" Then …
carlos sousa
  • 1
0
votes
1 answer

Questions and Confusion about Manifest "Requirements" Section

my company has provided older, VSTO-style add-ins to access our data for years. We've recently created a 100% new add-in using the web-based, Excel Javascript API and we're looking to have this distributed via the Office add-in store. We're…
Mike Wright
  • 1
  • 1
0
votes
1 answer

Function to add stock causing 'Maximum call stack size exceeded' error

Ive had a google but no luck and AI isnt sure whats wrong either im receiving a call stack size exceeded. This is on excel online function AddStock() { var sheet4: string = context.workbook.worksheets.getItem("Sheet4"); var sheet1: string =…
Matt Quinton
  • 1
1 2 3
…
14 15