Return-Path: Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 94547 invoked from network); 3 Mar 2003 18:29:20 -0000 Received: from lakemtao07.cox.net (68.1.17.114) by daedalus.apache.org with SMTP; 3 Mar 2003 18:29:20 -0000 Received: from gweedo ([68.106.70.45]) by lakemtao07.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP id <20030303182924.XJWN14046.lakemtao07.cox.net@gweedo> for ; Mon, 3 Mar 2003 13:29:24 -0500 MIME-Version: 1.0 To: POI Users List Subject: Re: Getting CELL_TYPE_BLANK when cell has data? References: <3E6365A3.8070101@apache.org> Message-ID: Content-Type: text/plain; charset=iso-8859-15; format=flowed From: Mike Stief Date: Mon, 03 Mar 2003 12:28:43 -0600 In-Reply-To: <3E6365A3.8070101@apache.org> User-Agent: Opera7.01/Win32 M2 build 2651 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Andy, I rewrote the code and found out that I was not iterating properly through the cells causing the issues I was having. Thanks for taking the time to post back. Mike On Mon, 03 Mar 2003 09:24:35 -0500, Andrew C. Oliver wrote: > If I had to guess, I'd guess that you're mismatching the 0-based with the > 1's based in the GUI. Otherwise, show us a sample... > > -Andy > > Mike Stief wrote: > >> Hello, >> >> I reading a xls file created in Excel 2000. In the process of going >> through a worksheet, I come to a point when I receive CELL_TYPE_BLANK >> but the cell has data. It happens on a date formated column. Format is >> (12/12/2003). I also receive a CELL_TYPE_BLANK when trying to get a >> cell that contains a formatted number column. Format is ($1,234). I am >> wondering why I am getting a CELL_TYPE_BLANK when there is data and how >> to solve this problem. >> >> Thanks for your help. >> >> Mike >> > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org > For additional commands, e-mail: poi-user-help@jakarta.apache.org > > -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/