(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
(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.
(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
(cell-value-numeric cell)Return numeric cell-value, could be a date/time
Return numeric cell-value, could be a date/time
(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.
(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
(list-sheets workbook)Return a list of all sheet names.
Return a list of all sheet names.
(load-workbook path)Load a workbook from a string path.
Load a workbook from a string path.
(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
(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.
(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
(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.
(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
(version)Return version details, for now manually
Return version details, for now manually
cljdoc builds & hosts documentation for Clojure/Script libraries
| Ctrl+k | Jump to recent docs |
| ← | Move to previous article |
| → | Move to next article |
| Ctrl+/ | Jump to the search field |