How to filter drop-down inside excel file

Help Studio
1

Hi Everyone,

Please give me the solution for the query. I want to filter of excel file but if text is there then we can but what if there is a dropdown (having options values) then how do we search it?
I am reading the excel file but I am not getting all values in my datatable. I am just getting the initial value of dropdown. Please suggest.

Regards,
Hemal

2

@hemal Can you maybe provide an example excel file and explain what actually you want to do with it? We may need to use Macros I guess