Excel Extraction--Urgent

excel

#1

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

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.

Thanks,
Anjali


#2

4/19 is not provided anywhere.


#3

@vikasrawat911

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


#4

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

image

PFA the workflow below.

Main.xaml (6.8 KB)


#5

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