I am trying to read Excel file stored in Document Library using Excel Services. I need to fetch the entire workbook content in a single request call. I have tried using
Ranges using it like
Bt there I have to specify the table name/range from which I need to fetch the data. The Excel file is generated by third party source and has varying number of rows.
The closest I was able to find REST API
which returns the entire Excel file in binary format, but not in atom format.
Is there a REST API which gets the entire content of at least the first worksheet from the Excel file in ATOM format? Is there any efficient way to read all the rows in Excel file using Excel Services in a single (or less) REST API call?