How to filter drop-down inside excel file

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.


@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