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
Anil_G
(Anil Gorthi)
February 3, 2023, 7:49am
2
@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,
Anil_G
(Anil Gorthi)
February 6, 2023, 6:49am
4
@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
Anil_G
(Anil Gorthi)
February 6, 2023, 7:06am
6
@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
1 Like