121 questions
-1
votes
1
answer
52
views
Gathering and pulling data from an Excel file into a Word file [closed]
Trying to develop a Word add-in such that when provided an Excel file, it can access said file and gather the contents of cells (already known/specified by default, not by the user) and then insert ...
- 27
0
votes
0
answers
45
views
How to open Taskpane automatically on Browser on Excel with Office JS?
Is it possible for Excel to automatically show the task pane as soon as the workbook opens in the browser?
I followed the steps in the link, and only Word automatically opens the task pane with the ...
0
votes
0
answers
84
views
makeEwsRequestAsync return error 9020 in Outlook web or menu item is getting null in (classic view) when creating an .eml file using Office.js?
let mailbox: any = Office.context.mailbox.item;
let envelope = `
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope
xmlns:xsi=&...
0
votes
0
answers
52
views
How to do logging in Office JS Dialog for Excel Addin?
I have an excel addin which opens a dialog. How do I see the logs from the .html page or JS code that actually calls .displayDialogAsync to show the dialog?
For instance, I have a MyFunctions.html ...
0
votes
0
answers
23
views
Office.js Excel range.insert() is moving user viewport to A1
I have a simple function on context menu option clicked which gets passed the active cell address, eg: F81, from the user and inserts a row below.
export const insertRowBelow = async (address) => {
...
- 107
0
votes
1
answer
82
views
Change color of svg icon through powerpoint web add-in
I'm developing a PowerPoint web add-in using Office.js and am having difficulty changing the color of an icon inserted into a slide. The icon is in SVG format, but I can't access the required ...
0
votes
0
answers
65
views
'Loading' text ( loader ) in task pane while initial loading in word web add-in
I'm currently developing a task-pane based Word web add-in. However, I'm encountering an issue when I try to sideload the add-in. The add-in shows a persistent loading screen (see attached image). I'm ...
0
votes
1
answer
72
views
Is there a way to get mail body in Outlook with Office.js
I am trying to create a mobile add-in with Office.js and I am using OnNewMessageCompose event.
10 second after event launched, I am trying to get body with the code below but it doesn't work.
async ...
0
votes
0
answers
45
views
Creating a consistent formula format painter with Office.Js
I am trying to develop a consistent formula painter with office.js for purposes of reviewing financial models. The script is meant to be run on the active sheet and will color code it using the ...
- 1
0
votes
0
answers
194
views
MS Powerpoint Addin : Insert Slide from Base 64 Powerpoint addin API does not carry over the original formatting of the slide
https://learn.microsoft.com/en-us/javascript/api/powerpoint/powerpoint.presentation?view=powerpoint-js-preview#powerpoint-powerpoint-presentation-insertslidesfrombase64-member(1)
I'm currently using ...
- 31
0
votes
1
answer
567
views
Excel Office.js - multiple context menu item control issue
I'm working on a new feature for an existing Excel office add-in. This feature requires a new context menu item, however when I add a new item in manifest, only the first menu item shows.
The ...
- 107
0
votes
1
answer
310
views
Is there a way to know if a powerpoint shape is selected by the user?
I'm creating an addin on powerpoint using office-js and I don't know if there is a method to check if a shape selected by the user ?
I know that in vb.net it looks like this :
Dim shape = selection....
0
votes
1
answer
378
views
BootstrapToken forMSGraphAccess in Outlook
I want to use SSO in Outlook to get the BookstrapToken with MSGrapAccess and I'm getting the error "13012". In the documentation says that this error is only possible while sideloading, but ...
- 157
0
votes
1
answer
192
views
insertSlidesFromBase64 Working on Client Powerpoint, But not on Powerpoint for the web
Here is the Code i Used
async function insertPptxFromBase64String(chosenFileBase64) {
Office.context.document.getSelectedDataAsync(Office.CoercionType.SlideRange, function (asyncResult) {
...
0
votes
1
answer
623
views
Not able to add styled text with OOXML
I am creating an office add-in for Word and i am trying to create custom styles for users to style their texts with. I came accross this example of a styled text and went to try it myself.
Here is the ...
- 11
0
votes
1
answer
753
views
read the office add-in manifest file from the react app which is inside the Outlook task pane
I'm looking for a way to read resource strings and URLs from the add-in manifest.
Does someone know a way?
Thanks!
- 165
0
votes
1
answer
544
views
How to install Addin Excel made with Angular in Excel
Situation :
I'm a newbie in add-in excel, so this could be a stupid question.
I made an Excel add-in(Side load) test project by using Angular. I followed the Microsoft tutorial
My test project works ...
- 998
1
vote
0
answers
534
views
error TS2339: Property 'comments' does not exist on type 'Worksheet'. microsoft /Office-js
I have updated "@microsoft/office-js" from ^1.1.25 to "^1.1.70" and I'm trying to use comments in my angular project.
I have added CDN link in index.html file head tag of the ...
- 11
1
vote
1
answer
1k
views
Office Js - Excel Set a Cell with Base64 Content
We are using Excel Add-in side loaded for our application. I am trying to Set a Cell Value in Excel with Base64 Encoded content (that has formatted content). I see example of how set base64 encoded ...
- 123
0
votes
1
answer
999
views
Using Office.js or Office Scripts outside of Excel or Excel Add-in
I am trying to Get the Value of the Active cell in Excel
I was able to get the Value by writing a simple Excel Add-in.
I was also able to do the same using Office-Scripts
Office-Script:
function main(...
0
votes
1
answer
353
views
PowerPoint retrieve slide data
I am trying to get the PowerPoint Slide content as byte[] or as base64, but support for this scenario in the documentation or library code is missing.
In the current implementation, I am downloading ...
- 191
0
votes
1
answer
509
views
How can I detect a content control without the user selecting the whole thing?
Background
I've inserted a bunch of content controls into my word document. Each content control is a bit of text e.g. "Hello world".
What I'm trying to do
When a user puts their cursor ...
2
votes
0
answers
88
views
Word web add-in works only after cleaning up the cache
I am working on word web add-in. There are two issues which I am always facing in non development environment.
Sometimes word add-in displays blank screen in non-dev environments. Only after cleaning ...
- 68
0
votes
0
answers
132
views
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 ...
- 19
0
votes
0
answers
101
views
Excel add-in : Delay execution while cell is being edited - not working
I've written the following code which invokes selected function and puts in a selected cell.
I've used the delay execution of a custom function till user exits the cell. But this is not working. ...
- 107
1
vote
2
answers
426
views
How to add Customized comment in MS Word using OOXML?
I am creating a word custom add-in. In that user can able to add custom comments with color, bold, or highlight or set other possible options. But when I try to use directly <b>Hello This is ...
- 451
0
votes
1
answer
45
views
Select text with similar formatting Office JS
I am passing days struggling to find a way using OfficeJS to have the same functionality offered in the Office application by this button.
Isn't there an out-of-the-box function or even a little ...
-1
votes
1
answer
235
views
ContentControlOnEnter, ContentControlOnExit alternative for office js API
For VSTO Add-In Application we do have ContentControlOnEnter and ContentControlOnExit events, to perform post change operation of ContentControl
But, I can't see any such events in office JS API
Do, ...
- 805
0
votes
0
answers
113
views
Excel crash while trying to insert VSTO addin formula from Office JS Taskpane
I am facing an odd issue while connecting VSTO addin formula with office js taskpane. Below is the scenario
There is one VSTO addin which has several formulas defined in it.
One newly created office ...
- 1
0
votes
1
answer
197
views
Why does the javascript file sometimes not load with the html for Office Addins?
I have a taskpane Office Addin that sometimes does not load the javascript file with the html. The user has to click reload a number of times before it eventually does. I know it's not rendering ...
0
votes
0
answers
70
views
How to convert an array into columns in an Excel web add-in?
I want to take an object as two columns of a selected table. How can I extract a selected column and pass it as an object? I want the barData object to be the selected columns. This code creates a ...
- 13
0
votes
1
answer
38
views
How to take chart target position as input from the user in an Excel VSTO Add-in through a textfield?
I want to create a Bar chart on Excel Add-in, but I want to get the target position of the chart from the user in a textfield, how can I use that value and assign it to the chart.setPosition ? Is it ...
- 13
2
votes
1
answer
540
views
How to get colour palette of chart in excel add-in using office JS?
We are developing an excel add-in with react and office js APIs. We have added a chart and set the color to the chart from the color palette(chart-design -> Change Colours -> Colourful palette4)....
- 126
0
votes
1
answer
723
views
Taskpane launch on ribbon load or document created or open
please is the way to pin the task pane in word and excel. or use LaunchEvents like outlook to trigger the task pane on new document which in return reopens when the document is open. I need a function ...
0
votes
1
answer
214
views
How to Split a cell in JS API for MS365 excel labscript
I am trying to split a cell/string simply in MS365 using Labscript.
Split() or LEFT does not exist in Labscript which is another reason why I am not sure why MS claims that javascript is the ...
- 11
8
votes
2
answers
2k
views
How do I add a bookmark within the body of a Word doc using Office JS
The Office JS has provided the following function in preview, but I couldn't find any example.
Here is what I tried but it doesn't seem to work, any idea what I am missing here, since this code ...
- 1,519
1
vote
1
answer
116
views
Can Events in Excel be registered without a button click?
I am trying to create events that are registered when the Excel add-in is first loaded up. I'm not sure how to get around this since I've only seen examples where they are registered with a button ...
- 151
0
votes
2
answers
3k
views
How to use JS Excel API in my web application using data from my server
Is it possible to run js excel api in my web application using data from my server. I want to use this api as a replacement of html data table.
Need a step by step guide if possible and what are the ...
- 17
0
votes
1
answer
305
views
office-js: using JS excel api as front end Data Table
Is it possible to run js excel api in my web application using data from my server. I want to use this api as a replacement of html data table.
Need a step by step guide if possible and what are the ...
0
votes
1
answer
421
views
Acquiring SSO token in mobile outlook client
I´m having trouble to get SSO working in my javascript based addin for the mobile outlook app.
With the example here
https://github.com/OfficeDev/outlook-add-in-attachments-demo
And this ...
- 41
0
votes
1
answer
95
views
Office Add-In deployed through O365 Admin Center Appears in Excel Ribbon but can´t be open
I have deployed an Office Add-in and uploaded through the O365 Admin Center The Add-In appears in the Excel Ribbon but can use it as a message appears “We could not open the Add-In from LocalHost.
...
0
votes
1
answer
688
views
Validated Excel addin manifest works in Excel locally but not in excel online
I am using Office.js to create an Excel add-in. I am hosting my website on https://localhost:3000 and installed the office dev certs.
When i sideload the manifest.xml locally with office-addin-...
- 371
1
vote
1
answer
560
views
Is there any method available in officejs to close the word document ? Or "how we can open word document in same instance"
Is there any method available in officejs to close the word document ? Or "how we can open word document in same instance (if there is an instance already open)".
- 37
1
vote
1
answer
283
views
How to make a Rest API call from Office JS using Yeomen Generator for Angular framework?
I have tried to refer a project Angular Reference Project Link from MSFT
and now i am trying to call a rest API from Angular and i am trying to create a singleton service, but whenever i try to run ...
- 193
0
votes
1
answer
65
views
why MenuContext is not working in Office Word 2016
I'm trying to develop an office-js word add-ins to enhance the right-click menu but when I'm adding the element in my manifest . Word can't read/access the manifest anymore .
So OfficeMenu is not ...
- 11
0
votes
1
answer
105
views
what is one time purchase in officejs for add-ins
just visited the this URL for office add-in availability.
What is one time purchase in office add-ins and office 365 subscription ones?
- 25
2
votes
1
answer
1k
views
Persisting the date format in excel while fetching data
We have a excel add in built using office.js. Where we read data from a data range ( ie A1:C10 ) which might consist of a date column. Please refer the image below
Our add in reads the data and form a ...
- 331
1
vote
2
answers
1k
views
Set Dropdown Value Back to Placeholder or Very First Option After onClick Event on a Button?
In the following code, I have a Dropdown and a Button. Once you select an option in the Dropdown and click the Button, that value will be sent to Excel in the active cell. After sending this data to ...
- 858
1
vote
1
answer
151
views
How to Convert String to Range After Awaiting Context.sync?
In the following async function, I am getting the active cell in Excel and then loading the row index. After the context.sync I am creating a string called "newRange". Is there a way that I can set ...
- 858
0
votes
0
answers
192
views
How to get access token through redirect url browser in Officejs excel add-in
When trying to implement below logic we were able to get access token in redirect url browser like
https://localhost:3000/taskpane.html#id_token="xxxxxxxx...." but not able to get in origin like in ...
