How get value from Drop-down list

[EugeneZviR]

1. i have xlsx file with dropdowns and i try read them and cell return empty in query
   need try use newDataValidation?
   can you give me example
   Thanks

[cfsimplicity]

Hi, the read() method will only return cell values. Data validations are not themselves cell values, they just limit what values can be entered.

So in other words, if you have added a data validation drop-down to a cell, but no value has been chosen from that drop down, then when you read that cell it will be empty. If you select a value from the drop-down and save the workbook, read() will then return the value you chose.

Hope that makes sense.

[EugeneZviR]

Here file of dropdown what i need get data. Not regular and query give me empty
temp_need_test_dropdowns.xlsx

[cfsimplicity]

Those are not drop-downs. They are images of drop-downs.

[EugeneZviR]

bandicam.2023-12-25.15-14-23-843.mp4

Yes i know. Almost all editors show its like img but if you WPS this will be real dropdown with different options

[cfsimplicity]

Sorry but I don't understand what "WPS" means or what software you are using in your video.

As far as the library/POI is concerned, your spreadsheet does not appear to contain any data validation dropdowns.