Return-Path: Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org Received: (qmail 11150 invoked from network); 5 May 2005 18:42:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 5 May 2005 18:42:31 -0000 Received: (qmail 41314 invoked by uid 500); 5 May 2005 18:44:50 -0000 Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org Received: (qmail 41288 invoked by uid 500); 5 May 2005 18:44:50 -0000 Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "POI Users List" Reply-To: "POI Users List" Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 41260 invoked by uid 99); 5 May 2005 18:44:49 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=RCVD_BY_IP X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of tcat.seq@gmail.com designates 64.233.184.203 as permitted sender) Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (64.233.184.203) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 05 May 2005 11:44:49 -0700 Received: by wproxy.gmail.com with SMTP id 58so781661wri for ; Thu, 05 May 2005 11:42:21 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Gagf6mOqH33GlKdTXy1CYGzKrnQcdBI33ClNjuVIxlPcWd85qL3WvkZxI6nGQSDY+55gmm25B7mz39JO9mjeqpFcKGUJKJdEavJfQWgFUOwnspDd+22Qs1ffa9dU4tk5dHhmXfb3hkmVXEuTrm7FdkeW1teNGJ0NdkaVO943O1s= Received: by 10.54.34.28 with SMTP id h28mr331816wrh; Thu, 05 May 2005 11:42:21 -0700 (PDT) Received: by 10.54.14.6 with HTTP; Thu, 5 May 2005 11:42:21 -0700 (PDT) Message-ID: Date: Thu, 5 May 2005 13:42:21 -0500 From: R S Reply-To: R S To: POI Users List Subject: Re: BackgroundColor and Font in empty cells In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N You could programatically check for null and insert a "" instead. On 4/20/05, espen.simensen@asp-as.no wrote: > Hi >=20 > I am making a program that reads en excel-workbook, fills in some data in > it and write it to another file. >=20 > 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. >=20 > Is there a way that I can get these values even though the cell is NULL? >=20 > /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/