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

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 cell-value based on proper getter based on cell-value. Some Excel functions are not implemented (eg GETPIVOTDATA), fallback to cell-value

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

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.

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

Return a list of all sheet names.

Load a workbook from a string path.

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

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

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

Take a string and return a properly formatted keyword.