Click here to Skip to main content
14,383,854 members
Rate this:
Please Sign up or sign in to vote.
See more:
I need to search for a country name in an excel file and assing those values for multiple textboxes. For example:

Afghanistan | +4 | AF | Kabul.

When the user searches for the country name, the form will display the timezone (+4), Country Code (AF), the name (Afghanistan) and the capital city (Kabul) in 4 different textboxes.

What I have tried:

So far I managed to find the location of the searched country, so if the user searches for "Afghanistan" I can locate the position (column A, row 1), but I have no clue about how to read that value and the rows next to it to assign it to the multiple textboxes
Updated 23-Jan-17 5:52am
F-ES Sitecore 23-Jan-17 9:57am
Post the code you have so far
[no name] 23-Jan-17 9:57am
That makes no sense to me. If you can find what you are looking for in the file, then you know how to read it. So you are saying that you can't read some data that you have already read?
#realJSOP 23-Jan-17 10:07am
What are you using to read the excel file? Every library/framework does it a little differently.
Member 12815488 23-Jan-17 19:54pm
agreed, please post what you are using (interop, 3rd party)
if you can read country please post the code you've used to read it

1 solution

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

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100