RE: [PHP] fgetcsv() excel data missing
| From: | Jay Blanchard | Date: | Fri, 18 Feb 2005 13:56:15 +0000 |
| Subject: | RE: [PHP] fgetcsv() excel data missing | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-209024@lists.php.net to get a copy of this message | ||
[snip]
Thanks for the reply.
It shows ÐÏࡱá\\\\\\\\\\\\\\\\>\\þÿ etc.
source code I used is
$handle = fopen ("file.xls","r");
while ($data = fgetcsv ($handle, 1000, ","))
{
$num = count($data);
for ($c=0; $c < $num ; $c++)
{
$str_email = $data[$c];
echo $str_email;
}
}
[/snip]
You have to save the .xls file as a .csv file, then you can open and getcsv