Excel Services REST API
You may need to read the content of your Microsoft Excel document in a document library on the SharePoint Online site. For this, you can use the Excel Services REST api, which is served from /_vti_bin/ExcelRest.aspx.
For use, of course, you first need a Microsoft Excel document. Prepare a Microsoft Excel document that contains a table and upload it to your document library in SharePoint Online.
Then you can get your document content in json format with a URL like the one below.
/_vti_bin/ExcelRest.aspx/Shared%20Documents/Book1.xlsx/Model/Ranges(‘TEST1RANGE’)?$format=json
“TEST1RANGE” is my table’s name on Excel file.
You can find a full sample on my Github repository.
https://github.com/evrenayan/ExcelServicesREST/tree/master/ExcelServicesRESTAPISample