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

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

(get-shared-strings zipfile)

Get dictionary of all unique strings in the Excel spreadsheet

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

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 shared-strings styles cell)

Process Excel cell

process-row clj

(process-row shared-strings styles row)

Process Excel row of data

sdf clj

SHEET_DATA_TAGS clj

SHEET_TAG_TAGS 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

TEXT_PART_TAGS clj

TEXT_T_TAGS clj

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