Questions tagged [excel-web-addins]
212 questions
0
votes
1 answer
Sort Column - Excel Javascript
I'm trying to figure out how to sort a column in Excel. I read here --> https://learn.microsoft.com/en-us/javascript/api/excel/excel.rangesort?view=excel-js-preview
But they don't give any useful example.
Here is a basic example I'm trying to figure…
FreeSoftwareServers
- 2,271
- 1
- 33
- 57
0
votes
1 answer
console.log() lines are not matching up correctly in React Office Add-in
I started work on my React add-in project for Excel yesterday and VSCode popped up with a recommendation to install 'Microsoft Office Add-in Debugger' extension. So I installed it, and ever since the lines in my console are not matching up to my…
henry434
- 97
- 1
- 9
0
votes
1 answer
Show notification in add-in using officeJS API
I have implemented error message for excel add-in using fluent UI. If the text box is empty, then it will print message in the DOM. For error message image is below
Now, this message is displaying in the React DOM. I want to display this message in…
Shiv Yadav
- 467
- 2
- 11
0
votes
2 answers
Find out which office.js requirement set my code is using
I would like to integrate into my CI/CD pipeline a requirement set condition.
I'm developing an Office.js Excel addin and I would like to track client compatibility.
There is a way to inspect code to detect the maximum value of requirement set?
The…
Claudio
- 3,060
- 10
- 17
0
votes
1 answer
Excel Addin: How to Find if a string is valid reference to a cell or not
I am working on an Excel Addin and I need to validate user input to check if it is a valid cell reference or not. I tried to find it in documentation but I have not found anything yet.
Following are simple strings formats I know that address can be,…
Kashif
- 85
- 8
0
votes
1 answer
Designing a ribbon button in OfficeJs using manifest
Is it possible to add spacing in between ribbon buttons? I cant seem to design the ribbon in anyway and am constricted to OfficeJs standards.
I would like to design my ribbon, I am currently developing using AngularJS and have created my own custom…
Jaja
- 3
- 1
0
votes
1 answer
Open 'Insert Hyperlink' menu in Excel office Add-in
I want to open the 'Insert Hyperlink' menu programmatically without right clicking the…
Nikhil Patil
- 3
- 2
0
votes
1 answer
Excel Custom Function not supporting in Other Office versions
I have created an excel custom function in SharedRuntime. I have used JavaScript 1.1 version and SharedRuntime 1.1 version. My custom function is working fine in office 365, but it's not working in offices 2013, 2016, and 2019.
I don't know why this…
Shiv Yadav
- 467
- 2
- 11
0
votes
1 answer
I am developing an application with Office JS I try generate base64 with workbook is possible?
I am developing an application with Office JS I try generate base64 with workbook is possible?
generate base64 with workbook
Emmanuel Campos
- 3
- 1
0
votes
1 answer
How to create dynamically headers in excel using javascript Api
In excel we create a table we have to pass a static address for adding columns to the table.
I want to add columns dynamically, not bypassing the excel address. Is this possible in excel?
await Excel.run(async (context) => {
let sheet =…
Shiv Yadav
- 467
- 2
- 11
0
votes
1 answer
Microsoft Office Add In - How to detect a built in button on the ribbon is clicked (i.e. bold clicked)?
I'm currently trying to develop an add in for Microsoft Excel and have spent a lot of time going through https://learn.microsoft.com/en-us/javascript/api/office?view=common-js-preview to learn what is available through the API. However, I cannot…
drewvlaz
- 1
- 2
0
votes
1 answer
Custom functions DataType to make text in cell bold office.js
Are there any ways to make the text bold without using the Excel.run method in a custom function?
I found how to format the numbers, but I could not find the formatting of the…
Artem Ga
- 5
- 1
0
votes
0 answers
Active Row Column Highlight in Office 365 Excel (web version)
I want to highlight active row or column in office 365 excel (Web Version).
I have added script lab add in but I am not a programmer. Can anybody help me with the code or any alternative way for the same.
Tried using VBA code in Script lab but that…
0
votes
1 answer
Excel Web Add-In using Querytables
Does anyone know how to use the Querytable object in an Excel Web Add-In?
I developed an Excel VSTO Add-In previously and would now like to use the same functionality instead of with VB in JS.
So lets say I just want to insert a querytable like I…
FlyingLizard3
- 43
- 1
- 6
0
votes
1 answer
Add combo box in OfficeJS Excel
I am developing an add-in with Office JS, In need add combobox when click in a bottom but I dont see this options it is possible
add combobox with OfficeJS
Emmanuel Campos
- 3
- 1