How to get value from PHPExcel_RichText Object?

by websourceblog · March 16, 2017

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();
                    }