Excel Extraction--Urgent

Hi ,
I am trying to extract values from excel which looks like this :

I want to get the values(x or o) for a specific alphabet (a,b,c… so on) based on the current date, for eg: if today it’s 04/19 I should get value “o” for C and D in the same way “x” for other alphabets.


4/19 is not provided anywhere.


She said it has example u can take any value which is seen in image or our own value from ur excel

You can use Linq to filter the DataTable value as shown below. I am using the ‘Albhabet’ String variable to store a single alphabet. I am using date ‘4/19’ as the column name.

dtSample.AsEnumerable.Where(function(x) x(0).ToString.Contains(alphabet)).CopyToDataTable.Rows(0)(“4/19”).ToString


PFA the workflow below.

Main.xaml (6.8 KB)

4/19 is not there in the excel, so we need to take 4/17 as my start cell