0 Replies - 214 Views - Last Post: 05 February 2013 - 08:07 PM

#1 wama_mms  Icon User is offline

  • D.I.C Head

Reputation: -1
  • View blog
  • Posts: 54
  • Joined: 06-May 12

arabic characters doesn't appear in exported excel file

Posted 05 February 2013 - 08:07 PM

hi guys i am using the following code to export a table in my DB in excel sheet
<?php
	mysql_query("set names utf8");

	mysql_connect('localhost','root','admin');
	mysql_select_db('mms');
	
    $result=mysql_query("select * from test");
    function xlsBOF()
    {
    echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
    return;
    }
    function xlsEOF()
    {
    echo pack("ss", 0x0A, 0x00);
    return;
    }
    function xlsWriteNumber($Row, $Col, $Value)
    {
    echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);
    echo pack("d", $Value);
    return;
    }
    function xlsWriteLabel($Row, $Col, $Value )
    {
    $L = strlen($Value);
    echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);
    echo $Value;
    return;
    }
    header("Pragma: public");
    header("Expires: 0");
    header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
    header("Content-Type: application/force-download");
    header("Content-Type: application/octet-stream");
    header("Content-Type: application/download");;
    header("Content-Disposition: attachment;filename=list.xls");
    header("Content-Transfer-Encoding: binary ");
    xlsBOF();
     
    xlsWriteLabel(0,0,"id");
    xlsWriteLabel(0,1,"name");
    $xlsRow = 1;
    while($row=mysql_fetch_array($result))
    {
    xlsWriteNumber($xlsRow,0,$row['id']);
    xlsWriteLabel($xlsRow,1,$row['name']);
    $xlsRow++;
    }
    xlsEOF();
    ?>


and i have tried a lot to solve this problem but i can't find a solution. so please help me

Is This A Good Question/Topic? 0
  • +

Page 1 of 1