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
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
Comments