clj-excel.core — clj-excel 0.0.1

*row-missing-policy* clj

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-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. Simpel 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})

Create style for workbook

create-link clj

(create-link cell kw link-to)

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

font clj

(font wb fontspec)

Register font with

get-cell clj

(get-cell row col)

(get-cell sheet row col)

Sell cell within row

lazy-sheet clj

(lazy-sheet sheet)

(lazy-sheet sheet cell-fn)

Lazy seq of seq representing rows and 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.

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-xssf clj

(workbook-xssf)

(workbook-xssf input)

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