Hacker News new | ask | show | jobs
by nokome 3745 days ago
Thanks for the comments. Actually, I was just working on importing Excel spreadsheets into Stencila sheets last night. Some interesting aspects involved in translating Excel formulas into R expressions e.g. `AVERAGE(A1:A5)` to `mean(A1:A5)`. To do it properly looks like we'll need to build an Excel formula parser. But do-able - and could be fun!
1 comments

Interesting! I imagine there's a more-or-less reasonable subset of Excel formulas you could start with. I look forward to seeing what comes of this!