Execute Excel-like Formulas outside Excel
The content of data.csv contains Excel-like formulas:
The computing goal is to process this CSV file outside Excel (not using Excel). Execute the above formula according to Excel rules to get the following result:
This requires dynamic parsing of a string formula that contains Excel-like variables. It will be fast and simple to get this done if you can paste the file to Excel. But it becomes rather difficult to try to do this outside Excel.
You can do this in 2 steps:
1. Start esProc (Download esProc installation package and free DSK edition license HERE. You will be prompted to load the license file when you run esProc for the first time).
2. Write a script and execute it.
In this script, eval() function can identify an Excel-like formula and execute the string as a formula.