dk.ative.docjure.spreadsheet — com.vijaykiran/docjure 1.7.0

add-name! clj

(add-name! workbook n string-ref)

add-row! clj

(add-row! sheet values)

add-rows! clj

(add-rows! sheet rows)

Add rows to the sheet. The rows is a sequence of row-data, where each row-data is a sequence of values for the columns in increasing order on that row.

add-sheet! clj

(add-sheet! workbook name)

Add a new sheet to the workbook.

apply-date-format! clj

(apply-date-format! cell format)

assert-type clj macro

(assert-type value expected-type)

cell-reference clj

(cell-reference cell)

cell-seq clj multimethod

Return a seq of the cells in the input which can be a sheet, a row, or a collection of one of these. The seq is ordered ordered by sheet, row and column.

create-cell-style! clj

(create-cell-style! workbook)

(create-cell-style! workbook styles)

Create a new cell-style. Options is a map with the cell style configuration:

:background the name of the background colour (as keyword)

Valid keywords are the colour names defined in org.apache.ss.usermodel.IndexedColors as lowercase keywords, eg.

:black, :white, :red, :blue, :green, :yellow, ...

Example:

(create-cell-style! wb {:background :yellow})

create-font! clj

(create-font! workbook options)

Create a new font in the workbook. Options are :bold true/false bold or normal font

Example: (create-font! wb {:bold true})

create-workbook clj

(create-workbook sheet-name data)

Create a new workbook with a single sheet and the data specified. The data is given a vector of vectors, representing the rows and the cells of the rows.

For example, to create a workbook with a sheet with two rows of each three columns:

(create-workbook "Sheet 1" [["Name" "Quantity" "Price"] ["Foo Widget" 2 42]])

get-row-styles clj

(get-row-styles row)

Returns a seq of the row's CellStyles.

into-seq clj

(into-seq sheet-or-row)

load-workbook clj

(load-workbook filename)

Load an Excel .xls or .xlsx workbook from a file.

read-cell clj multimethod

read-cell-value clj multimethod

remove-all-rows! clj

(remove-all-rows! sheet)

Remove all the rows from the sheet.

remove-row! clj

(remove-row! sheet row)

Remove a row from the sheet.

row-seq clj

(row-seq sheet)

Return a lazy sequence of the rows in a sheet.

row-vec clj

(row-vec column-order row)

Transform the row struct (hash-map) to a row vector according to the column order. Example:

(row-vec [:foo :bar] {:foo "Foo text", :bar "Bar text"}) > ["Foo text" "Bar text"]

save-workbook! clj

(save-workbook! filename workbook)

Save the workbook into a file.

select-columns clj

(select-columns column-map sheet)

Takes two arguments: column hashmap where the keys are the spreadsheet column names as keys and the values represent the names they are mapped to, and a sheet.

For example, to select columns A and C as :first and :third from the sheet (select-columns {:A :first, :C :third} sheet) => [{:first "Value in cell A1", :third "Value in cell C1"} ...]

select-name clj

(select-name workbook n)

Given a workbook and name (string or keyword) of a named range, select-name returns a seq of cells or nil if the name could not be found.

select-sheet clj

(select-sheet name workbook)

Select a sheet from the workbook by name.

set-cell! clj

(set-cell! cell value)

set-cell-style! clj

(set-cell-style! cell style)

Apply a style to a cell. See also: create-cell-style!.

set-row-style! clj

(set-row-style! row style)

Apply a style to all the cells in a row. Returns the row.

set-row-styles! clj

(set-row-styles! row styles)

Apply a seq of styles to the cells in a row.

sheet-name clj

(sheet-name sheet)

Return the name of a sheet.

sheet-seq clj

(sheet-seq workbook)

Return a lazy seq of the sheets in a workbook.

string-cell? clj

(string-cell? cell)