bb-excel.core — com.github.kbosompem/bb-excel 0.0.5

crange clj

(crange s e)

Creates as sequence of columns given a starting and ending column name.

dates clj

defaults clj

Default values for processing the Excel Spreadsheet :row integer :- Which row to begin data extraction defaults to 0 :fxn function :- Which function to use parse header rows :rows integer :- Number of rows to extract :hdr boolean :- Rename columns with data from the first row

error-codes clj

get-cells clj

(get-cells sheet rows cols)

Get range of values returned as list of rows

get-col clj

(get-col sheet col)

Get column from sheet by name. If columns have been renamed use the new name.

get-range clj

(get-range sheet rg)

Get range of values using Excel cell coordinates e.g A1:C5

get-row clj

(get-row sheet row)

Get row from sheet by row index

get-sheet clj

(get-sheet filename sheetname)

(get-sheet filename sheetname options)

Get sheet from file

get-sheet-names clj

(get-sheet-names filename)

Retrieves a list of Sheet Names from a given Excel Spreadsheet Returns nil if the file does not exist or a non-string is passed as the filename

get-sheets clj

(get-sheets filename)

(get-sheets filename options)

Get all or specified sheet from the excel spreadsheet

get-styles clj

(get-styles filename)

Get styles

get-unique-strings clj

(get-unique-strings filename)

Get dictionary of all unique strings in the Excel spreadsheet

num2date clj

(num2date n)

Format Excel Date

num2pct clj

(num2pct n)

Format Percentage

num2time clj

(num2time n)

Format Excel Time

parse-range clj

(parse-range s)

Takes in an Excel coordinate and returns a hashmap of rows and columns to pull

pcts clj

process-cell clj

(process-cell dict styles coll)

Process Excel cell

process-row clj

(process-row dict styles coll)

Process Excel row of data

sdf clj

style-check clj

(style-check coll styles ids)

Check if the style id is within a range.

tags clj

Map of Excel XML namespaces of interest

times clj

to-col clj

(to-col num)

Takes in an ordinal and returns its equivalent column heading.

when-num clj

(when-num s)

Returns nil for empty strings when a number is expected

when-str clj

(when-str s)

Returns nil for empty strings