I need to call excel service rest api as follows on the 'Summary' library in hostweb
"https://<sponline>/sites/dev/_vti_bin/ExcelRest.aspx/Summary/Group%20Summary%202014.xlsx/Model/Tables('Revenue_Jan')?$format=atom"
The call should be executed from a SharePoint hosted app using JavaScript. I'm getting 'access denied' error when using below code in SharePoint hosted app.
$.ajax({
type: "GET",
url: hostweburl + "/_vti_bin/ExcelREST.aspx/Summary/Group%20Summary%202014.xlsx/model/Tables?$'format=html'",
success: function (data) {
alert("success");
},
error: function (xhr, msg, e) {
alert("error");
}
});
If someone can point out a JavaScript code sample on how to use excel service from SharePoint hosted app it will be very helpful.