|
|
|
|
|
|
by smt88
1761 days ago
|
|
|
No, it makes no sense. There are libraries like DataTables in .NET that do this far more robustly than you could. You could also get the full power of Excel as an API via Office's or Google's spreadsheet APIs. There are also things like AirTable that overlap as well. You seem to have thought of a solution but not a problem. What problem would this solve? (I have built a few products that simulate Excel calculations for reporting automation, so this topic is very familiar to me.) |
|
|
For the people I've talked with so far, it means 1) they don't have to re-implement the spreadsheet logic in their server, and 2) whenever the spreadsheet is updated (either Google sheet edit, or an Excel file is uploaded again) the API is automatically up to date.
Some of these people are already creating GRID documents backed by their existing spreadsheets, and have a use case to make an API call from their own systems to perform a computation that already lives in the spreadsheet.
Notice I'm not talking about writing data to the spreadsheet and using it as a database. I'm talking about reading values from a spreadsheet model through a queryable API. Not sure how AirTable and DataTables compare – will have to look into that.