Logo Microsoft SharePoint 2010

Now with SharePoint 2010 we are be able to use REST to getting excel file data using Excel Services.

The syntax is very simple and quickly to understand. I will leave here some samples of how you can use REST to get data.

To access to your Excel file, you can use the following link:

http://<site>/_vti_bin/ExcelRest.aspx/<library>/<file>/Model

  • <site> – SharePoint site (such as createit:8080)
  • <library> – SharePoint document library that contains the excel file (such as Profits)
  • <file> – The Excel file that you want to getting data (such as ProfitsV2.xlsx)

And then you will be able to get some different type of data as the following samples:

Used Excel file screenshot (to compare with data results using REST):

 

  • Get workbook (ATOM format)

http://createbox/devplatform/_vti_bin/ExcelRest.aspx/Simulators/WorldMarkets.xlsx/Model

 

  • Get a range (HTML format)

http://createbox/devplatform/_vti_bin/ExcelRest.aspx/Simulators/WorldMarkets.xlsx/Model/Ranges('WorldMarkets')

  • Get a range (ATOM format)

http://createbox/devplatform/_vti_bin/ExcelRest.aspx/Simulators/WorldMarkets.xlsx/Model/Ranges('WorldMarkets')?$format=atom

 

  • Get a graphic (Image format)

http://createbox/devplatform/_vti_bin/ExcelRest.aspx/Simulators/WorldMarkets.xlsx/Model/Charts('Chart%201')?$format=image

LEAVE A REPLY

Please enter your comment!
Please enter your name here