thereisnodot.utils.spreadsheets
Save and load collections to Excel
Save and load collections to Excel
excel-round-downclj
(excel-round-down number digits)Excel compatible ROUND formula
Excel compatible ROUND formula
excel-round-upclj
(excel-round-up number digits)Excel compatible ROUND formula
Excel compatible ROUND formula
excel-slurpclj
(excel-slurp fname-str)Load spreadsheet as a hashmap where the key is a sheet name. and value is
a list of hashmaps with :key being the header of a sheet and :val being
the value on a given row.
Will raise an error if there is no such file
For dumping data to an excel file see excel-spit
See tests for more examples
Load spreadsheet as a hashmap where the key is a sheet name. and value is a list of hashmaps with `:key` being the header of a sheet and `:val` being the value on a given row. Will raise an error if there is no such file For dumping data to an excel file see [excel-spit](#excel-spit) See tests for more examples
excel-spitclj
(excel-spit fpath sheet-maps)(excel-spit fpath sheet-maps if-empty)(excel-spit fpath sheet-maps if-empty header-order)Will turn maps into a spreadsheet of many sheets
will overwrite any file that is on the given fpath
if-empty should be a string value that will replace
empty cell.
Header order will put order on the fields.
Those which specified, will go first in the specified order.
See tests for more examples
Will turn maps into a spreadsheet of many sheets will overwrite any file that is on the given `fpath` `if-empty` should be a string value that will replace empty cell. `Header order` will put order on the fields. Those which specified, will go first in the specified order. See tests for more examples
cljdoc is a website building & hosting documentation for Clojure/Script libraries
× close