Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Excel Formula to Pseudocode

Is there any tool out there which will format excel formulas in such a way that they are more easily decipherable?

I need to convert some complex excel spreadsheets people have made to C# applications and sitting there looking at one line excel formulas is relatively troublesome. Primarily I'm looking for something that can rewrite them to pseudocode or a more readable programming language.

The closest thing I could find was http://ewbi.blogs.com/develops/2004/12/excel_formula_p.html but this still does not help all that much.

like image 799
Jas Laferriere Avatar asked Aug 23 '12 20:08

Jas Laferriere


1 Answers

Sean Cheshire's comment is probably the best answer you're going to get:

Excel Formula Beautifier

It has a feature that allows you to convert to javascript.

The one thing it seems to be missing is a feature to do a batch of formulas at once (which would save a lot of time if converting a whole sheet with "Show Formulas" turned on). I added a request for this.

Given how the app works now, if you try pasting a batch into the single-line input field, you may still get a result that's at least somewhat useful. I recommend giving it a try.

like image 143
devuxer Avatar answered Oct 07 '22 19:10

devuxer