Hi, I am trying to get Chinese characters from the Excel file but it does not encode it correctly, please help.

Thank you,

Leon

CommentFileSizeAuthor
#3 feeds_excel-05102011.patch4.32 KBleon85321

Comments

leon85321’s picture

leon85321 commented

Ok, turns out newer version of phpExcelReader will fix it.

Here is what I have done:
1. modify the feeds_excel.module:
// require_once($path.'reader.php'); //no need to read this file anymore
require_once($path.'excel_reader2.php'); //new version of phpExcelReader 2.22
// require_once($path.'oleread.inc'); //no need to read this file anymore

2. modify the ExcelParser.inc
//$value = utf8_encode($value); //no need to encode to UTF-8 again.

3. download the newer version of phpExcelReader from here:
http://php-excel-reader2.googlecode.com/files/php-excel-reader-2.22.zip

4. extract to the same location:
/sites/all/modules/feeds_excel/libraries/phpExcelReader/Excel/excel_reader2.php

Then it will work with many other languages since the encoding has been fixed.

derhasi’s picture

derhasi commented
Status: Active » Needs work

Thanks for figuring out the problem. Could you provide a patch for that?

leon85321’s picture

leon85321 commented
StatusFileSize
new feeds_excel-05102011.patch4.32 KB

Hi since this is my first time trying to use the diff, i hope it works ok,

derhasi’s picture

derhasi commented
Status: Needs work » Needs review

Try to have a review soon.

Olelishna’s picture

Olelishna commented

I tried this for russian characters in 7.x-1.0-beta1 and it works!

Thanks.

mrromios’s picture

mrromios commented
Issue summary: View changes
Status: Needs review » Closed (won't fix)