clj-excel.core — grafter/clj-excel 0.1.0

build-sheet clj

(build-sheet wb sheetname rows)

Build sheet from seq of seq (representing cells in row of rows).

build-workbook clj

(build-workbook wb-map)

(build-workbook wb wb-map)

Build workbook from map of sheet names to multi dimensional seqs (ie a seq of seq).

caching-style-builder clj

(caching-style-builder wb)

cell-comment clj

(cell-comment cell)

cell-mutator clj multimethod

cell-style-constant clj

(cell-style-constant kw)

(cell-style-constant kw prefix)

cell-value clj

(cell-value cell)

(cell-value cell cell-type)

Return proper getter based on cell-value

cells clj

(cells row)

Return seq of cells from row. Simple seq cast via Iterable implementation.

color-indices clj

constantize clj

(constantize klass kw)

Helper to read constants from constant like keywords within a class. Reflection powered.

create-cell-style clj

(create-cell-style wb
                   &
                   {format :format
                    alignment :alignment
                    border :border
                    fontspec :font
                    bg-color :background-color
                    fg-color :foreground-color
                    pattern :pattern
                    wrap :wrap})

Create style for workbook

create-comment clj

(create-comment cell {:keys [width height text] :or {width 2 height 2}})

create-link clj

(create-link cell kw link-to)

create-rich-text-string clj

(create-rich-text-string cell text)

create-sheet-data-style clj

(create-sheet-data-style cache data)

data-format clj

(data-format wb sformat)

Get dataformat by number or create new.

data-formats clj

field-name clj

(field-name kw)

font clj

(font wb fontspec)

Register font with

get-cell clj

(get-cell row col)

(get-cell sheet row col)

Sell cell within row

get-creation-helper clj

(get-creation-helper cell)

lazy-sheet clj

(lazy-sheet sheet & opts)

Lazy seq of seqs representing rows and cells of sheet.

Options: :cell-fn function called on each cell, defaults to cell-value :mode either :logical (default) or :physical

Modes: :logical returns all cells even if they are blank :physical returns only the physically defined cells

lazy-workbook clj

(lazy-workbook wb)

(lazy-workbook wb sheet-fn)

Lazy workbook report.

merge-rows clj

(merge-rows sheet start rows)

Add rows at end of sheet.

row-seq clj

(row-seq row & opts)

Returns a lazy seq of cells of row.

Options: :cell-fn function called on each cell, defaults to cell-value :mode either :logical (default) or :physical

Modes: :logical returns all cells even if they are blank :physical returns only the physically defined cells

rows clj

(rows sheet)

Return rows from sheet as seq. Simple seq cast via Iterable implementation.

save clj

(save wb path)

Write workbook to output-stream as coerced by OutputStream.

set-border clj

(set-border cs all)

(set-border cs caps sides)

(set-border cs top right bottom left)

Set borders, css order style. Borders set CSS order.

set-cell clj

(set-cell cell value)

(set-cell row col value)

(set-cell sheet row col value)

Set cell at specified location with value.

sheet-names clj

(sheet-names wb)

sheets clj

(sheets wb)

Get seq of sheets.

StyleCache clj protocol

build-style clj

(build-style this cell-data)

underline-indices clj

values clj

(values row)

Return cells from sheet as seq.

workbook-hssf clj

(workbook-hssf)

(workbook-hssf input)

Create or open new excel workbook. Defaults to xls format.

workbook-sxssf clj

(workbook-sxssf)

(workbook-sxssf input)

Create or open new streaming excel workbook. Defaults to xlsx format.

workbook-xssf clj

(workbook-xssf)

(workbook-xssf input)

Create or open new excel workbook. Defaults to xlsx format.