BackgroundColor and Font in empty cells

[es...@asp-as.no]

Hi

I am making a program that reads en excel-workbook, fills in some data in 
it and write it to another file.

The problem is that the cells contain a background color and a defined 
font. This applies for the whole sheet, but the cellvalue is NULL. 
Therefore I can't get the defined cellStyle and color.

Is there a way that I can get these values even though the cell is NULL?

/espen

Re: BackgroundColor and Font in empty cells

[R S <tc...@gmail.com>]

You could programatically check for null and insert a "" instead.

On 4/20/05, espen.simensen@asp-as.no <es...@asp-as.no> wrote:
> Hi
> 
> I am making a program that reads en excel-workbook, fills in some data in
> it and write it to another file.
> 
> The problem is that the cells contain a background color and a defined
> font. This applies for the whole sheet, but the cellvalue is NULL.
> Therefore I can't get the defined cellStyle and color.
> 
> Is there a way that I can get these values even though the cell is NULL?
> 
> /espen
>

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/