Execute Excel-like Formulas outside Excel

The content of data.csv contains Excel-like formulas:

1;;2.74;0=A1+C1;=A2;=C1

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:

1;;2.74;03.74;3.74;2.74

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.

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

The Art of Clean Code — Refactoring

Cover image of this article (Kamisato Ayato)

Taking a Systems Approach to Global Supply Chains

Take the Helm with Kubernetes on Windows

Which Engagement Model Should You Choose When Considering a Software Vendor?

Christmas cards and serving hatches

Git Cheat Sheet for Beginners

Files and Directory System in laravel and type of File Exist in it

Files and Directory System in laravel and type of File Exist in it

Here’s why you shouldn’t copy the Amazon, Google Coding Interview Process for Hiring Engineers

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
chuxin huo

chuxin huo

hello:)

More from Medium

Protect your Hotel Room key card while !

Complex Carbs

how to get free Bitcoin on the Satoshi BTCs mining App! And Win $888!

On Busyness