Excel Formula for Pseudocode

Question

Is there any tool that will format excel formulas so that they are easier to decrypt?

I need to convert some complex Excel spreadsheets that people made in C # applications, and sitting there looking at one line, distinguishes formulas, is quite troublesome. First of all, I'm looking for something that can rewrite them into pseudo-code or a more readable programming language.

The closest I could find is http://ewbi.blogs.com/develops/2004/12/excel_formula_p.html , but that still doesn't help.

Answer 1

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

Excel Formula Beautifier

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

The only thing that is apparently missing is the ability to make a batch of formulas at once (which will save a lot of time if the whole sheet is converted using the "Show Formulas"). I have added a request for this .

Given how the application works now, if you are trying to insert a package into a single-line input field, you can still get a result that is at least somewhat useful. I recommend a try.