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(); }
You can easily reset WSL 2 users' password, by just following the following steps. Open…
DreamHost a web hosting company, founded in 1997. It is offering sort of hosting services,…
Menus in WordPress are highly versatile and can be easily modified to change in your…
Laravel is famous and robust PHP framework, widely used in different type of projects. While…
Python is very powerful and famous language, which allow us to write code as per…
In this article, I am going to show you how we can get specific dates…