excel-reader utf problem

Question

Can you help me with problem writtent below:

I am getting error iconv() [function.iconv]: Detected an illegal character in input string when i am reading xls file and converting it into csv. I am using php-excel-library and i get this error in line:

case 'iconv' :    
     $result = iconv('UTF-16LE', $this->_defaultEncoding, $string);
break;

Does enybody know how to fix it?

Community · Accepted Answer · 2023-11-17 19:32:19Z

2

It means that in your file is a bit-sequence that cannot be mapped onto a char, b/c it's meaningless, and therefore not be converted to another encoding.

Use the //IGNORE-flag as descriped here.

edited Nov 17, 2023 at 19:32

CommunityBot

11 silver badge

answered Jul 13, 2011 at 13:58

Raffael

20.1k16 gold badges93 silver badges169 bronze badges

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

1 Comment

Gasper Over a year ago

i also try this with no success

James Alday · Accepted Answer · 2011-10-18 20:54:30Z

0

Be sure the file is UTF-16LE encoded as trying to import the wrong format will throw those kinds of errors.

Use PHP 5.3 or greater, as PHP < 5.3 cannot handle UTF-16 encoding (check the notes here: link)

Instead of ignore you may want to try //TRANSLIT to have iconv convert the character to one that is compatible in your default encoding (eg, convert MS "fancy quotes" to regular single/double quotes in ascii)

answered Oct 18, 2011 at 20:54

James Alday

8719 silver badges26 bronze badges

2 Comments

kukipei Over a year ago

I have installed php 5.3.8 and I tried //TRANSLIT, and it doesn't work

James Alday Over a year ago

Have you been able to identify the offending character? Try debugging to find out what line of the file it's on and narrow down what character is bad. That was my first step in figuring it out. If you can find the offending character(s) you might be able to track down what the problem with the encoding is.

Collectives™ on Stack Overflow

excel-reader utf problem

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related