How to get value from PHPExcel_RichText Object?
Get Value from PHPExcel_RichText Object
We can read and create excel, csv files from phpexcel library. While reading excel file with phpexcel, you might get richtext object like following.
[0] => Array
(
[description] => PHPExcel_RichText Object
(
[richTextElements:PHPExcel_RichText:private] => Array
(
[0] => PHPExcel_RichText_TextElement Object
We can’t simply get PHPExcel_RichText Object by getValue(), we will need to check if its instance is of PHPExcel_RichText then we will get its plain value. Code as following.
if ($worksheet->getCellByColumnAndRow(2, $row)->getValue() instanceof PHPExcel_RichText) {
$rows[$i]['description'] = $worksheet->getCellByColumnAndRow(2, $row)->getValue()->getPlainText();
} else {
$rows[$i]['description'] = $worksheet->getCellByColumnAndRow(2, $row)->getValue();
}
