Searching for rows with a certain column value

Feb 12, 2013 at 12:35 PM
First off, I just want to commend all the folks on the EPPlus team for their awesome library. Creating Excel sheets is a snap and it has really helped not to require MS Office installed on the machine that uses my app.

However, I have an existing spreadsheet with 6-7 columns, and I'd like to select a row of that data if one of those columns has a certain value.

I wasn't sure if there was an existing mechanism to do this sort of thing but searching each cell seemed quite expensive.

The worksheet isn't huge, about 500 rows.