日期:2014-05-17  浏览次数:20398 次

php excel reader 读取时间字段出错,谁会弄得
时间类型

9:20:00


读出来变成了

0.388888888889


谁会做????



------解决方案--------------------
PHP code

$row = 1;
$handle = fopen("test.csv","r");
while ($data = fgetcsv($handle, 1000, ",")) {
    $num = count($data);
    echo "<p> $num fields in line $row: <br>\n";
    $row++;
    for ($c=0; $c < $num; $c++) {
        echo $data[$c] . "<br>\n";
    }
}
fclose($handle);

#我用上面的代码获取
#date
#2011-4-21
#的数据能正常获取

#你的问题怎么解决的?