1

I am creating a workflow on SharePoint online using SharePoint designer. In it, I would like an action that retrieves the contents of cell(s) in excel workbook in a SharePoint document library. Please help with idea to achieve this. I have read a little about using Odata but I am not sure how to go about it. I am new to programming and using web services in workflows.

3
1

I tested this quickly, it works just fine and I guess it is what you are looking for (access to Excel table using ODATA):

https://mysite.sharepoint.com/intranet/_vti_bin/ExcelRest.aspx/MyLibrary/MyFile.xlsx/Odata/Table1

You can use further ODATA statements such as $select, $filter to do more granular queries.

Please make sure your Excel data area is setup as a Table before your try this. You can get a list of tables available in a workbook simply typing above URL without /Table1 part.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.