Stack Overflow
Stack Overflow

Questions tagged [excel-web-addins]

212 questions
0
votes
1 answer

Header not visible

I don't want a header on the table. For that, I passed the false in the tables.add method and also used the showHeaders:false for not visible the headers in the table. The table headers are not visible but there is one single row displayed at the…
Shiv Yadav
  • 467
  • 2
  • 11
0
votes
1 answer

Office.onReady does not run when Microsoft addin is initalized

I am working on a Microsoft Office Addin TaskPane project. typescript is my choice of language. Also the addin is enabled for shared runtime. So the challange I am facing is my Office.onReady does not get called until I show taskpane since office.js…
vibhor Gupta
  • 103
  • 11
0
votes
2 answers

Hide Task pane in microsoft office add-in by default when Excel workbook is opened and when add-in is initialized in Excel

I am making a Excel task pane add-in using React and the Excel JavaScript API. The issue I am facing is the add-in task pane is visible by default when I open a new Excel worbook or when addin is initialized in excel. I have gone through multiple…
vibhor Gupta
  • 103
  • 11
0
votes
0 answers

Excel ScriptLab Function always return #N/A why is that?

I have a very basic function that I copied from microsoft site, it is getting registered correctly and appears in the formula but result is always #N/A no matter which parameters I provide. What am I doing wrong? /** * Adds two numbers. *…
Andrius Solopovas
  • 967
  • 11
  • 41
0
votes
0 answers

excel js addin XYScatter datalabels

let me describe my situation: 1 i have an XYScatter chart in my excel js addin 2 and i need to add data labels to some of points in that chart 3 and here i have a problem - i do not understand how to set up that datalabels. in my attemptions to…
Viktor AV
  • 21
  • 1
0
votes
0 answers

Is it possible to get Workbook object from Excel online (Microsoft 365) by JavaScript API?

[What I want to do] To get Workbook object from Excel file online. Equivalent to Google Apps Script > SpereadsheetApp.OpenByUrl() or OpenById(). [Why I have to do it] To copy some template worksheets owned by me into the users' workbook by Office…
Daisuke Mori
  • 31
  • 3
0
votes
1 answer

Is it possible to include existing excel functions in a custom ribbon?

Within an Office Excel JavaScript Add in, I created a custom ribbon. Within that custom ribbon, I would like to include custom excel functions (e.g., remove duplicates). Is it possible, to include such functions? If yes, what does an exemplary XAML…
user21249614
  • 1
0
votes
1 answer

Excel Add-in Dialog open gives ""An internal error has occurred." error

I have an Excel Add-in using shared runtme which has some ribbon buttons and one of the ribbon button is used to open a dialog. However if user clicks this button frequantly, I am getting this error ""An internal error has occurred." and no page is…
Kashif
  • 85
  • 8
0
votes
0 answers

Uploading Add-In to 365 Admin Center - Deployment Failed - Next Steps?

Update: We tried uploading the manifest from here --> https://github.com/OfficeDev/Office-Add-in-samples/tree/main/Samples/excel-shared-runtime-scenario which has all public URLs and works "as is" during my test sideload and is direct from Microsoft…
FreeSoftwareServers
  • 2,271
  • 1
  • 33
  • 57
0
votes
0 answers

Handle loading state of Excel AddIn or preload AddIn on insert

I'm developing an Excel AddIn and faced one issue. 1st issue: When user inserts the AddIn to the Excel (web) - user needs to click any ribbon command to start loading plugin files. 2nd issue: When plugin already inserted, the files are being…
yamaxim
  • 171
  • 2
  • 6
0
votes
1 answer

control icon on ribbon fails to show for Office Addin for Excel instead it shows default icon

I am working on office addin where I have added a control on a custom tab. but the control does not show the Icon image specified instead it shows default icon. So how can we show the icon specified for each control in ribbon ? Reffered link:…
vibhor Gupta
  • 103
  • 11
0
votes
1 answer

Can I call a pre-xisting macro via the Office Add-In javascript library?

I am developing an Excel Add-In to list, select, and retrieve an OData source. I'd like to be able to call a macro that opens excels Data / Get Data / From Other Sources / From OData Feed and fills in the URL field according to the user's previous…
rodrigo culagovski r.
  • 5
  • 1
0
votes
0 answers

Add Hyperlinks to Range without Loop using Cell Value - Office-JS Excel Javascript

My Add-In sometimes crashes and takes up huge amounts of memory and is just generally bad performance while I iterate over a range and add hyperlinks. My hyperlinks almost always follow the formula of URL + CellValue and I wonder if I can add this…
FreeSoftwareServers
  • 2,271
  • 1
  • 33
  • 57
0
votes
1 answer

How do I send an Excel (not online) Office Add-In to a remote user so they can test it?

I am developing an add-in for desktop Excel. I want to send it to the client so they can test it. We're not on the same network, so the article: Sideload Office Add-ins for testing from a network share doesn't apply. Does the manifest.xml have to be…
rodrigo culagovski r.
  • 5
  • 1
0
votes
1 answer

Excel: TypeScript Get Username or Email Address

Due to work moving from Google Suite to Microsoft have started to learn the basics of Typescript. Previously reached an on-par grade with VBA. After reading several forums, I wondered if anyone knew how to simply get the user's name or email address…
David Howarth
  • 43
  • 5
1 2 3
…
14 15