3,475 questions with Office Development tags

Sort by: Updated
Updated Created Answers
0 answers

Unable to add a base64encoded image in the slide of Powerpoint on Web

I created the powerpoint office add-in to add the base64 encoded string as an image into the slide. it's working properly on Desktop but through the error on Web Step to reproduce: A. load icon list from CDN server window.onload = function () { var…

PowerPoint
PowerPoint
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
217 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-23T11:21:08.4833333+00:00
Worawit 0 Reputation points
edited the question 2024-04-24T00:35:50.4466667+00:00
Emi Zhang-MSFT 21,626 Reputation points Microsoft Vendor
0 answers

Opening an .html file with columnar data in Excel

Hi, I have an .html document that is generated by another application that I would like to import into Excel. I couldn't figure out how to paste .html into this post without having it interpreted, so I have attached it as an image below. I have also…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,451 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-23T18:44:36.4233333+00:00
Paul Kraemer 266 Reputation points
1 answer

Not able to get access token using MSAL.Net in VSTO application

I have created a VSTO Excel Add-in project (with C#, Target .Net Framework version 4.8, Visual Studio 2022, working on Windows 10 Enterprise (version 21H2)). With this Microsoft Excel add-in, I want to do authentication for my APIs by getting the…

Microsoft Identity Manager
Microsoft Identity Manager
A family of Microsoft products that manage a user's digital identity using identity synchronization, certificate management, and user provisioning.
610 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,223 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,436 questions
asked 2023-09-01T13:55:37.1333333+00:00
Krishan Kataria 10 Reputation points
commented 2024-04-23T15:19:54.97+00:00
Bernhard Kircher 0 Reputation points
0 answers

How to Save a Workbook via an Office Script

Overview My SQL Query and Related Office Script I am getting acquainted with Office Scripts and the ability to trigger those scripts via PowerAutomate flows. My Use Case I want to schedule a nightly refresh of a SQL query housed within my Excel…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-14T13:35:43.78+00:00
Seneca123 0 Reputation points
commented 2024-04-23T14:45:59.6033333+00:00
Johannes Schreiber 0 Reputation points
8 answers

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…

Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
5,476 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
865 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2022-02-11T03:49:23.68+00:00
Wilmer Torrez 16 Reputation points
commented 2024-04-23T08:31:49.82+00:00
Sevenich, Lex 5 Reputation points
0 answers

API for the connected accounts

I am trying to create the Microsoft outlook add-in using JavaScript API but I'm having trouble with a following thing. I have connected multiple accounts in my outlook desktop application and I want to get the list of connected accounts in my add-in…

Outlook
Outlook
A family of Microsoft email and calendar products.
2,941 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-23T08:16:52.8733333+00:00
Rohan Jalil 0 Reputation points
0 answers

In Excel's Python, when running a double for loop, it shows "timeout".

import pandas as pd for index, row in df1.iterrows(): invoice_num = row['num'] for index2, row2 in df2.iterrows(): if row2['num'] == invoice_num: receivable_balance = df1.loc[index, 'rece‘] - row2['come'] df1.loc[index, 'rece'] =…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,451 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-23T01:36:19.53+00:00
原 田 0 Reputation points
edited the question 2024-04-23T08:06:05.27+00:00
Emi Zhang-MSFT 21,626 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How do I update a cell in Excel without firing an Change event?

I'm trying to backfill a cell that is used to hold a function parameter. The new value may be different from the original, hence the need to update. What I don't want to do is execute the function after the new parameter is set.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,451 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-22T23:34:06.97+00:00
Da Grizz 0 Reputation points
accepted 2024-04-23T06:54:48.0433333+00:00
Da Grizz 0 Reputation points
1 answer

[excel] how to do "enter" in a cell or how to calculate the cell with VBA

Good evening all, First of all english is not my mother langage, so I apologize, I have a question about a VBA I made a macro that works but not in the way I want. I have a sheet that is the sum of a yearly planning updated monthly. In this sheet I have…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,759 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,451 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-22T13:35:37.93+00:00
Baptiste 25 Reputation points
commented 2024-04-23T06:17:56.66+00:00
Baptiste 25 Reputation points
0 answers

Workbook button for Excel Scripts permission issue : The button cannot run because the script was unshared. Contact the owner to share it again.

I created 3 Excel Scripts , added buttons to the workbook for each script, and shared the excel spreadsheet through Teams, and also the scripts on sharepoint with other folks in my organization. When they opened the excel sheet and tried to run the…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-23T02:46:50.49+00:00
Dheeraj Kaul 0 Reputation points Microsoft Employee
0 answers

Word JSAPI 1.6 paragraph events not firing?

Hi, I cannot get Word JSAPI Document paragraph events to work. What am I doing wrong? 'use strict'; (function () { // move global initializations (if any) to Office.initialize // is called after document is loaded Office.onReady(function ()…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
657 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-22T07:54:25.26+00:00
De Winne, Paul 0 Reputation points
edited the question 2024-04-23T01:56:15.9366667+00:00
Jiajing Hua-MFST 4,675 Reputation points Microsoft Vendor
0 answers

VSTO on VS code?

Is it possible to do VSTO development on VS code?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-22T17:16:29+00:00
Jonathan Brotto 40 Reputation points
edited the question 2024-04-23T00:52:06.8233333+00:00
Tianyu Sun-MSFT 27,106 Reputation points Microsoft Vendor
0 answers

ERROR: -2147467259 - Unable to get property 'restorePruning' of undefined or null reference

We have a perl script on a Linux server that invokes a VBScript on Windows Server 2019 to refresh the data in an excel pivot sheet and then save a copy of the same without the data connections. We randomly face an error in this process, but the issue is…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,451 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,451 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-22T14:15:43.4933333+00:00
Abhishek Mendon 0 Reputation points
edited the question 2024-04-23T00:32:37.21+00:00
Emi Zhang-MSFT 21,626 Reputation points Microsoft Vendor
0 answers

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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,451 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
865 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-22T11:20:07.47+00:00
Cooke, Scipio UK/LPL 0 Reputation points
edited the question 2024-04-23T00:31:35.3433333+00:00
Emi Zhang-MSFT 21,626 Reputation points Microsoft Vendor
1 answer

Office Script

When there will be in Office Script: Alert(), Confirm(), Prompt(). It's the minimum to interact with the user and guide them.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,451 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-21T20:05:13.46+00:00
GIVANILDO SILVA DE AMORIM 0 Reputation points
answered 2024-04-22T22:39:01.05+00:00
GIVANILDO SILVA DE AMORIM 0 Reputation points
0 answers

Getting error in updating the Graph API version for creating worksheet

Hello there, I have written some code for my project, where I'm creating the worksheet using the Graph API version 5.42 in Java. Now I'm updating the version to the latest one, and it is not showing the below error for the respective code. Error showing…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,759 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,557 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-22T09:26:12.48+00:00
Ashish Gupta 0 Reputation points
1 answer

How to write dynamic array references inside a XLOOKUP and FILTER functions

Dear community, I will appreciate your help, advice and support with the following: I have a master file with all of the residents contributions for maintenance and repairing on our house group. From this master file, I'm looking up for each resident…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions
asked 2024-04-15T19:56:36.43+00:00
Rafael Morales 0 Reputation points
edited the question 2024-04-22T06:54:53.62+00:00
Jiajing Hua-MFST 4,675 Reputation points Microsoft Vendor
0 answers

WOPI Implementation - Word Add-in

Hi Team, Using WOPI protocol(https://learn.microsoft.com/en-us/microsoft-365/cloud-storage-partner-program/online/), I have integrated office for the web where secure connection has been established between host and WOPI client using handshake…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-22T06:24:56.3766667+00:00
Vidhi Rathi 0 Reputation points
1 answer

Apply Conditions on incoming emails in microsoft addin development

I have a query related to Microsoft Outlook add-in development: I am working on Microsoft outlook add-in development in Javascript and I want to perform some conditions and actions on incoming emails for example: whenever an email is received in my…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
asked 2024-04-19T13:56:11.71+00:00
Rohan Jalil 0 Reputation points
edited the question 2024-04-22T06:01:20.0233333+00:00
Rohan Jalil 0 Reputation points
0 answers

API for Microsoft Excel is not working properly.

Hey, I am connecting you on behalf of Pabbly Connect. Within our integration, we have set up an action event "List Worksheet" which is currently throwing an error and we are not able to use a list worksheet. Here is the URL for your…

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,557 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,475 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions
asked 2024-04-18T11:41:46.9633333+00:00
Neeraj Agarwal 0 Reputation points
commented 2024-04-22T06:00:30.2333333+00:00
Neeraj Agarwal 0 Reputation points