docjure
docjure copied to clipboard
Read one xls, append to another - IllegalArgumentException No matching method found: setCellValue
Hi,
I'm not sure if this is a bug in my code, or not:
user=> (use 'dk.ative.docjure.spreadsheet) nil user=> (def destinationDoc "/Users/nathan/Desktop/Compiled.xls")
'user/destinationDoc
user=> (def dwb (load-workbook destinationDoc))
'user/dwb
user=> (def swb (load-workbook "/Users/nathan/Desktop/test.xls"))
'user/swb
user=> (def newdata (rest (row-seq (select-sheet "Data" swb))))
'user/newdata
user=> (add-rows! (select-sheet "Data" dwb) newdata) IllegalArgumentException No matching method found: setCellValue for class org.apache.poi.hssf.usermodel.HSSFCell clojure.lang.Reflector.invokeMatchingMethod (Reflector.java:79)
The source spreadsheet has two lines of text, the destination only has a header row. Where should I look? Or is there a more appropriate place to ask this question?
Using org.clojure/clojure "1.3.0" and dk.ative/docjure "1.5.0"
Thanks, Nathan