News for hackers. Stuff that matters.
Re:Show HN: Create Web Calculators and APIs with Excel Sprea... by huan23 on Saturday July 25, 2020 @11:25AM (#23949865)
Hey HN!

Creator 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 Sprea... by pmdulaney on Saturday July 25, 2020 @10:59PM (#23954064)
Re:Show HN: Create Web Calculators and APIs with Excel Sprea... by huan23 on Sunday July 26, 2020 @06:43AM (#23956050)
Hey, thanks for the question.

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 Sprea... by litopiggy on Monday July 27, 2020 @01:54PM (#23967610)
This is neat! Will definitely try it out.
Re:Show HN: Create Web Calculators and APIs with Excel Sprea... by LoriR on Saturday July 25, 2020 @12:02PM (#23950175)
It's pretty neat. Thanks for sharing.
Re:Show HN: Create Web Calculators and APIs with Excel Sprea... by huan23 on Saturday July 25, 2020 @12:09PM (#23950250)
Thank you!
Re:Show HN: Create Web Calculators and APIs with Excel Sprea... by raylui34 on Saturday July 25, 2020 @09:06PM (#23953623)
my wife is a financial analyst who swears by excel spreadsheets, I think she'll find this very useful
Re:Show HN: Create Web Calculators and APIs with Excel Sprea... by huan23 on Sunday July 26, 2020 @06:46AM (#23956060)
I would love to get her setup and get some feedback! We have a free plan that you can use, and if that isn’t enough, message me at contact (at) LambdaXL (dot) com and I can give you a coupon code to get a free trial for the higher plans.
Re:Show HN: Create Web Calculators and APIs with Excel Sprea... by crystal88 on Saturday July 25, 2020 @11:48AM (#23950045)
This is so cool. Is this free to use?
Re:Show HN: Create Web Calculators and APIs with Excel Sprea... by huan23 on Saturday July 25, 2020 @11:49AM (#23950056)
Hey, thanks for checking us out. Yeah we have a free forever plan to get started.