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…
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…
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…
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…
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)…
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…
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