Repository navigation
How get value from Drop-down list #351
Description
Activity
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.
Here file of dropdown what i need get data. Not regular and query give me empty
temp_need_test_dropdowns.xlsxThose are not drop-downs. They are images of drop-downs.
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
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.
need try use newDataValidation?
can you give me example
Thanks