filmov
tv
Excel REST API Sample for Java (Jersey Client)

Показать описание
Early of this month(3rd Aug 2016), Office 365 Excel REST API was released as GA.
Graph API for Excel
And Today I created the sample application of it and created the demo video (by Japanese).
So I would like to share the information to all of you.
Demo Video :
Sample Source Code
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 application.
However it may be run on servlet container like Tomcat/Jetty.
I used following technologies.
I used the JSF (However it is not important.
Any framework for Front end technologies will be available.)
In the package, I used following technologies.
Backend Logic : CDI (Contexts and Dependency Injection)
Call to Graph API : JAX-RS Client (Jersery)
Binding JSON/Java Object : JAXB
Graph API for Excel
And Today I created the sample application of it and created the demo video (by Japanese).
So I would like to share the information to all of you.
Demo Video :
Sample Source Code
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 application.
However it may be run on servlet container like Tomcat/Jetty.
I used following technologies.
I used the JSF (However it is not important.
Any framework for Front end technologies will be available.)
In the package, I used following technologies.
Backend Logic : CDI (Contexts and Dependency Injection)
Call to Graph API : JAX-RS Client (Jersery)
Binding JSON/Java Object : JAXB