Clojurians Log v2

I know that there are java interfaces for doing this. But before diving into uncharted territory, it would be nice to talk with someone who has done anything similar so I don't completely go off and do something bizarre.

A long time ago I did it via Python. Nothing to it, really. Create a new document, create a sheet, start writing cells, save the doc, that's it. I imagine it's pretty much the same when done via Java. And there are multiple libraries for it in Clojure, e.g. here's how you could create a whole doc in one go with one of them: https://github.com/mjul/docjure#example-create-a-spreadsheet

I played a bit with chatgpt and got some basic code that works for what I can start with. i’ve written a clojure script which takes an excel file and replaces a named sheet with the content of a named csv file. I am generating the csv file by another clojure script.

the script is a bit brittle but should work for the moment until I can better figure out what I really need.

Apache POI is a Java library that can do such things. With a bit of cleverness you can even get "headings" bolded and such. It is mostly a matter of "Create a new document, create a sheet, start writing cells (or maybe it's rows), save the doc, that's it"

I have already used docjure in a personal project. I am mostly consuming spreadsheets but also produced a few. The library is functional, but it does have a learning curve and it's not super well documented. I had to read the source code for some functions. It does have support for formulas, so I would give it a go.

I generate Excel files a lot at work. I use a thin Clojure wrapper on top of the great https://github.com/dhatim/fastexcel/ library

This lib is quite fast and works with GraalVM. I have two functions, briefly: to write a seq of rows into a file, and read it back into a vector of vectors. I even have some end-to-end tests for that.

Here's the design doc: https://github.com/dco-dev/ordered-collections/blob/master/doc/concept/concept.md