docjure icon indicating copy to clipboard operation
docjure copied to clipboard

Read one xls, append to another - IllegalArgumentException No matching method found: setCellValue

Open nreilly opened this issue 13 years ago • 0 comments

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

nreilly avatar Feb 06 '12 10:02 nreilly