Liking cljdoc? Tell your friends :D

ontodev.excel


cell-valueclj

(cell-value cell)
(cell-value cell cell-type)

Return cell-value based on proper getter based on cell-value

Return cell-value based on proper getter based on cell-value
sourceraw docstring

cell-value-fnclj

(cell-value-fn opt workbook)

Return function to determine Excel cell values based on given options. opt - cmdline options. workbook - the Excel workbook object, used to create the function. if --values values is given, use the underlying values. if --values formatted is given, use the cells as formatted (visbly) in the excel sheet. The returned function should accept 1 or 2 arguments: the first is the cell, the optional second is the cell-type.

Return function to determine Excel cell values based on given options.
opt - cmdline options.
workbook - the Excel workbook object, used to create the function.
if `--values values` is given, use the underlying values.
if `--values formatted` is given, use the cells as formatted (visbly) in the excel sheet.
The returned function should accept 1 or 2 arguments: the first is the cell, the optional
second is the cell-type.
sourceraw docstring

cell-value-formattedclj

(cell-value-formatted evaluator data-formatter cell)
(cell-value-formatted evaluator data-formatter cell cell-type)

Return cell-value based on proper getter based on cell-value. Some Excel functions are not implemented (eg GETPIVOTDATA), fallback to cell-value

Return cell-value based on proper getter based on cell-value.
 Some Excel functions are not implemented (eg GETPIVOTDATA),
fallback to cell-value
sourceraw docstring

cell-value-numericclj

(cell-value-numeric cell)

Return numeric cell-value, could be a date/time

Return numeric cell-value, could be a date/time
sourceraw docstring

combine-headersclj

(combine-headers & strings)
source

combine-row-headersclj

(combine-row-headers rows-header)
source

get-cell-string-valueclj

(get-cell-string-value cell)
(get-cell-string-value cell _cell-type)

Get the value of a cell as a string, by changing the cell type to 'string' and then changing it back. optional cell-type is not used here.

Get the value of a cell as a string, by changing the cell type to 'string'
and then changing it back.
optional cell-type is not used here.
sourceraw docstring

int-value?clj

(int-value? v)

Return true iff the actual value is an integer. Datatype could be a float/double

Return true iff the actual value is an integer.
Datatype could be a float/double
sourceraw docstring

list-sheetsclj

(list-sheets workbook)

Return a list of all sheet names.

Return a list of all sheet names.
sourceraw docstring

load-workbookclj

(load-workbook path)

Load a workbook from a string path.

Load a workbook from a string path.
sourceraw docstring

ordered-zipmapclj

(ordered-zipmap keys vals)

Returns an ordered-map with the keys mapped to the corresponding vals. zipmap, but put keys in original order

Returns an ordered-map with the keys mapped to the corresponding vals.
zipmap, but put keys in original order
sourceraw docstring

read-rowclj

(read-row row)
(read-row cell-value-fn row)

Read all the cells in a row (including blanks) and return a list of values.

Read all the cells in a row (including blanks) and return a list of values.
sourceraw docstring

read-sheetclj

(read-sheet workbook)
(read-sheet opt workbook)
(read-sheet opt workbook sheet-name)
(read-sheet opt workbook sheet-name n-header-rows)
(read-sheet opt workbook sheet-name n-header-rows n-drop-rows)

Given a workbook with an optional sheet name (default is 'Sheet1') and and optional header row number (default is '1'), return the data in the sheet as a vector of maps using the headers from the header row as the keys. Use :values key in opt (map) to determine how to determine the values: :strings - the default, all values are returned as strings :values - the actual values with correct datatype, including dates/times based on cell-formatting :formatted - the formatted values If n-header-rows > 1, use all of the headers to determine field-name

Given a workbook with an optional sheet name (default is 'Sheet1') and
and optional header row number (default is '1'),
return the data in the sheet as a vector of maps
using the headers from the header row as the keys.
Use :values key in opt (map) to determine how to determine the values:
  :strings   - the default, all values are returned as strings
  :values    - the actual values with correct datatype, including dates/times based on cell-formatting
  :formatted - the formatted values
If n-header-rows > 1, use all of the headers to determine field-name
sourceraw docstring

sheet-headersclj

(sheet-headers workbook sheet-name)

Returns the headers (in their original forms, not as keywords) for a given sheet.

Returns the headers (in their original forms, not as keywords) for a given sheet.
sourceraw docstring

to-keywordclj

(to-keyword s)

Take a string and return a properly formatted keyword. Replace all characters outside of letter, digits and underscore

Take a string and return a properly formatted keyword.
Replace all characters outside of letter, digits and underscore
sourceraw docstring

versionclj

(version)

Return version details, for now manually

Return version details, for now manually
sourceraw docstring

cljdoc builds & hosts documentation for Clojure/Script libraries

Keyboard shortcuts
Ctrl+kJump to recent docs
←Move to previous article
→Move to next article
Ctrl+/Jump to the search field
× close