How to read cell value from drop Down List in excel

Hi All,

I need to get a cell value which was updated as drop-down in excel.

Here I need to read or store all values which mentioned in GP_, sometime it be only one value and sometime we get three value, when I tried excel activity I am getting only one value.

Is there any method to read dropdown value in excel

@n.krishna.moorthy

You can try usign read cell activity it should work…Play around with the preserve format option in the properties

cheers

It’s not working I am getting only one value,

@n.krishna.moorthy

If only one value is selected then you will get only one value there

Cheers

How to select all value and store in variable

@n.krishna.moorthy

All values in the sense which are not selected also …you want to get from drop down?

Try using read cell workbook activity …it might work…

Another way would be yo use a macro to extract

Another way is to use ui and perform clicks and get text

Cheers

Yes need to get all values, since we need to compare it, will try with macro

  • List item
1 Like