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.
I tested this quickly, it works just fine and I guess it is what you are looking for (access to Excel table using ODATA):
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.