For a client of mine I'm looking for a low code way to convert a complicated mortgage calculation spreadsheet (20 tabs/1000's rows) to an app so that the calculation happens in the excel but the output happens on a site/app frontend.<p>The spreadsheet is Microsoft xls. Ideally we can drag drop different components and make calculation/dashboards out of it having the excel as an engine on the backend.<p>Thank you!
There is a scripting interface for office that is pretty easy to use:<p><a href="https://docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/automate-excel-from-client-side-vbscript" rel="nofollow">https://docs.microsoft.com/en-us/previous-versions/office/tr...</a><p>You can do it with other web servers but it is dead easy to do with Microsoft's IIS and ASP.NET. I've written applications that have scripted Word from within a web server.
<a href="https://www.glideapps.com/" rel="nofollow">https://www.glideapps.com/</a>
It's backed by Ycombinator. This is a commonly used app to convert spreadsheets into app.<p>It is suggested by many startup enthusiasts as a no-code tool to make quick app prototypes[1]<p>[1] <a href="https://www.youtube.com/watch?v=7BBO3_llLss" rel="nofollow">https://www.youtube.com/watch?v=7BBO3_llLss</a>
I have an interest in converting a set of interdependent Google Sheets that do lookups on each other into a deployable application where myself and not Google owns the data.