How to read dropdown cell options from excel spreadsheet?

Question

Java

Hello, you need to iteratively go through the entire table and read all the values ​​of all dropdowns in the table. I did not find any normal examples on Apache POI. It was only possible to take the ID of these cells, but not the possible values ​​themselves. How to be?

Answer 1

Good afternoon!
Perhaps the information in the link will be useful to you. Here is an answer to a similar question:
(note both answers)
https://stackoverflow.com/questions/21181551/read-...
Also related:
https://stackoverflow.com/questions/51017694/apach...