Show HN: Create Web Calculators and APIs with Excel Spreadsheets
1–10 of 11 posts
Re: Show HN: Create Web Calculators and APIs with Excel Spreadsheets
#2Creator of LambdaXL here. Sharing a side project that I have been working on for the past couple of months now. LambdaXL is a no code platform that lets you upload an Excel spreadsheet and it will turn it into a web calculator that you can embed into your website or you can share a link to it directly.
It uses Excel under the hood to ensure full compatibility (formulas, cross sheet references, even charts) , unlike some of the other solutions online that converts your spreadsheet into PHP/JavaScript/Python/etc.
It also saves every request so you can see what your users are doing.
Here is an example of a calculator that gets generated: https://lambdaxl.com/query/embed/b3b05024-eac5-4443-a67d-52a...
Re: Show HN: Create Web Calculators and APIs with Excel Spreadsheets
#3Re: Show HN: Create Web Calculators and APIs with Excel Spreadsheets
#4This is so cool. Is this free to use?
Re: Show HN: Create Web Calculators and APIs with Excel Spreadsheets
#5Re: Show HN: Create Web Calculators and APIs with Excel Spreadsheets
#6It's pretty neat. Thanks for sharing.
Re: Show HN: Create Web Calculators and APIs with Excel Spreadsheets
#7Re: Show HN: Create Web Calculators and APIs with Excel Spreadsheets
#8Re: Show HN: Create Web Calculators and APIs with Excel Spreadsheets
#9A similar product? https://github.com/handsontable/hyperformula
The primary difference between the two products is that they translate your spreadsheet into a JavaScript function that can run clientside whereas we are actually using Excel to do the execution in our backend.
In terms of the pros and cons, I’d expect theirs to be faster, especially for simple calculations, since they don’t have the overhead of Excel connections that we do and can avoid the network connection if you run it clientside, whereas ours is more Excel compatible and comprehensive. For example, LambdaXL can support pivot tables and charts, but they can’t. Looking at their website, they say they support “100+ Excel formulas”. I believe Excel has around 460 formulas, and so some of the edge case / niche formulas are likely not supported.
Re: Show HN: Create Web Calculators and APIs with Excel Spreadsheets
#10my wife is a financial analyst who swears by excel spreadsheets, I think she'll find this very useful