PHP

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

ReactJs, NodeJs, Amazon Web Services, Symfony, Laravel, CodeIgniter, Zend Framework, WordPress, Drupal, Magento, Angular

Recent Posts

How to Add an Addon Domain in GoDaddy with Web Hosting Deluxe

Add an Addon Domain in GoDaddy with Web Hosting Deluxe (Step-by-Step Guide). If you are…

1 month ago

Developing a RESTful API with Node.js, Express.js, MongoDB, and TypeScript

The ability to create reliable APIs is essential in today's web development environment. I'll show…

4 months ago

XML in REST API response and SOAP XML.

The difference between XML that we get in response to any REST API and XML…

9 months ago

How to install and configure Apache2 on WSL2?

I hope you already have WSL2 installed and enabled. So, setting up Apache2 on WSL2…

1 year ago

How to install NVM on Windows?

Install NVM on Windows Node Js is a JavaScript runtime environment used widely in today’s…

1 year ago

How to reset WSL 2 user’s password?

You can easily reset WSL 2 users' password, by just following the following steps. Open…

2 years ago