I am trying to read an .xls file using PHPexcel and PHPexcelreader.
Can someone please advise how to distinguish between currency formats in a certain cell? In particular i need to be able to distinguish USD ($), EUR, and BGN (Bulgarian leva - лв) currencies. I can easily recognize BGN currency with something like
Code: Select all
stripos($currency,'лв',0)I've also tried to get the formatted value of the cell (ex. $120.53), but still no luck - couldn't find a method that can do this on both classes.
Thanks in advance.
Dancho