Stack Overflow
Stack Overflow

Questions tagged [excel-web-addins]

212 questions
5
votes
1 answer

Is any way to add the changes to undo/redo stack made by Excel addin?

Here I am using Office.js API in Excel add-in. When I export any table or information using Excel add-in, the undo and redo buttons are disabled, and the undo/redo stack is cleared. Thank you in advance
Rajat Panjavani
  • 65
  • 4
4
votes
0 answers

Is there a way to open a linked workbook in Excel using Office.js?

I am trying to programmatically open a linked workbook referenced in the current workbook in Excel using the Office.js framework. I see an Excel.LinkedWorkbook class but with no function to open the linked workbook. How would I do this?
Harsh Patel
  • 151
  • 6
3
votes
1 answer

Error: Office.js has not fully loaded. Your app must call "Office.onReady()" as part of it's loading sequence

I have created an Excel add-in using the Office JS library. My add-in works fine with Office 365 but when try to run the same add-in with Office 2019 or 2016 it shows a blank screen only and throws error : Office.js has not fully loaded. Your app…
Poojan3037
  • 310
  • 1
  • 9
3
votes
1 answer

Access each cell's specific properties in a RangeAreas object in OfficeJS

I am converting my VBA Excel add-in to OfficeJS, and one function takes each cell in a range and: if the cell is hardcoded, turns the font blue if the cell has a formulas, turns the font black if the cell links to another sheet, turns the font…
Liam
  • 33
  • 3
3
votes
1 answer

Following documentation to "Create a custom functions project", getting "Error installing add-ins"

I have followed the guide for creating a custom functions project: https://learn.microsoft.com/en-us/office/dev/add-ins/quickstarts/excel-custom-functions-quickstart?tabs=excel-windows When I run npm run start:desktop Excel opens. The Excel instance…
user1283776
  • 19,640
  • 49
  • 136
  • 276
3
votes
4 answers

Correct way to deploy changes to office add-in (not in the manifest file)

I have an Excel office add-in in app source. I fixed a bug which a user has reported to me and now I want to deploy that fix. This required a change in the .js files only, no change to the manifest file or any of the html pages for the…
BrendanOtherwhyz
  • 471
  • 4
  • 9
2
votes
0 answers

RichApi.Error: There was an internal error while processing the request

I have developed an Excel Javascript plugin using the React framework. The add-in workflow is simple. Request data from Ui using APIs Passing entities' column names and authorized API keys Start writing data into an active Excel sheet by pulling the…
Shiv Yadav
  • 467
  • 2
  • 11
2
votes
1 answer

How to create hierarchy key options in Excel

I'm new to Excel add-in. I searched for hierarchy options but failed to find anything. My questions are: Can we create this type of hierarchy in the office js? Can we disable the items based on some condition? Can anyone guide on me this?
Shiv Yadav
  • 467
  • 2
  • 11
2
votes
1 answer

Excel javascript API: While running the long process, and when data started writing on excel, workbook is freezing

I have developed an Excel Javascript plugin using the React framework. The add-in workflow is simple. Request data from Ui using APIs Passing entities' column names and authorized API keys Start writing data into an active Excel sheet by pulling…
Kishan Vaishnani
  • 234
  • 1
  • 12
2
votes
1 answer

Startup behavior doesn't work in Excel Desktop

I have an OfficeJS Excel Addin which is used in Online Excel and Desktop Excel. I use feature Office.addin.setStartupBehavior(Office.StartupBehavior.load); And it work fine for Online Excel: every time I start the excel - the plugin loads in…
yamaxim
  • 171
  • 2
  • 6
2
votes
0 answers

Right approach for updating linked .js files to already published add-in

Add-in is already published on AppSource. There is a new feature or bug fix implemented in .js file linked in taskpane.html of the official version. Should an update to add-in be done using Partner Center or a simple update of linked .js file is…
maleta
  • 415
  • 4
  • 16
2
votes
1 answer

How to clear style of table in office js

I have created a table using office JS. When it's displayed in the excel sheet by default it's deployed in the "Blue, Table Style Medium 2" format. I don't want any style in the excel table. I had read some answer of question but in that answer,…
Shiv Yadav
  • 467
  • 2
  • 11
2
votes
1 answer

How to get `yo office --project-type excel-functions` working properly?

I spent couple of days trying to find the reasons why I can't seem to get yo office template` to be funcioning properly. I read the following guid like 20 times https://learn.microsoft.com/en-us/office/dev/add-ins/tutorials/excel-tutorial trying to…
Andrius Solopovas
  • 967
  • 11
  • 41
2
votes
1 answer

Backup worksheets in js, delete all and finally restore it

Currently I'm triying to find a solution that helps me to storage the content of the worksheets in some place like localstorage for example. async backupSheets() { await Excel.run(async (context) => { var worksheets =…
cgodev
  • 21
  • 2
2
votes
0 answers

Remove all event handlers from worbook/worksheet/table

I'm using ScriptLab to play with event handlers. Every time I run a script, a new event handler is registered. I know how to remove one event handler, but everytime the code execution is refreshed, it is not possible anymore to delete the event…
Felipe Costa Gualberto
  • 1,075
  • 7
  • 22
1
2 3
…
14 15