DEV Community

Discussion on: Why MS Excel is So Popular

Collapse
 
alanmarazzi profile image
Alan

I'm currently working on something like this and my conclusion is that we most of the times forget another huge Excel plus: everyone is familiar with its interface. This is one of the things we almost never take into account and end up taking away something people already know and shove shiny, but less functional, new interfaces on their faces.

Because of this I started working on perfect a Clojure library for abstracting Excel files: you have a tree of values that after parsing you can store wherever you like (Datomic or a document store for instance) and can then be versioned, transformed and then turned into an Excel file back again.

This would let you apply business logic without forcing new interfaces on coworkers and would make the update/change process much more easier considering that you won't have a frontend to change everytime.

Collapse
 
zoltanhalasz profile image
Zoltan Halasz

Very interesting, I didn't know about this. I am working on .Net projects, is your library compatible with .net? What is Clojure?

Collapse
 
alanmarazzi profile image
Alan

Clojure is a LISP that runs on the JVM and on the CLR. So, yes, by making adjustments in theory it should run on .Net (it is one of the things I was thinking about, but unfortunately at the moment the development is paused).

The cool thing of doing this with Clojure is that by having by default a very nice management of hashmaps (clojure.org/guides/learn/hashed_co...) it makes dealing with hierarchical data a breeze. Oh, and no objects, just functions and data :)

Thread Thread
 
zoltanhalasz profile image
Zoltan Halasz • Edited

Normally my applications upload data from excel to an MS SQL database and store/query/transform data from the tables there => then generate reports. My current endevours is to find easy methods to do this upload/export, and then work with the data in the application. I am studying now .net core razor pages for a web-based approach. Anyway thanks for the info.