clj-xlsxio.read — clj-xlsxio 0.6.8

coerce clj

(coerce lz-seq fs & {:keys [skip-first-row] :or {skip-first-row false}})

Coerce every row applying a vector of functions

coerce-map clj

(coerce-map m fs)

Coerce one map based on a coercion map, extra keys are untouched. Extra keys in fs will be ignored.

coerce-maps clj

(coerce-maps lz-seq fs & {:keys [skip-first-row] :or {skip-first-row false}})

coerce a list of maps based on a coercion map, extra keys will be untouched.

excel-date->java-date clj

(excel-date->java-date n-str)

Takes a excel date and convert it to a java Date object

excel-date->java-localdatetime clj

(excel-date->java-localdatetime n-str)

Takes a excel date and convert it to a java.time.LocalDateTime object

excel-date->joda-date clj

(excel-date->joda-date n-str)

Takes a excel date and convert it to a joda time DateTime object

excel-date->unix-timestamp clj

(excel-date->unix-timestamp n-str)

Takes a excel date and convert it to a unix timestamp

ListSheets clj protocol

list-sheets clj

(list-sheets this)

read-row clj

(read-row sheet)

(read-row sheet xlsx)

read-xlsx clj multimethod

skip-all-empty clj

skip-empty-cells clj

skip-empty-rows clj

skip-extra-cells clj

skip-none clj

xlsx->column-title-maps clj

(xlsx->column-title-maps lz-seq
                         &
                         {:keys [str-keys column-fn]
                          :or {str-keys false column-fn nil}})

Takes the first row of a xlsx and enumerate every row with the column title. Use the keyword arg :column-fn to pass a functions that are applied on each of the column names, must be a function of 1 arg.

xlsx->enumerated-maps clj

(xlsx->enumerated-maps lz-seq)

Returns a lazy sequence of maps, keys are the number of the column in the excel format

xlsx->excel-enumerated-maps clj

(xlsx->excel-enumerated-maps lz-seq)

Returns a lazy sequence of maps, keys are the number of the column in the excel format