Hello,

I am using the Apache POI library to read Excel files. The following is from within Slime.

I am struggling to extract cell types as returned by getCellTypeEnum ( https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Cell.html#getCell... ())

My code returns a Java Object like so: #<org.apache.poi.ss.usermodel.CellType FORMULA {5C25A9}>

It is of class #<java class org.apache.poi.ss.usermodel.CellType>

I would like to grab the "FORMULA" in the above object description.

Slime can see it, it's inspector can see it, even DESCRIBE can see it:

READER> (describe *) #<org.apache.poi.ss.usermodel.CellType FORMULA {11CC24A}> is an object of type JAVA-OBJECT.

The wrapped Java object is an instance of org.apache.poi.ss.usermodel.CellType:

"FORMULA"

But, I could not figure out a way to get to "FORMULA". I tried to accessing the slot `name' but that does not work. I looked at the FFI page, but found no clues. I tried to get slot names via AMOP:

(mop:class-direct-slots (class-of java-cell-type))

returns NIL

It must be something simple that I am overlooking.

Help is appreciated. Thanks!

Mirko