escape-cell
utility function to escape text clashing with Excel's _x..._
Unicode notation.nil
. We consider
this a bug-fix, so there is no major version update for this. However,
note that this is potentially a breaking change if you use row-seq
or cell-seq
or
related functions, and you relay on blank missing rows/cells in your
spreadsheets to be ignored.select-cell
function to easily read a single cell value.read-cell
now works on error cells and non-numeric formula cells without throwing an exception. (All cell types now handled safely).Error cells return keyword of the error type:
:VALUE :DIV0 :CIRCULAR_REF :REF :NUM :NULL :FUNCTION_NOT_IMPLEMENTED :NAME :NA
load-workbook-from-stream
,
load-workbook-from-resource
and load-workbook-from-file
.load-workbook
a multi-method accepting a string (filename) or a
stream.select-sheet
can now select sheets by regex and predicate functions in addition to exact sheet name (contributed by jonneale).
upgraded Clojure version to 1.5.1
added font and cell styling options (contributed by naipmoro):
added option work on the legacy Excel 'XLS' file format (create-xls-workbook
)
added font styling options to create-font!
:
:name (font family - string) :size (font size - integer) :color (font color - keyword) :bold (true | false) :italic (true | false) :underline (true | false)
added styling options to create-cell-style!
:
:background (background colour - keyword) :font (font | fontmap of font options) :halign (:left | :right | :center) :valign (:top | :bottom | :center) :wrap (true | false - controls text wrapping) :border-left (:thin | :medium | :thick) :border-right (:thin | :medium | :thick) :border-top (:thin | :medium | :thick) :border-bottom (:thin | :medium | :thick)
First public release.
Earlier versions used internally for projects in Ative in 2009 and 2010.
Can you improve this documentation? These fine people already did:
Martin Jul, Oliver Holworthy, Alexander Scott & Korny SietsmaEdit on GitHub
cljdoc is a website building & hosting documentation for Clojure/Script libraries
× close