Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Convert Excel spreadsheet to web service

A supplier of mine is looking to share their spreadsheet-based "database" with us without providing the full original spreadsheet (for numerous reasons, not relevant here). I suggested that they setup a web service to allow us to query them programatically (after all, we just want to lookup one row at a time really), but they don't have the technical ability to do this themselves.

Is there a product that allows some kind of conversion from spreadsheet to published web service, or will it be a case that they need to simply get a developer in for a few days to do it for them?

Thanks!

like image 325
Sam Crawford Avatar asked Nov 15 '22 01:11

Sam Crawford


1 Answers

They can put the Excel file on SharePoint (as a List). SharePOint lists are exposed via an API.

like image 200
Shamit Verma Avatar answered Jan 03 '23 17:01

Shamit Verma