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

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 file-or-filename)

(get-sheet file-or-filename sheetname-or-idx)

(get-sheet file-or-filename sheetname-or-idx options)

Get sheet from file or filename

get-sheet-names clj

(get-sheet-names file-or-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 file-or-filename

get-sheets clj

(get-sheets file-or-filename)

(get-sheets file-or-filename options)

Get all or specified sheet from the excel spreadsheet

get-styles clj

(get-styles zipfile)

Get styles

get-unique-strings clj

(get-unique-strings zipfile)

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