Re: Reading rows based on column value

[Mark Beardsley <ma...@tiscali.co.uk>]

Only if you write the code to do it I am afraid; POI does not come with built
in methods that would allow you to sort the rows into order by the contents
of a particular column or to read only those rows where a particular column
holds a specific value. You must write the code to;

Get a row.
Look at the value in a column.
If it contains the value you are lookig for them process the column.
Repeat until all columns have been processed.

Make it into a method and deign that so all you need to pass it is a sheet,
the column number and the value you are looking for. Override the method to
account for the different data types - maybe only String, Integer and float
is all you need.

Yours

Mark B

--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Reading-rows-based-on-column-value-tp5710296p5710297.html
Sent from the POI - Dev mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org