Questions tagged [excel-web-addins]
212 questions
0
votes
1 answer
Excel Addin not loading taskpane on installation
I am trying to open taskpane when user opens excel file. I explained details below on how I approached the problem. This is working fine in excel desktop but not in excel web.
I was trying to open taskpane on opening the excel file. I created Excel…

Raja Sekharam
- 1
- 1
0
votes
1 answer
Office.js - Excel js AddIn copy to clipboard
I was trying to copy data to clipboard as part of custom tab ribbon commands in Excel using copy-to-clipboard(https://github.com/sudodoki/copy-to-clipboard). This npm package internally using document.execCommand(‘copy’) commands to copy data to…

Raja Sekharam
- 1
- 1
0
votes
1 answer
"Your administrator has not installed Web Add-ins for your organization" when try to add Office Add-in for SharePoint 2016 + Office Online Server
My environment:
1st VM/server: Active Directory Domain Controller
2nd VM/server: SharePoint 2016 On-Premises
3rd VM/server: Office Online Server (old Office Web Apps) also
On-Premises - version from November 2017
Done already:
Communication…

bart
- 1
- 1
0
votes
1 answer
Get Last Column in Visible Views Index - Excel - Office-JS
I'm trying to filter the last column on a worksheet but I can't seem to get the Index of the column. To be clear, I need the index relative to the worksheet, no the range. I used VisibleView to find the Column, but there may be hidden rows, so my…

FreeSoftwareServers
- 2,271
- 1
- 33
- 57
0
votes
1 answer
How to add ribbon in excel web-addin in visual studio
how can I add excel ribbon in excel web addin in visual studio to create excel plugin

trevor
- 1
- 4
0
votes
1 answer
Developer Component Stay Active
I do and did some test from VSCODE with yo Office.
After few tests, Excel Developer Component displays this :
All the corresponding projects have been deleted. But menu options still remains and still work.
I'm looking for remove them.
I followed…

Eric Guesdon
- 1
- 1
0
votes
2 answers
Apply Conditional Formatting - Duplicates - Excel Javascript
I'm trying to add Conditional Highlighting to a column in Excel via Office-JS. I used the automate feature for the first time, but I can't seem to get it to work in Excel.
This is what automate spat out:
function main(workbook: ExcelScript.Workbook)…

FreeSoftwareServers
- 2,271
- 1
- 33
- 57
0
votes
1 answer
Excel API 1.1 - error while adding content to table
I'm trying to create an ```Office add-in`` for Excel but encounter the following problem.
This occurred after updating de server.
Setup:
Excel API 1.1
Windows Server 2019 Standard (17763.2565)
Office 2016 (16.0.52)
Code:
export async function…

roapp
- 530
- 6
- 17
0
votes
1 answer
Officejs BubbleChart- Scale bubble size and set axes value scale
I have created a bubble chart following sample at https://github.com/OfficeDev/office-js-snippets/blob/main/samples/excel/10-chart/chart-bubble-chart.yaml
I would like to know how to set via api. A code snippet would be helpful.
Axes Scale - X axis…

JNN
- 13
- 2
0
votes
1 answer
How to specify positve and negative values for custom error bars
Thanks the API office.js, I'm displaying a bar chart. Now I want to add custom error bar on each data bar.
The following image shows the result obtained using Excel vba:
But in the spec of the API office.js, I don't find any information about how…

Sami.S
- 267
- 1
- 13
0
votes
1 answer
Do I need a domain to host Excel add-ins
I'm trying to host an Excel add-in.
I have a few questions:
Do I need a domain for that, or can I use an IP address? I assume I have to use a domain since I need HTTPS.
Should a domain be a separate domain for hosting add-in, and not this where I…

Tomasz Decker
- 114
- 2
- 14
0
votes
1 answer
Exceljs App "is working on your function" message
I modified an Excel ScriptLab function to remove duplicates and I run it as a button from the Ribbon.
async function RemoveDuplicates() {
await Excel.run(async (context) => {
const sheet = context.workbook.worksheets.getActiveWorksheet();
…

Tomasz Decker
- 114
- 2
- 14
0
votes
0 answers
Excel JS Add-In with IE11 - Dialog API stops execution of code until you open F12Chooser or IEChooser
I have an Excel JS Add-In where I am leveraging Dialog API with the displayDialogAsync method. With Edge, it works perfectly and the handler gets triggered and the code runs fine. But if the add-in is loaded in IE11 browser IFrame, the dialog stays…

nikhilism
- 19
- 3
0
votes
0 answers
Microsoft Validation test failed: 1100.7.3 Duplicate Offer
I have created two office 365 web add-ins which uploads my office documents(.pptx and .xlsx) to our document management system.
When I am trying to publish both on Microsoft Appsource; I got this failed report stating
Easy Identification
1100.7.3…

Asmi
- 157
- 1
- 1
- 14
0
votes
0 answers
Why can I not side-load a developer web add-in in Excel (works fine on other machines)?
My team is developing an Office web add-in for Excel built in vanilla Javascript. To test and debug our project, we have been side-loading the add-in as per the usual steps.
Which are:
Navigate to…

Jake Chambers
- 513
- 2
- 6
- 22