reading strikeThrough values from excel cell in php

Asked Sep 21 '16 at 04:57

Active Sep 21 '16 at 04:57

Viewed 424 times

While Reading Excel file in php using PHPExcel Library, i can read the font value of a cell whether it is strike through or not using below code

foreach($sheetData[$row] as $key=>$value){

$array_key=$key.$row;
$sheetStrikeThrough[$row][$key]=$objPHPExcel->getActiveSheet()->getStyle($array_key)->getFont()->getStrikethrough();}

BUT

if a cell have multiple values separated by comma (,) i.e VAL1, VAL2, VAL3 and only VAL2 is strikeThrough then this library doesn't read the cell as strikeThrough.

How i can find the strikThrough value in a cell even if complete cell isn't strikeThrough then too.

asked Sep 21 '16 at 04:57

Raza Quaidian

1

http://stackoverflow.com/questions/12979394/phpexcel-cannot-reads-styles-from-xls – Tim Williams Sep 21 '16 at 05:57
2

https://github.com/PHPOffice/PHPExcel/issues/227 – Tim Williams Sep 21 '16 at 06:02
@ Tim Williams, Thank you very very much! your comments moved me in right direction and now its done! again i would say thank you very much – Raza Quaidian Sep 21 '16 at 11:33

reading strikeThrough values from excel cell in php

0 Answers0