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

A_CHAR_INDEX clj

BASE_COLUMN_INDEX clj

BASE_ROW_INDEX clj

crange clj

(crange s e)

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

create-xlsx clj

(create-xlsx file-path data)

Create an Excel spreadsheet file-path : Destination folder and filename. e.g /test/sample.xlsx will create the folder test if it does not exist and place the newly created sample.xlsx in that folder data : Data should be vector of maps or vector of vectors where each map or vector represents a row

create-zip-entry clj

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

For a given filepath and content add to a java ZipOuputStream

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)

Convert a java LocalDate to an MS Excel integer value

excel-time-serial clj

(excel-time-serial datetime)

Convert a java LocalDateTime to an MS Excel decimal value.

extract-cell-value clj

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

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

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)

Adds support for passing in nil into parse-long Return an empty string if x is nil

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