Return-Path: Delivered-To: apmail-poi-dev-archive@www.apache.org Received: (qmail 71222 invoked from network); 15 Sep 2008 19:55:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 15 Sep 2008 19:55:14 -0000 Received: (qmail 70954 invoked by uid 500); 15 Sep 2008 19:55:11 -0000 Delivered-To: apmail-poi-dev-archive@poi.apache.org Received: (qmail 70932 invoked by uid 500); 15 Sep 2008 19:55:11 -0000 Mailing-List: contact dev-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Developers List" Delivered-To: mailing list dev@poi.apache.org Received: (qmail 70921 invoked by uid 99); 15 Sep 2008 19:55:11 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 15 Sep 2008 12:55:11 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kenwardj@dteenergy.com designates 63.77.247.167 as permitted sender) Received: from [63.77.247.167] (HELO mail7.dteenergy.com) (63.77.247.167) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 15 Sep 2008 19:54:10 +0000 X-AuditID: c0a807cc-abf9abb000000d3f-12-48cebd829778 Received: from lnx419.dteco.com (lnx419.dteco.com [162.9.87.247]) by mail7.dteenergy.com (Symantec Mail Security) with ESMTP id C98B6420 for ; Mon, 15 Sep 2008 15:54:42 -0400 (EDT) Received: from dtelm18.dteco.com ([162.9.137.82]) by lnx419.dteco.com (Lotus Domino Release 7.0.3) with ESMTP id 2008091515544121-4076450 ; Mon, 15 Sep 2008 15:54:41 -0400 To: dev@poi.apache.org Subject: Blank and null cells MIME-Version: 1.0 X-Mailer: Lotus Notes Release 7.0.2 September 26, 2006 Message-ID: From: Jeffrey A Kenward Date: Mon, 15 Sep 2008 15:53:01 -0400 X-MIMETrack: Serialize by Router on DTELM18/Svr/dteenergy(Release 7.0.3HF479 | March 17, 2008) at 09/15/2008 15:54:42, Serialize complete at 09/15/2008 15:54:42, Itemize by SMTP Server on DTELS03/Svr/dteenergy(Release 7.0.3|September 26, 2007) at 09/15/2008 15:54:41, Serialize by Router on DTELS03/Svr/dteenergy(Release 7.0.3|September 26, 2007) at 09/15/2008 15:54:41, Serialize complete at 09/15/2008 15:54:41 X-TNEFEvaluated: 1 Content-Type: multipart/alternative; boundary="=_alternative 006D393A852574C5_=" X-Brightmail-Tracker: AAAAAA== X-Virus-Checked: Checked by ClamAV on apache.org --=_alternative 006D393A852574C5_= Content-Type: text/plain; charset="US-ASCII" Hi all, I'm using the 3.5 beta release and it's not working as I expect it to. I don't know if I'm doing it wrong or this is a bug. I'm using the Row iterator from sheet and subsequently the Cell iterator from row to read a sheet's data. It's basically a sheet with addresses. But some cells (like a 2nd address - typically used for something like an apartment or suite number) are empty. When this value is filled, the size of the iterator comes back as 8 cells in the row (location code, location name, addr1, addr2, city, st, zip, country). But when the addr2 is blank in excel 2007, the iterator comes back as only have 7 values (shifting all the values and messing up my location data basically). I've tried setting the workbook MissingCellPolicy to RETURN_NULL_AND_BLANK but that doesn't seem to help. Am I doing this wrong? How is this typically done? -Jeff *** PROPRIETARY, CONFIDENTIAL OR PRIVILEGED COMMUNICATION *** This communication may contain proprietary, privileged or confidential information protected by law. It is solely for the use of the intended recipient named above. Any review, dissemination, distribution, forwarding, or copying of this communication by someone other than the intended recipient, or the employee responsible for delivering this communication to the intended recipient, is prohibited. If you have received this communication in error, please immediately notify the sender via email, then destroy the original message. --=_alternative 006D393A852574C5_=--