Re: Incompatible types error from getIndexHash()

Thanks Barbara, Federico and Gary.

The answer apparently was that I had a POI 2.0 jar file in my home directory. I should mention I'm using Java 1.5 and POI 3.7. When I got rid of that, I started getting an error about not throwing and catching file i/o exceptions. So I added a try - catch block around the file i/o, and learned that apparently anything defined inside the try block is not accessible outside the try block, specifically the wb object.

I tried defining wb before the try block, but then the compiler complained that the wb inside the try block was already defined. Which means to me that Java's scoping doesn't work like RPG's.

Anyway, I expanded the try block to include everything, and it compiled.

I'll start a new thread on the ensuing problems.

On 7/18/2011 3:45 PM, Barbara Morris wrote:

On 7/18/2011 3:15 PM, Peter Dow wrote:

...
I get the following error when compiling a java program I'm trying to
use to figure out how to get the color of text in a cell.

testjava.java:33: incompatible types
found : java.lang.Object
required: org.apache.poi.hssf.util.HSSFColor
HSSFColor color = HSSFColor.getIndexHash().get(colorIndex);
^
1 error
...
int colorIndex = font.getColor();
HSSFColor color = HSSFColor.getIndexHash().get(colorIndex);

Peter, just a guess, but it looks like getIndexHash is defined to have
an java.lang.Integer as the key, not an integer. You could try defining
colorIndex like this:

Integer colorIndex = new Integer(font.getColor());

http://poi.apache.org/apidocs/org/apache/poi/hssf/util/HSSFColor.html#getIndexHash%28%29