Hello, I would like to read out xlsx (mainly work with docjure/ org.apache.poi) data and aggregate infos and insert into existing spreadsheet (like hospital daily sheets), into right cells. That is sounds very painful for me now in Clojure, much easier in python, but I would like to use Clojure ecosystem. All times fail at savings, when I would like to mod more than one point (the df) and insert into existing spreadsheet etc. This is quite bad feeling. Anybody implemented with libpython-clj2 eg. openpyxl or pandas to do similar things (interop)?

@sb have you tried fxl? https://github.com/zero-one-group/fxl https://www.youtube.com/watch?v=d6qOzPQ9NUk&ab_channel=SciCloj

Doesn't the tech.ml.dataset stack support reading/writing to/from xlsx now?

If not, fxl is probably a good option.

Yes, https://github.com/techascent/tech.ml.dataset directly supports xlsx format, and it should be the go to thing for any stuff like this.

thanks all help! I check this too

I need to load and write xlsm files, so therefore my case a little bit more specific. I hope I can do with these solutions. Thanks all things again! I check the source codes too

tech.ml.dataset does not write xlsx or xls files at the moment - only read. I have no software that deals with xlsm but I strongly agree with the fxl recommendation for reading/writing cell-like data.