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

crange clj

(crange s e)

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

defaults clj

Default values for processing the Excel Spreadsheet :row integer :- Which row to begin data extraction defaults to 1 :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

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-unique-strings clj

(get-unique-strings filename)

Get dictionary of all unique strings in the Excel spreadsheet

num2date clj

(num2date n)

Convert number to Excel compatible Date

parse-range clj

(parse-range s)

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

process-cell clj

(process-cell dict coll)

Process Excel cell

process-row clj

(process-row dict coll)

Process Excel row of data

s2d clj

(s2d n)

Convert string to double

tags clj

Map of Excel XML namespaces of interest

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