Return-Path: Delivered-To: apmail-poi-user-archive@www.apache.org Received: (qmail 57808 invoked from network); 10 Mar 2010 08:10:03 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 10 Mar 2010 08:10:03 -0000 Received: (qmail 56904 invoked by uid 500); 10 Mar 2010 08:09:33 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 56740 invoked by uid 500); 10 Mar 2010 08:09:33 -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 56732 invoked by uid 99); 10 Mar 2010 08:09:32 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Mar 2010 08:09:32 +0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FREEMAIL_FROM,SPF_HELO_PASS,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Mar 2010 08:09:26 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1NpGyX-0003aU-33 for user@poi.apache.org; Wed, 10 Mar 2010 00:09:05 -0800 Message-ID: <27846602.post@talk.nabble.com> Date: Wed, 10 Mar 2010 00:09:05 -0800 (PST) From: Lion Liang To: user@poi.apache.org Subject: Is there a way to get the existing data validations from a spreadsheet? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: liangyue_829@163.com X-Virus-Checked: Checked by ClamAV on apache.org The method HSSFSheet.addValidationData(HSSFDataValidation dataValidation) could add user defined validation rules into the spreadsheet. However, is there a way to get the existing data validations from a sheet/workbook by the POI functions? Please help. Thanks, Lion -- View this message in context: http://old.nabble.com/Is-there-a-way-to-get-the-existing-data-validations-from-a-spreadsheet--tp27846602p27846602.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org