Using excel in office 365 how to#

Well, there is no specific Spell Check functionality on Excel in Office 365 or otherwise. to Turn on Office 365 Excel Spell Check in Worksheets? Let's extract the variables sharepointurl, schema, table from the command line node.exe app.js -f sharepointurl -s schema -t table Command line usage (Note that the exact sequence is important) Read all of the main configurable parameters Var sharepointutility = require('./sharepointutility')

Var hdbutility = require('./hdbutility') app.js - main module to read the file from Sharepoint Office 365 and then save into HANA So once we have the necessary setup done to read the data from Sharepoint, we will write the application using NodeJS. In order for the service to be called with an OAuth token with just the application id and secret, we need to apply for admin consent by the Azure admin which will allow permissions for the application to be triggered in background mode. We need to set the permissions for the app to allow reading the sharepoint data: In our case, we have named this sharepoint_excel_outlook_graph_api_hana_integration – the name could have been shorter but we wanted to have it be self descriptive enough since there were many other applications for the company. Get the application id and secret – we will need these for authentication to invoke the interface: Now in order to call this API, we need to register this application on the Azure portal. Very cool! For the Graph API, we need our Sharepoint site, GUID for the drive, workbook, worksheet and the range for the worksheet: Once you get familiar with the API and see how simple, powerful and flexible it is, you will see that you can call the Graph API and pass the Sharepoint site, workbook, worksheet and cell ranges and get the data back in JSON format very easily. Check out the Microsoft Graph API with the Microsoft Graph Explorer: Microsoft Graph Explorer Microsoft provides the Graph API which allows users to invoke APIs across most of Office 365 functionality which is very impressive including the Sharepoint integration capabilities.

Here is a screenshot of the ExcelAdapter with the Sharepoint URL we are trying to connect with and the error that is returned stating that the connection to the Sharepoint URL does not work:įirst thing first – we need to connect to Sharepoint on Microsoft Office 365.

Using excel in office 365 how to#

There will be another Blog that describes how to trigger our custom developed NodeJS application from a virtual procedure through the file adapter through SAP HANA Smart Data Integration (SDI) layer. This Blog describes the approach which will hopefully help other folks needing to accomplish this type of scenarios for integrating Microsoft Office 365 data with SAP HANA XSA. So we had to come up with an approach to address this requirement and develop it. However, the Excel adapter as of HANA 2.0 SPS 3 can only connect to Sharepoint 2013 on premise systems and not Sharepoint on the Microsoft Office 365 Cloud. We wanted to use the SAP HANA File Adapter which has a section for Sharepoint Configuration.

Our scenario requirement was to pull data from Excel files on Sharepoint on Microsoft Office 365 and write this data to SAP HANA XSA container tables. In this Blog, I would like to show how to read data from Microsoft Office 365 using Microsoft Graph API and NodeJS and then write this data into SAP HANA XSA tables.