Spreadsheets in Space just became more powerful with a new API in Microsoft Excel
We are always looking for new ways to help people do more and create new experiences, so the Excel team was excited to collaborate with CCP Games as they developed a powerful new Excel add-in that will supercharge the EVE Online game experience by making data analytics accessible to all players, no programming knowledge required. This valuable tool enables players of all skill levels to effortlessly access and analyze data to optimize gameplay as they strive for galactic domination.
When does the "Get Started" callout display for a Office Taskpane integration
I have an Office Taskpane application using the DeskTopFormFactor and I am having trouble making sure that my changes made to the <GetStarted> aspect of the manifest when I deploy it to my office environment. The integration does appear after a period of time correctly however I have been unable to see the "Get Started" dialogue to show other members of my team for validation on its text and behaviour. Is there a way to show the callout after the add-in has been added? Also under what conditions should this notification show for an average user?
Seeking skeleton web-addin (Outlook / AngularJS / asynch dialog)
I have been trying for many months to develop : an Outlook web add-in using AngularJs. when the user clicks a button on the ribbon bar (not compose or read frame) an asynch dialog is launched, using displayDialogAsync() I have found many demos which have on or more of those requirements, but not which fits them all 😞 Really, I don't care too much about what I consider to be "just the framework" (no offence intended), I just want to drop my AngaulrJs app into that asynch dialog. Does anyone know where I can find a demo which ticks all of those boxes, which I can eviscerate and drop my won code into?Office Add-ins developer community call, January 9th at 8:00am PST
Join us for new monthly community call to connect with the folks who are building the Office JavaScript APIs. January agenda: Office Add-ins overview What's new: Outlook JavaScript API Customer Demo of an Excel add-in that implements add-in commands, a task pane, and custom functions What's new: Excel JavaScript API Q&A https://aka.ms/officeaddinscommunitycall
Refresh Salesforce data into an Excel file on Sharepoint on daily/weekly schedule and automate tabs
Hi, I am pulling Salesforce objects data via power query into an Excel 365 file kept in a sharepoint folder. Right now, to update the file at scheduled times, i have to open the online file in Excel App, refresh power query, then do some manipulations, calculations to the sheets and then save and close it. What i want to do is automate it: Pull Salesforce data into the closed Excel file kept on Sharepoint using Javascript API, instead of Power Query. Trigger multiple hourly/daily/weekly refreshes to Salesforce data. Automate some manipulations, calculations in online closed Excel file using Javascript API once a refresh is complete. Can someone help here on how this can be achieved?
Is Microsoft Whiteboard an add-in or a service?
I'm a developer. Someone know exactly what Microsoft Whiteboard is? Is it an add-in or a service? Eg.: ref to Admin Center Microsoft Office 365, menu Settings > Services & Add-in > Whiteboard Is it possible to interact with Microsoft Whiteboard through an add-in? Is office-js able to make this link for we create an add-in to Microsoft Whiteboard? Or, is it possible for we incorporate the Microsoft Whiteboard into our app/webpage like an "extension" of our web/app? The target would be create and link a Whiteboard for embedded use. Any tip is welcomed. Thanks since now.
javax.mail.AuthenticationFailedException: LOGIN failed
We are facing issues to connect to the Office365 mailbox from java class on/from DB server(Oracle 11.2.0.4.0).The following error is thrown javax.mail.AuthenticationFailedException: LOGIN failed. at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java) at javax.mail.Service.connect(Service.java) 1. The same code on other server is failing for the same mailbox. 2. The same code on the same server is failing for other similar mailbox. 3. java.net.SocketPermissions for connect,resolve for outlook.office365.com are enabled to the DB user 4. Port = 993, protocol = IMAP, server= outlook.office365.com, JDK on DB server: 1.6.0_43, JavaMail Version tried 1.3.2 / 1.3.5 / 1.5.6 Following is the code used to set IMAP properties: private Properties getIMAPProperties(String protocol, int port) { Properties props = System.getProperties(); props.put("mail.imap.host", "outlook.office365.com"); final String SSL_FACTORY = "javax.net.ssl.SSLSocketFactory"; if (protocol.equalsIgnoreCase("IMAP") || protocol.equalsIgnoreCase("IMAPS")) { // Set manual Properties props.setProperty("mail.imap.socketFactory.class", SSL_FACTORY); props.setProperty("mail.imap.socketFactory.fallback", "false"); props.setProperty("mail.imap.port", "993"); props.setProperty("mail.imap.socketFactory.port", "993"); props.setProperty("mail.imap.auth.plain.disable", "true"); props.setProperty("mail.imap.auth.gssapi.disable", "true"); props.setProperty("mail.imap.auth.ntlm.disable", "true"); props.setProperty("mail.imap.ssl.enable", "true"); } return props; } Below is the excerpt of the Store usage in the Java code on DB server import javax.mail.Store; Store store = null; store = session.getStore(protocol.toLowerCase()); --protocol = IMAP store.connect(server, port, username, password); --ERROR is thrown at this step
Can not view json api data using ajax and javascript for Outlook plugin
I am creating an outlook plugin for one of my projects and I used the Visual Studio VB Outlook Add-In to create the predefined template. The HTML file works well but the script in HTML file has issue processing the ajax success() function. The office libraries do not let the native java script functions run (like alert statements). The data from API can be viewed in console but cannot be caught using a DIV or JSON(stringify) methods. Here is HTML Code: <form id="loginform" class="loginform"> <div> <input type="text" id="server" placeholder="SERVER" required /> </div> <!--<div> <input type="text" id="username" placeholder="USERNAME" required /> </div> <div> <input type="password" id="password" placeholder="PASSWORD" required /> </div>--> <button type="submit" id="btnLogin" onclick="return getLogin();"> LOGIN </button> </form> <div> <p class="apidata"> The API Data is : <br /> </p> </div> Here is the script which is in the same HTML File <script type="text/javascript"> function getLogin() { var server = document.getElementById("server").value; var usableURL = "https://customer.xyz.com/biolink/" + server + "/rest/v1/alarms"; $.ajax ({ url: usableURL, type: "GET", cors: true, dataType: 'jsonp', jsonp: false, jsonpCallback: 'callback', crossDomain: true, contentType: 'application/json; charset=utf-8;', secure: false, cache: false, headers: { //headers here }, data: { "sdate": "2019-05-01T00:00:00", "ack": "false", format: "json" }, success: function (response) { console.log(response); alert(response); $('#apidata').html(JSON.stringify(response)); //var s = $.parseJSON(response.responseText); document.getElementById("apidata").innerHTML = JSON.stringify(response.responseText); }, error: function (error) { console.log(error); } }) return false; } I can not get the data into DIV here and my data type has to be jsonp because the rest api i am trying has CORS enabled Any way to solve this view issue?
Sharepoint 365 doesn't render the Javascript Code Inside the Script Editor
I have having issue with SharePoint 365 where the .aspx file doesn't render the JavaScript code in the script editor. Here is my scenario: I have a JavaScript script file named helloworldtest.js in my Site Assets Folder I have HelloWorld.aspx file in my Site Pages Folder JavaScript file (helloworldtest.js) has following code: alert("Hello World! This is Test Ran by Bee"); I have added the JavaScript code in the Script Editor section on HelloWorld.aspx page. Below is the code I added in the script editor section: <script type="text/javascript" src="../SiteAssets/helloworldtest.js"></script> Problem: I think my java script file and script correct on the script editor in .aspx file but SharePoint 365 is not rendering the alert. I am new to SharePoint 365 so if anyone has any experience working with SharePoint 365 script editor and have gone through this problem before, please help me out here and be kind enough to tell me your experience and solution that you adopted. Thank You!
