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.
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