The Bigger Picture
Why you'd want to build cloud apps in Excel
Last updated
Why you'd want to build cloud apps in Excel
Last updated
XLConnect was designed to build web apps with Excel. If you look at web apps nowadays, they're typically built with a stack of technolgies like HTML, CSS, Javascript (frameworks), server side code, databases, etc. To build a webapp you need to combine quite a few technologies. The HTML/CSS/javascript is served to your browser and it them calls into API's to fetch data.
XLConnect comes batteries included with everything you need to read and write data from API's, so now you can build quite similar apps in Excel. The range of required technologies you need to master is a lot smaller, so a single person can do it. The person that understands Excel often also understands the business, removing knowledge transfer to developers. The models you want to automate are probably already made, you just need to wire them up. Lastly Excel is vastly more productive than HTML based tools, especially when it concerns.
Concluding, building apps, especially for financial modelling and reporting, is vastly more productive in Excel. Having Excel wired up to the web is a big deal.
XLConnect also lets you write data to disk, without having to design a database first. Just
XLConnect is built as a 'layer cake' of layers to make it all work. The top layer is the Excel workbook, that is designed to be foolproof for users with button. If you go lower you find They use lower layers to make it all work. If you want to, you can go down the layers and replace them with something of your own. The top is intended to be easy to use while giving you the things 80% or users will want. The top layer are build on lower layers, that you can replace with you own code if you want to do so. This requires a bit more technical knowledge but this also gives you full