Thanks, Nick! On Wed, Oct 22, 2014 at 3:13 AM, Nick Burch <[email protected]> wrote:
> On Tue, 21 Oct 2014, Blake Watson wrote: > >> I'm working with the output of the sheet's getDataValidations method, >> which >> gives me a getRegions (returning a CellRangeAddressList). >> >> So I can go through each CellRangeAddress, and compare the first and last >> columns and rows with the column and row of the cell I'm curious about. >> > > I think the method you want is on SheetUtil: > https://poi.apache.org/apidocs/org/apache/poi/ss/util/SheetUtil.html# > containsCell%28org.apache.poi.ss.util.CellRangeAddress,%20int,%20int%29 > > boolean containsCell(CellRangeAddress cr, int rowIx, int colIx) > > That should let you easily see if a given cell co-ordinates are in a cell > range address or not > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- *Blake Watson* *PNMAC* Application Development Manager 5898 Condor Drive Moorpark, CA 93021 (805) 330.4911 x7742 [email protected] <[email protected]> www.PennyMacUSA.com <http://www.pennymacusa.com/>
