News for hackers. Stuff that matters.
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.