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

A_CHAR_INDEX clj

BASE_COLUMN_INDEX clj

BASE_ROW_INDEX clj

cell-type clj

(cell-type value)

content-types clj

(content-types n)

crange clj

(crange s e)

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

create-sheet-xml clj

(create-sheet-xml data)

create-xlsx clj

(create-xlsx file-path data)

create-zip-entry clj

(create-zip-entry zip-stream entry-name content)

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

excel-date-serial clj

(excel-date-serial datetime)

excel-time-serial clj

(excel-time-serial datetime)

extract-cell-value clj

(extract-cell-value shared-strings styles cell)

Possible cell-value types well explained here https://stackoverflow.com/a/18346273

generate-xml-cell clj

(generate-xml-cell col-letter row-num value)

generate-xml-row clj

(generate-xml-row row-data row-num)

(generate-xml-row row-data row-num column-mapping)

get-and-check-sheet-id clj

(get-and-check-sheet-id zipfile sheetname-or-idx)

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-col-index clj

(get-col-index cell last-processed-col-index)

Self-calculated index is used only if cell-index attribute(:r) is missing on the cell

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-entry clj

(get-sheet-entry zipfile sheet-id)

get-sheet-names clj

(get-sheet-names file-or-filename)

Retrieves a list of Sheet Names from a given Excel Spreadsheet

get-sheet-names* clj

(get-sheet-names* zipfile)

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)

num2date clj

(num2date n)

Format Excel Date

num2pct clj

(num2pct n)

Format Percentage

num2time clj

(num2time n)

Format Excel Time

number->column-letter clj

(number->column-letter n)

parse-range clj

(parse-range s)

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

parse-xlong clj

(parse-xlong x)

pcts clj

process-row clj

(process-row shared-strings styles row)

Process Excel row of data

process-rows clj

(process-rows shared-strings styles last-processed-row-index rows)

sdf clj

style-check clj

(style-check cell-attrs styles ids)

Check if the style id is within a range.

times clj

to-col clj

(to-col num)

Takes in an ordinal and returns its equivalent column heading.

valid-cell-index? clj

(valid-cell-index? cell-index)

wb-relationships clj

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

ws-relationships clj

(ws-relationships n)

xlns clj

xmlh clj