2

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

http://<SERVER>/_vti_bin/ExcelRest.aspx/<LIBRARY>/<FILE>/model/Ranges('B8|K60')?$format=atom

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

http://<SERVER>/_vti_bin/ExcelRest.aspx/<LIBRARY>/<FILE>/model/?$format=workbook

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?

  • Can't you use 'Range(Cells.Address)' or 'Range("A1").CurrentRegion' inside Ranges of the 1st api call? – Taran Goel Dec 31 '15 at 9:20
  • @TaranGoel: No. I think you are confusing this with VB code. This is a URL so I cannot use Cells.Address or CurrentRegion. – Naveen Dec 31 '15 at 9:27
  • I haven't work on it but thought maybe it'll work..:) – Taran Goel Dec 31 '15 at 9:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.