check-spreadsheet.clj

(require '[excel-repl.interop :as interop])
(require '[clojure.string :as str])

(defn parse [s]
  (if (string? s) (-> s (str/replace " " "") Double/Parse)))

(def our-data (map first (interop/get-values "Sheet2" "S1:S1000")))

(def our-members (filter number? our-data))

(def addresses
  (into {}
    (for [[memb-num name surname] (interop/get-values "Sheet1" "A2:C60287")]
      [(parse memb-num) (str name " " surname)])))

(addresses (last our-members))