Skip to content

Latest commit

 

History

History
120 lines (94 loc) · 5.85 KB

README.md

File metadata and controls

120 lines (94 loc) · 5.85 KB

Office-365-Excel-REST-API-for-Java

This is the sample application of Excel REST API for Java

On 3rd Aug 2016, Office 365 Excel REST API was released as GA.

https://blogs.office.com/2016/08/03/announcing-the-general-availability-of-the-microsoft-excel-api-to-expand-the-power-of-office-365/

Graph API for Excel

https://graph.microsoft.io/ja-jp/docs/api-reference/v1.0/resources/excel

And I created the sample application of it and created the demo video (by Japanese). So I would like to share the the code.

Demo Video : https://youtu.be/rdS7VPOzU0M

The Above Demo Senario:

  1. Start my sample application from IDE (NetBeans)

  2. Login to the sample application via Azure AD auth.

  3. Login to the portal screen of Office 365

  4. List all of the file in the Onedrive

  5. Open the excel file on Ondrive with browser

  6. Open the excel file from my sample application

  7. Open the worksheet of the file from my sample application.

  8. Select the table on the worksheet

  9. Add one row data to the table

10.Confirm the data which added in the above

11.Add new file to Ondrive and check again from the application

In my sample, I wrote as a Java EE 7 application.
So it will run on Java EE compatible Application Servers like
GlassFish(Payara), WildFly(JBoss EAP), WebLogic, WebSphere and so on.

It also run on servlet container like Tomcat.
If you would like to run it on Tomcat,
Please refer to the README-4-Tomcat.md ?

Configuration Step