Extract data from the excel of the input month

Hi ,

Can you please help me to extract data from excel of the month provided from the input dialogue. Need to fetch data of the particular month and year passed in the input dialogue.

Hi @rpatil is it okay if you share your workflow to address your concern?

1 Like

Hi I have the below table in an excel where the date is present in the 3rd row without any header for the first column as shown below. Can you please tell me on how I can fetch the value s
My Condition is fetch the entire row data where the month and year is provided by the user. Example : If I provide the month as October and year as 2019 then the entire row data containing entries related to that month should be obtained . In the below case it would be the entire row of data where the date is 31/10/2019

image 7770102001 7770102002 7770102003 7770102004
2 3 4 5
AUD CA 1307 AUD CA 1308 AUD CA 1309 AUD CA 1310
2019/10/31 121212 121212 11111 121212
2019/11/01 121212 121212 121212 121212

1 Like

Hi @Gemlan have the below table in an excel where the date is present in the 3rd row without any header for the first column as shown below. Can you please tell me on how I can fetch the value s
My Condition is fetch the entire row data where the month and year is provided by the user. Example : If I provide the month as October and year as 2019 then the entire row data containing entries related to that month should be obtained . In the below case it would be the entire row of data where the date is 31/10/2019

image

can you share excel

HI please find the excel test.xlsx (11.1 KB)
@ERDAL_TOP @Gemlan

test_2.xaml (7.6 KB)
you can develop your own code on it

Hi @ERDAL_TOP ,

Thank you but i am getting the below error

image

what values did you give?