gsheetplus.cell — io.github.mlimotte/gsheetplus 0.9.2

Cell data protocol and conversions between Clojure values and Google Sheets API types. Extend CellDataValue for custom write-time type coercions.

cell->clj clj

(cell->clj cell-data)

Convert a raw Google Sheets API cell map to a Clojure value. Handles effectiveValue / userEnteredValue; prefers effectiveValue. Types: boolValue → Boolean, stringValue → String, DATE number → LocalDate, CURRENCY number → BigDecimal, number → Double, empty → nil.

CellDataValue clj protocol

Coerce a Clojure value to a CellData instance for writing to Google Sheets.

->cell-data clj

(->cell-data v)

date-cell clj

(date-cell pattern local-date)

CellData containing local-date formatted with the given Excel date pattern, e.g. "yyyy-mm-dd" or "M/d/yyyy".

date-serial-number clj

(date-serial-number local-date)

Google Sheets date serial number for a java.time.LocalDate. Days since 1899-12-30, returned as Double.

row->row-data clj

(row->row-data row)

Convert a vector of values (anything satisfying CellDataValue) to a RowData instance for use in UpdateCellsRequest.