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