How get value from Drop-down list

[EugeneZviR]

trafficstars

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]

https://github.com/cfsimplicity/spreadsheet-cfml/assets/130551296/9d836cb6-f68d-4c7d-987a-6ddda7fcc6af

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.