Find a string in excel

Question

4.00/5 (1 vote)

See more:

I need to upload an excel file and it'll be any format. I need to find a string in that excel before showing the values in grid view.
For eg:
In one excel, first 5 rows have values and from 6th row onwards, I'll have datas to fill the gridview.
In another excel, first 8 rows have some values and from 10 th row onwards, I'll have datas to fill the gridview.
My question is how to find the string or value from that excel and then load that corresponding value in the grid view.

Posted 3-Jan-12 0:12am

skkworld

Add a Solution

Comments

Amir Mahfoozi 3-Jan-12 6:25am

Start recording a macro and then try to find a text. Then stop recording and goto View > Macros and see what has been saved. You can call that function in Office interop services exactly. This is a general way to understand what to do in Office interop services (either its in Csharp or VB.NET). Good Luck

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RaviRanjanKr · Answer 1 · 2012-01-03T00:24:00

Solution 1

You can use Range.Find Method [^] which is used to finds specific information in a range and returns a Range object that represents the first cell where that information is found.

VB

currentFind = this.Fruits.Find("YourSearchString", missing,
    Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart,
    Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, false,
    missing, missing);

Reference Link :- Search for Text in Worksheet Ranges[^]

Posted 3-Jan-12 0:24am

RaviRanjanKr

Comments

Rajesh Anuhya 3-Jan-12 8:27am

Good answer ravi +5

RaviRanjanKr 3-Jan-12 8:32am

Thanks :)

Wendelius 3-Jan-12 14:59pm

Exactly, 5.