Detect if cell is Currency format

Asked Jul 14 '14 at 08:17

Active Sep 04 '15 at 02:56

Viewed 263 times

I have a PHP application that parses Excel files. It reads every cell from Excel so given that it might read dates, int/number, currency, string, etc.

Can I detect if the format of a currency cell? For example, I can detect the date as follows:

$cell = $worksheet->getCellByColumnAndRow($col, $row); $isdate = PHPExcel_Shared_Date::isDateTime($cell);

and I'd like something like this:

$iscurrency = PHPExcel_SOMETHING_DETECTCURRENCY($cell)

edited Sep 04 '15 at 02:56

pnuts

58,317
11
87
139

asked Jul 14 '14 at 08:17

shanks

`currency format` -- could you provide values of this format? – sectus Jul 14 '14 at 08:19
Possibilities are € 500 , $ 500 or so – shanks Jul 14 '14 at 08:31
currency sign + number? – sectus Jul 14 '14 at 08:39
@sangoku do you have problem in reading or detecting? – Mobasher Fasihy Jul 14 '14 at 09:33
@Mobasher its detecting – shanks Jul 14 '14 at 16:12
@sectus yes, base on excel formatting of currency. All i want is to detect the cell if its on currency or date or int or string. For example in excel content: A1 has 10/21/2014, B1 has 1234, C1 has $500, D1 has 'Total' so its A1=date,B1=int,C1=currency,D1=string – shanks Jul 14 '14 at 16:17

Detect if cell is Currency format

0 Answers0