Looping through excel pulling out a row ??

[Ron]

Hello,

I am looking for some way to loop through a spreadsheet and look for a
specific word in a rows cell and then take all rows that have that
word, take the entire row and put them into their own sheet.

so if I had something like this
A B C D
1 you are yellow now
2 you are blue yesterday
3 you are red tomorow
4 you are red now

so I want the loop to look for everything in C and for example all
YELLOW, or all RED would go on their own sheet

so a new sheet would look like this
you are red tomorow
you are red now
and say I want that new sheet to be in sheet2

thanks

 

[sloan]

You can look at the excel file....using an IDataReader ...and specify a
where clause.

http://aspalliance.com/958_CodeSnip_How_to_Query_and_Display_Excel_Data_in_GridView_Control


And change

"SELECT * FROM [Sheet1$]"

to

"SELECT * FROM [Sheet1$] where last_name = 'smith'"

or somethng like that.

last_name would be a header row name of course.

your connect string must also have HDR=Yes