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
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
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
what values did you give?