Show HN: Instantly Understand Any Spreadsheet

Re:Show HN: Instantly Understand Any Spreadsheet by excel2flow on Tuesday August 05, 2014 @04:25AM (#8136013)

I had some trouble reading nested IF functions, so I wrote a piece of code which translates them into flowcharts: http://excel2flow.asp2.cz/ (weekend project)

[ Parent | on HN ]

Re:Show HN: Instantly Understand Any Spreadsheet by Fragment on Tuesday August 05, 2014 @10:54AM (#8137188)

Far more useful than the OP, IMO. Awesome!

It briefly bugged out (dumping everything as a string into a single result block) on entering a ":" or ";" after the word "Error" in a string as part of the long formula I tested it with, but since then I've changed a few minor things and it's stopped happening :S

[ Parent | on HN ]

Re:Show HN: Instantly Understand Any Spreadsheet by excel2flow on Tuesday August 05, 2014 @11:12AM (#8137303)

Thanks for testing! ";" is delimiter for function arguments in czech version of Excel (because "," is decimal delimiter). Parser tries to guess if you're using czech or english version and it probably guessed wrong.

Anyway, I wrote the parser by hand so I cannot guarantee it will work on every valid Excel formula. But I'm working on improved version which will use formal grammar.

[ Parent | on HN ]

Re:Show HN: Instantly Understand Any Spreadsheet by robzyb on Tuesday August 05, 2014 @09:23AM (#8136728)

That is super cool! Bookmarked!

[ Parent | on HN ]

Re:Show HN: Instantly Understand Any Spreadsheet by ttty on Tuesday August 05, 2014 @06:56AM (#8136288)

Nice one (:

[ Parent | on HN ]