Devam Ediyor

Fix exporting for PHP to Excel for Hebrew text

I have a php script that exports some information to Excel using this function:

function xlsWriteLabel($Row, $Col, $Value ) {

$L = strlen($Value);

echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);

echo iconv("UTF-8", "windows-1255", $Value);

return;

}

The problem is that data in Hebrew is not exported good to excel. Can't find a way to fix it.

The data is stored in mySQL database, the field is in latin1_swedish_ci encoding.

The data is displayed good in the browser using UTF8, but in the Excel it comes out gibbrish.

Should be something like 20 minutes work for someone that knows hot to fix it. Max budget for this fix is 30$.

Beceriler: Excel, MySQL, PHP

Daha fazlasını görün: excel hebrew encoding php, the fix it, excel for windows 8, php fix hebrew, mysql fix excel, fix hebrew utf mysql, php excel utf hebrew, php excel hebrew, to excel, text to excel, php to c, hebrew t, fix database, Exports, excel function, excel budget, database to excel, mysql script utf8, fix excel, text row, hebrew minutes, php encoding, text function excel, row text php, php exporting data excel hebrew

İşveren Hakkında:
( 8 değerlendirme ) Beer Sheva, Israel

Proje NO: #687682

Seçilen:

MustafaSR

Hello Sir, Please check PMB

1 gün içinde 30$ USD
(74 Değerlendirme)
5.7

7 freelancer bu iş için ortalamada 30$ teklif veriyor

phpSQLexpert

Hi, please check inbox. I attached the solution. If it works just pay me. Cheers, Sam

in 0 gün içinde30$ USD
(18 Değerlendirme)
4.6
squallcs12

I know how to fix this, let start asap, sir. I'm waiting for this. Thank you.

in 0 gün içinde30$ USD
(17 Değerlendirme)
3.7
sankethshah

Will be done successfully. Please check PM.

1 gün içinde 30$ USD
(1 Değerlendirme)
1.2
programmerdelhi

Hi Please see pmb

1 gün içinde 30$ USD
(1 Değerlendirme)
0.0
sharmachandra

I know what the problem can import and export data using xls file. please send me more detail. i am ready to do that

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
onedesksolutions

Hi, Please check my CV. Thanks

1 gün içinde 30$ USD
(0 Değerlendirme)
3.3