Can Excel throttle cell updates?
I'm developing a plugin to relay updates from a pub/sub cache into an Excel workbook hosted within office365. Update frequency can be very high (thousands of updates a second). Is there a guard within Excel to protect itself from bursty data, in the same…
How to add backend (mongoDB) functionality to Excel add-in?
Hi I'm trying to build an Excel add-in via the JS API. I need to serve and collect data to and from the workbooks, so need some sort of database. I want to use MongoDB but trying to install it the normal way and requiring it in taskpane.js results in a…
Jquery DataTable not working after appending the html code to DataTable using jQuery
I have created a datatable and appending the data to that datatable body , data appending successfully but the datatable not working properly ex:- If I click on the datatable header columns the entire table data is erasing. Here is my full logic…
535 5.7.139 Authentication unsuccessful
We are receiving the following error using the Office 365 SMTP server to send mails: 535 5.7.139 Authentication unsuccessful, the request did not meet the criteria to be authenticated successfully. Same issue with MFA (+ App password) and without…
Can I automatically switch user input method from fullwidth hiragana to halfwidth katakana when I focus in an input using javascript or PHP?
(1) I have a form of html inputs, some of which are allowed to type in halfwidth hiragana, the others are allowed to type in fullwidth katakana. (2) Now, I need a way to automatically switch user keyboard input method between halfwidth hiragana and…
How to return file name and last modified from fileshare on azure storage using java spring boot
How to return file name and last modified from files hare on azure storage using java spring boot // Retrieve the storage account from the connection string. CloudStorageAccount storageAccount = CloudStorageAccount.parse(connectString); // Create a…
Launch events not triggering when Outlook add-in is installed from App Source
Hi. We developped an add-in for Outlook. It uses OnMessageRecipientsChanged and OnMessageSend LaunchEvents. It was difficult, but eventually we got both events to trigger and operate correctly when installed via sideloading (using …
Is it possible to get paid support from Microsoft for add-in development?
We're developing an Outlook add-in and it's being a nightmare, specially in relation to Launch Events and Outlook Classic. We would be happy to pay for support if that were possible, but we've not found how. Is there a way?
How to get auth token by user email and password?
I want to hit calendar events API in an external app. i.e. https://graph.microsoft.com/v1.0/users/{user-id}/events I have created a new app in Azure AD. Then I got hold of client id, client secret and tenant id. I have my Microsoft email and password. …
I am developing word plugin using Word javascript word Api
I want to set my page size as A4 and margin should be narrow when i will start my word plugin but problem is whenever I am starting my word plugin it sets the page size Letter size and margin is normal I am getting this issue can u help me in this . I…
getSeries() does not work in Excel scripts
Hi, I got an issue with using the getSeries() function in excel script. I want to write script to change the color of the pie chart. I did it manually and I recorded it. The below is the code: function main(workbook: ExcelScript.Workbook) { let…
Is there a way to disable the script confirmation popup the appears everytime I click on a button?
I create a simple file and I was trying to automate some processes and I notice that every time I click on the Script button it shows me a popup on the right side that says script run status, its annoying to see that everytime I click on the button. How…
how to get all work sheet names and cell details
Hello, i have the existing script in my workbook: I would like to get all the worksheet names (instead of specifying as ive done), and include it in the batch details output. Thank you function main(workbook: ExcelScript.Workbook) { const ws =…
Read/write JSON file inside Word add-in
I want to read(if possible write as well) data from JSON file. I have a React based Word add-in. The JSON file can be included in the package folder root(same location as manifest.xml). Is there any JavaScript API to read/write file data ? Also is it…
Migrating from OpenAI to Azure Open AI (Javascript)
Hi, I've been using OpenAI with javascript for an app for a few months now without any issues. My use case involves using the function calling parameters to specify a schema for a specific JSON output. I've now migrated to using an Azure OpenAI…
Problems using select in javascript
Hi friends, I have the following problem. I have 8 selects within a div, where each select has two values: 0 and 1. When I click for the first time on any select to select 0 or 1, when I click on the select arrow, it already considers that I selected 0.…
connecting oneDrive file picker v8 using JavaScript
i am trying to connect OneDrive for my client on website where they can use their OneDrive to select files to upload. oneDrive file picker connected successfully but showing empty picker like this when i check console there are some errors showing…
Exception when running QUnit test script in Visual Studio 2022
I'm encountering an issue when I try to run a QUnit test script for a JavaScript file in Visual Studio 2022. The error message thrown reads: System.ArgumentException: The specified argument cannot be empty. Parameter name: filters I've included the…
How to Access Core Properties / Custom Properties in PowerPoint Office Addin Using Javascript API
I want to access a PowerPoint document's core and custom properties in PowerPoint Office Addin. I can access these properties using Javascript API in Word and Excel Office Addins. …
How to fix Tracking Prevention blocked access to storage for https://appsforoffice.microsoft.com/lib/1.1/hosted/en-us/outlook_strings.js.
Hello, I have added the following code for connection to dynamics365 in javascript for outlook addin: <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <title>My Web…