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: [email protected] For additional commands, e-mail: [email protected]
