Write xlsx/ xlsm (template) files from clojure without style or macro loss

libpython-clj-write-xlsm.clj

(ns playground
  (:require [libpython-clj2.python :as py]
            [libpython-clj2.require :refer [require-python]]))

(require '[libpython-clj2.python
           :refer [as-python as-jvm
                   ->python ->jvm
                   get-attr call-attr call-attr-kw
                   get-item
                    initialize!
                   run-simple-string
                   add-module module-dict
                   import-module
                   python-type]])

(initialize!)

; pip install editpyxl
(require-python '[editpyxl :refer [Workbook]])

(defn write-cell-newfile [file nloc cell cell-val]
  "new file created from old 
  without style/ vba macro loss"  
  (let [wb (Workbook)]
    (call-attr wb "open" file)
    (let [ws (get-item wb "your-sheet-name")]
      (py/set-item! ws cell cell-val)
      (call-attr wb "save" nloc)
      (call-attr wb "close"))))

(write-cell-newfile
  "orginal-template.xlsm"
  "new-file.xlsm" 
  "V8" 777)