Tuesday, November 14, 2017

(SOLVED) Converting utf8 to html-entities worked . php header excel and utf-8

<?php

header("Content-Type: application/vnd.ms-excel");
header('Content-Disposition: attachment; filename="sample.xls"');
echo "
    <html xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\">
    <html>
        <head><meta http-equiv=\"Content-type\" content=\"text/html;charset=utf-8\" /></head>
        <body>
";

echo  "

<table
>
<thead>
<tr>
<th>Subs Name</th>
<th>Mobile No</th>
<th>Address</th>
<th>City</th>
<th>District</th>
<th>DOB</th>
<th>Occupation</th>
<th>Nominee</th>
<th>Adhaar No</th>
</tr>
</thead>
<tbody>
<tr>
<td >सत्येन्द्र यादव </td>
<td>8299514347</td>
<td>रावतपुर</td>
<td>कानपूर </td>
<td>कानपूर </td>
<td>01-SEP-17</td>
<td>टेस्ट </td>
<td>प्रदीप सर </td>
<td>123456789123</td>
</tr>
<tr>
<td >राम दास</td>
<td>9628177885</td>
<td>राम नगर</td>
<td>कानपुर</td>
<td>कानपुर</td>
<td>05-OCT-17</td>
<td>स्टूडेंट</td>
<td>सीता</td>
<td>987645682154</td>
</tr>
</tbody>
</table>
    ";


echo "</body></html>";

?>

No comments:

Post a Comment