How to get data table from Excel using select

#1

Dear experts,
In Excel sheets
Name value
A 1
B 2
C 3

How can I get the results
If asking A 1
If asking b 2
Incase c 3

Using select query
Could anyone help me please?

Thanks in advance
Abu

1 Like
#2

Hi @Abubakkar

You can use a lookup component for that one. Please check the component that I make. It is possible with this one:

Thanks and regards.

3 Likes
#3

Check this…
ExcelLookup.zip (17.4 KB)
Enter the Name and WriteLine gives you Value for it.

1 Like
#4

@Abubakkar

dt.Select(“Name=‘A’”)(0).Item(“value”).ToString

1 Like
#5

Thanks for the help experts.
If I get some input value 1 to 9
Then I need to get output in matrix.
Like this
1 2 3
4 5 6
7 8 9

Could anyone help me please?

1 Like
#6

For both the questions one for values and one for matrix
here you go
hope itts resolved
matrix.zip (15.7 KB)

Cheers @Abubakkar

#7

kindly let know for any other queries
Cheers @Abubakkar