Stack Overflow
Stack Overflow

Questions tagged [excel-web-addins]

212 questions
0
votes
2 answers

Can we make dynamic URL in manifest file in officejs?

I am new to office addins. I want to add the environment variable. As in the below manifest code, we can see that the URL http://localhost:3000/ is repeated again and again. I want to store this URL in any specific place or in any file and after…
Shiv Yadav
  • 467
  • 2
  • 11
0
votes
2 answers

How to create custom function in excel add-in using office JS in already existing react project

I am new to a custom function. I already have a react project. I want to use one custom function in that project. I have read the document about it. It has two options either you can create a react js project or you can create custom function…
Shiv Yadav
  • 467
  • 2
  • 11
0
votes
1 answer

How do I get the ranges of a multi area range name?

The NamedItem object has a getRange() function, but I get the error message "This operation is not permitted for the current object" When I use it on a NamedItem which has two noncontiguous ranges. Is there any way to get the ranges from a…
Samuel Diaz
  • 23
  • 5
0
votes
1 answer

Format Range as Currency - Excel Javascript

I'm trying to format a cell as Currency via Excel JavaScript API. I've tried currency and $ but neither work. What do I need to do? var Rev_Rng = ws.getRangeByIndexes(2, Header_Arr.indexOf("Est. Revenue"), Used_Rng_And_Props.rowCount - 2,…
FreeSoftwareServers
  • 2,271
  • 1
  • 33
  • 57
0
votes
1 answer

How to mock a NamedItemCollection in office-js using Office-Addin-Mock

I am trying to mock Named ranges array of excel so i can run some tests on adding and removing custom ranges, but it appears that the mock object is not equipped to handle arrays? Using Jest and in Angular. As per the documentation i am mocking the…
Harry
  • 3,333
  • 3
  • 18
  • 28
0
votes
1 answer

How can I get the Sheet Options (Left to right or right to left) from Excel JS

I have an Excel file that is written in Right to Left instead of the default layout Left to Right. (You can change the sheet options by going into Page Layout -> Sheet Options -> select Sheet Right-To-Left). How can I figure out which direction my…
A Glazer
  • 21
  • 3
0
votes
1 answer

How to detect if a COM version is installed from OfficeJS?

We have an existing COM-based Excel add-in, we created a JS-based add-in so we can offer similar tooling for our MAC users. JS add-in works well, but when it's added to a file opened on PC, both our COM and JS add-ins will be loaded, which is a…
bvd
  • 1
0
votes
0 answers

Is it possible to keep officeJS add-in logo same in white mode and dark mode or any other?

I have made a project in excel add-in. There is one issue regarding logo. When I use office default theme the logo is remaining same. but when I use dark theme, the logo will automatically changed. I have attached the screenshot. Logo in system…
Shiv Yadav
  • 467
  • 2
  • 11
0
votes
1 answer

OfficeJS Excel Keyboard Shortcuts Not Working

I have done everything in the documentation Manifest, Webpack, Associate, Shortcuts.json file Everything is exactly as it should. No keyboard shortcut seems to be working. I am on a windows laptop. I build the add-in, the functions work, but the…
OliveAvocado
  • 1
  • 1
0
votes
1 answer

Convert Text to Number - Excel Javascript

I've got a range that is originally formatted as "General" or @ and I've tried to convert it back to numbers. Technically, it's working, the cell format shows as "numbers" in Excel. But, the only way I can get the numbers to behave correctly (show…
FreeSoftwareServers
  • 2,271
  • 1
  • 33
  • 57
0
votes
1 answer

Creating Custom Function in Excel for Office Add-in

Currently I have an World Add-in which can be used on Excel too by adding Excel as a Host but I just want to know if the same add-in supporting Word and Excel as hosts can be used to create excel functions too. I've tried to make changes to manifest…
suyash muley
  • 1
  • 1
0
votes
1 answer

Office js Excel Add-In Sharing state across workbooks

I have recently moved from developing VBA Excel Add-Ins to using the new Office JavaScript Add-ins platform. I am used to my VBA Add-In being active across the whole of Excel and the state of the variables is available no matter what workbook you…
Shaun Pendrigh
  • 1
0
votes
1 answer

Office Add-in for multiple platforms

I'm new to creating office add-ins and I already have a Task Pane Office add-in created for Word using Yeoman generator and using Angular Framework. can it be updated to support Excel also? After going through manifest.xml Document is the only…
suyash muley
  • 1
  • 1
0
votes
1 answer

Excel office JS api - worksheet rename event onNameChanged is not working on desktop excel

Using below code to identify worksheet rename event and perform activity after rename. Same is working fine in online version of excel(online office365) on Chrome/edge browser but its not working on desktop version of excel(Microsoft 365 MSO…
sagar
  • 464
  • 4
  • 13
0
votes
1 answer

How to automatically show task pane for non-function add-in when opening worksheet?

How can we tell Excel (Web and Desktop) to load but not show an add-in automatically when a workbook is opened? We want code in the add-in to check the worksheet and, if our add-in has been used on it, open the add-in task pane automatically (though…
T.J. Crowder
  • 1,031,962
  • 187
  • 1,923
  • 1,875
1 2 3
…
14 15