rich text elements is not formated properly

Oct 9, 2009 at 3:19 PM


I can not write the formated rich text data from MySql Database in an excel file using PHPExcel 1.6.7

For example; I have data in database in the format--------   <b>Test<i>Test</i></b>

I cannot rendered the text properly in excel.

Please help me.

Oct 11, 2009 at 1:21 AM

PHPExcel does not include methods for entering Rich-Text values via HTML. This may be an idea for future enhancement, but we do not have a solution at the moment.

How important it is for you to preserve the formatting? If you are just worried about the ugly tags showing up in the cells then it is easy to strip them using PHP function strip_tags().