How to get selected dropdown value?

Question

I am trying to get value of cell which has dropdown selection. I tried this one:

$spreadsheet->getActiveSheet()->getCell("D7")->getCalculatedValue()

But I am getting only default one. Dataset for this dropdown select is in another page. How can I get selected value?

It doesn`t matter which value I pick, I always get 'value1'.

Thank you very much in advance.

Possible duplicate of [Get Cell Value with column name in Php Excel](https://stackoverflow.com/questions/32526534/get-cell-value-with-column-name-in-php-excel) — Yassine CHABLI, Apr 05 '19 at 12:52

score 0 · Accepted Answer · answered Apr 08 '19 at 07:44

0

Not a problem. I removed "getCalculatedValue()" and it works fine:

$spreadsheet->getActiveSheet()->getCell("D7")

answered Apr 08 '19 at 07:44

TheDiamondDoge

1 Answers1