PHPEXCEL read special characters that didn't appear in excel sheet (â)

Asked Sep 07 '21 at 11:50

Active Jan 09 '23 at 16:36

Viewed 152 times

I have column name in excel that have name : Hibah Ather when I read it by PHPExcel I get name : Hibahâ ather I tried to create new sheet and rewrite name and remove space between first and last name

I read it by : strtolower(trim($sheet->getCell('B' . $rowNum)->getValue())); enter image description here

edited Jan 09 '23 at 16:36

devpro

16,184
3
27
38

asked Sep 07 '21 at 11:50

Menna Nasser

What encoding are you using for the excel sheet ? – Azoel Sep 07 '21 at 11:52
my encoding utf-8 – Menna Nasser Sep 07 '21 at 12:43
And your database encoding ? – Azoel Sep 07 '21 at 13:16
utf-8mb4_unicode_ci – Menna Nasser Sep 07 '21 at 14:14
Did you tried this https://stackoverflow.com/questions/37998179/phpexcel-how-to-get-cell-value-even-with-special-characters ? Have you tried to dump() the value just after reading excel, before inserting in BDD ? Is the value the same ? – Azoel Sep 07 '21 at 15:07
i read data from excel to insert it in database ... when i dump it before insert i get it with special character – Menna Nasser Sep 08 '21 at 09:07

PHPEXCEL read special characters that didn't appear in excel sheet (â)

0 Answers0