PHPExcel. Wrong encoding from html, no styles are applied.

Question

I save the table in xlsx format

$html = $_POST['html']; file_put_contents($path."/table.html", $html); $objReader = new PHPExcel_Reader_HTML; $objPHPExcel = $objReader->load($path."/table.html"); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save($path."/table.xlsx");

The file is created, but instead of the Russian letters kryakozyabry. The html code from the browser page (utf-8) is transferred to $ html. Help defeat the encoding.

With the encoding issue was resolved.

The solution was as always simple. I tried to convert html to Excel. But this html was only the code table

 <table><tr><td></td></tr></table>

but you must

 <html><head><meta charset="UTF-8"></head><body><table> .....................

How to save table styles now?

 <td style='background-color:#F8F8F8; border:1px solid #000; width: 250px'>

Does not help

Try to select in Ixelle to change the encoding to save the file and reopen again.
The file is generated by the script and immediately sent to the manager by e-mail.

thecoder thecoder 430 4 silver marks 16 bronze marks · Answer 1 · 2016-04-07T07:24:17

The solution was as always simple. I tried to convert html to Excel. But this html was only the code table

 <table><tr><td></td></tr></table>

but you must

 <html><head><meta charset="UTF-8"></head><body><table> .....................

thecoder

430 4 silver marks 16 bronze marks

Beautifully turned out probably. The PhpExcel library is actually very helpful. - fonjeekay
But not very. Table styles are not saved: (I don’t know how to win. - thecoder
styles should be in <head> as I understand it, between <style></style> - fonjeekay
or try to enter the style="" attribute style="" in the tags where the styles are needed: <td style="color:grey"></td> pens, even if the version does not work, try another PHPEXcel? - fonjeekay
@fonjeekay Meaning another PHPExcel? - thecoder

|

Community spirit ♦ one · Answer 2 · 2016-04-06T20:07:56

It seems to me that the matter is in file_put_contents

 $html = $_POST['html']; file_put_contents($path."/table.html", mb_convert_encoding($html, 'UTF-8', 'OLD-ENCODING')); $objReader = new PHPExcel_Reader_HTML; $objPHPExcel = $objReader->load($path."/table.html"); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save($path."/table.xlsx");

How to write file in UTF-8 format

I wrote down the file in UTF-8 and windows-1251, and the file opens with cracks.
I think that the library itself crookedly translates Html to xlsx.

Nicolas Chabanovsky ♦ 38.1k 54 gold marks 222 silver marks 438 bronze marks · Answer 3 · 2016-04-06T17:43:11

Try using the function → iconv() .

 $html = $_POST['html']; $html = iconv("cp1251", "UTF-8", $html); file_put_contents($path."/table.html", $html);

PHPExcel. Wrong encoding from html, no styles are applied.

3 answers 3

More articles: