how to select rows from excel sheet in c#

Question

Hi I have written a code to read from excel sheets and query them according to filter set But am stuck at

Select * from [sheetname] where [col] not like '%something%'

How can I write the not part? Rest all query just work fine The one above ignores the not and executes

NOT LIKE should work - what errors/bad results are you getting? — D Stanley
– D Stanley, Commented Mar 21, 2014 at 13:09
Without seeing more of your code it's tough to guess what could help...maybe storing your data in a datatable and using a rowfilter would help? — Tim
– Tim, Commented Mar 21, 2014 at 13:11
Please post some sample data, show the exact query you're using, and show what the output is, and explain why that output isn't what you were expecting. — mason
– mason, Commented Mar 21, 2014 at 13:36

krillgar · Accepted Answer · 2014-03-21 13:06:21Z

1

If you don't have to use ADO and OLE to read your spreadsheet, I would recommend using EP Plus. It's a project that allows you to work with Spreadsheets in a much better OOP paradigm. It also abstracts all of the gotchas that come from the different internal formatting of .xlsx files versus the older .xls files.

answered Mar 21, 2014 at 13:06

krillgar

12.9k6 gold badges56 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

goldsmit409 Over a year ago

It's like almost I am doing the same thing but only to filter I am not getting the query rest I can select rows on condition EQUAL TO or like just can't do is NOT LIKE

D Stanley Over a year ago

@aadilsiddiqui Why can't you use NOT LIKE? It's perfectly valid syntax. Are you getting an error or bad results?

goldsmit409 Over a year ago

I get the same result as by using LIKE, it seems like it's ignoring the NOT part

Rory · Accepted Answer · 2014-03-21 13:04:16Z

0

Is it just you don't have quotes around %something%?

Check out this if you want to melt your brain with Excel possibilities (search the comments for 'not like'), and perhaps solve your problem at the same time.

edited Mar 21, 2014 at 13:04

answered Mar 21, 2014 at 12:58

Rory

42.2k56 gold badges192 silver badges271 bronze badges

1 Comment

goldsmit409 Over a year ago

I do have quotes '%something%'

Collectives™ on Stack Overflow

how to select rows from excel sheet in c#

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related