How to get data table from Excel using select

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

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

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

1 Like

@Abubakkar

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

1 Like

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

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

Cheers @Abubakkar

kindly let know for any other queries
Cheers @Abubakkar