UTF-8 Parsing error in reading UTF-8 Excel files using PHP-ExcelReader

Question

I’m trying to read and parse a UTF-8 Excel file using the PHPExcelReader but unfortunately this does not work correctly and I receive some ???? Instead of UTF-8 characters. Would you please help me about the instructions about the way to handle this situation? I have used this configuration for my parsing:

$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('CP1251');
$data->setUTFEncoder('mb');

Thanks

Why CP1251 if you want UTF-8? What characters should it output instead of "???"? — deceze
– deceze ♦, Commented Jan 1, 2012 at 11:35

Mark Baker · Accepted Answer · 2012-01-01 12:32:50Z

1

UTF-8 is the default encoding for Spreadsheet_Excel_Reader...you should not need to change this at all unless you want the values automatically converted to some other charset.

e.g.

$data = new Spreadsheet_Excel_Reader("test.xls",true,"UTF-16");

to convert outputs to UTF-16

answered Jan 1, 2012 at 12:32

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pang · Accepted Answer · 2015-03-07 06:32:48Z

1

I tried UTF-16 but there's still an error.

Then I tried:

$data->setOutputEncoding('UTF-8');
$data = new Spreadsheet_Excel_Reader("test.xls",true,"UTF-8");

This is ok.

edited Mar 7, 2015 at 6:32

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Feb 5, 2015 at 11:36

Hoc N

1531 gold badge3 silver badges12 bronze badges

1 Comment

Nilesh Over a year ago

$excel = new PhpExcelReader(); $excel->setOutputEncoding('UTF-8'); This worked for me after hours of different trials. Thank You.

Collectives™ on Stack Overflow

UTF-8 Parsing error in reading UTF-8 Excel files using PHP-ExcelReader

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related