EXCEL REST API SAMPLE


Get Sheet Data in HTML, JSON, Image , ATOM

https://mydomain.sharepoint.com/sites/Testsite/_vti_bin/ExcelRest.aspx/Shared%20Documents/General/@{items('Apply_to_each')['name']}/model/Sheets('Sheet1')


###########################################################
Get Excel Range Data Data in HTML, JSON, Image , ATOM

https://mydomain.sharepoint.com/sites/Testsite/_vti_bin/ExcelRest.aspx/Shared%20Documents/General/dashboards.xlsx/Model/Ranges('Sheet1!A4%7CI18')?$format=image

https://mydomain.sharepoint.com/sites/Testsite/_vti_bin/ExcelRest.aspx/Shared%20Documents/General/dashboards.xlsx/Model/Ranges('Sheet1!A4%7CI18')?$format=html

https://mydomain.sharepoint.com/sites/Testsite/_vti_bin/ExcelRest.aspx/Shared%20Documents/General/dashboards.xlsx/Model/Ranges('Sheet1!A4%7CI18')?$format=json