We've seen how Incanter makes a lot of common data-processing tasks very simple; reading an Excel spreadsheet is another example of this.
First, make sure that our Leiningen project.clj
file contains the right dependencies:
:dependencies [[org.clojure/clojure "1.4.0"] [incanter/incanter-core "1.4.1"] [incanter/incanter-excel "1.4.1"]]
Also, make sure that we've loaded those packages into the REPL interpreter or script:
(use 'incanter.core 'incanter.excel)
And find the Excel spreadsheet we want to work on. I've
named mine data/small-sample-header.xls
. You can download this from http://www.ericrochester.com/clj-data-analysis/data/small-sample-header.xls.