Return-Path: Delivered-To: apmail-poi-user-archive@www.apache.org Received: (qmail 79966 invoked from network); 12 Jan 2010 15:59:51 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 12 Jan 2010 15:59:51 -0000 Received: (qmail 84506 invoked by uid 500); 12 Jan 2010 15:59:51 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 84488 invoked by uid 500); 12 Jan 2010 15:59:51 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Received: (qmail 84478 invoked by uid 99); 12 Jan 2010 15:59:51 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Jan 2010 15:59:51 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [160.83.58.66] (HELO loninmrp8.uk.db.com) (160.83.58.66) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Jan 2010 15:59:40 +0000 Received: from sdbo1103.uk.db.com (LONINMTP1103.uk.db.com [10.232.160.23]) by loninmrp8.uk.db.com (8.14.3/8.14.3) with ESMTP id o0CFxIEJ030380 for ; Tue, 12 Jan 2010 15:59:18 GMT To: user@poi.apache.org Subject: reading the drop down list cells MIME-Version: 1.0 X-Mailer: Lotus Notes Release 6.5.5 CCH1 March 07, 2006 From: Vijayakumar Gowdaman Message-ID: Date: Tue, 12 Jan 2010 15:59:13 +0000 X-MIMETrack: Serialize by Router on sdbo1103/DMGUK/DeuBaInt/DeuBa(Release 6.5.6FP1 HF278|June 19, 2009) at 12/01/2010 15:59:18, Serialize complete at 12/01/2010 15:59:18 Content-Type: multipart/alternative; boundary="=_alternative 0057D18F802576A9_=" --=_alternative 0057D18F802576A9_= Content-Type: text/plain; charset="US-ASCII" When reading the spreadsheet how to identify the cell containing a drop down list. After identifying I need to retrieve all the values in the drop down list. Also when writing in to the existing spreadsheet I want to update the selected value in the drop down list cell. Can some one please point me in the right on how to do these tasks using POI. Regards, Vijayakumar Gowdaman --- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Please refer to http://www.db.com/en/content/eu_disclosures.htm for additional EU corporate and regulatory disclosures. --=_alternative 0057D18F802576A9_=--