This page is not created by, affiliated with, or supported by Slack Technologies, Inc.
2020-05-15
Channels
- # announcements (2)
- # babashka (137)
- # beginners (96)
- # calva (3)
- # cider (11)
- # clj-kondo (8)
- # cljs-dev (161)
- # cljsrn (21)
- # clojure (78)
- # clojure-europe (47)
- # clojure-france (1)
- # clojure-losangeles (1)
- # clojure-nl (4)
- # clojure-spec (24)
- # clojure-uk (9)
- # clojuredesign-podcast (4)
- # clojurescript (39)
- # conjure (2)
- # core-async (27)
- # cursive (36)
- # datomic (54)
- # emacs (6)
- # figwheel (9)
- # figwheel-main (46)
- # fulcro (25)
- # graalvm (8)
- # helix (30)
- # hoplon (6)
- # hugsql (3)
- # jobs (5)
- # leiningen (7)
- # luminus (12)
- # nrepl (20)
- # off-topic (20)
- # pedestal (16)
- # re-frame (14)
- # reagent (3)
- # reitit (3)
- # remote-jobs (5)
- # rum (25)
- # shadow-cljs (60)
- # spacemacs (10)
- # vim (2)
- # xtdb (36)
another fun day of reading in excel spreadsheets using clojure and doing data science to them
do they arrive in .xlsx format?
or dull old csv?
but being able to output a lot of tabs in one work book (or indeed read from them) is pretty nice actually
using docjure https://github.com/mjul/docjure
I need to write some extra bits sometimes, but I've done enough java over the years to not be bothered by that
I have hideous memories of having to use MS J++ for Excel reading/writing
We do a lot of Word, Excel and PowerPoint using Clojure. We stopped using POI for several reasons. We are now using https://products.aspose.com/ (Java, wrapped in Clojure).
The pricing is solid.
and I'm always a bit twitchy about depending on something proprietary in my tool chain (happy to pay for FLOSS)
And we were unhappy depending on the ever-changing-and-breaking-poi in our toolchain. 😂
that step from $5k to $14k is a tough jump, and the stuff we build we release open source (and is an important decision factor for our clients in local and central gov't in the UK)
Sure, it's not a one-size-fits-all. Many requirements – technical and non-technical ones like Open Source – are to be considered when choosing a library.
> not trying to say that your team made a bad decision at all No prob, I didn't get it that way.
tho I do completely get the desire to avoid crufty, dependency heavy apache libs. I too have been bitten before
@ramart are you familiar with https://github.com/dhatim/fastexcel ?
The name sounds familiar, but I'm not sure. I ask the team if they stumble over it when looking for solutions...
how far do they do in support Excel's funkier features?
are they vulnerable to macro-based malware?
interesting, I actually have never thought about scripts in excel when parsing the files with non-excel. Do libraries actually execute any formulas?
I do wonder some times if it is possible for small interesting things to survive under capitalism