PHP处理excel cvs表格的方法实例介绍

2015-01-24信息快讯网

PHP处理excel cvs表格想必有很多朋友对此还是很陌生的吧,下面以实例为大家介绍下,感兴趣的朋友可以参考下哈,希望对你有所帮助

 
<PRE class=php name="code"><?php 
$data = array(); 
//convert a cvs file to an array $data 
$handle = fopen("data.csv","r"); 
while ($curline = fgetcsv($handle, 1000, ",")){ 
$tmp = array(); 
$num = count($curline); 
for($c=0; $c < $num; $c++){ 
array_push($tmp, $curline[c]); 
} 
array_push($data, $tmp); 
} 
print_r($data); 
fclose($handle); 
//convert array $data back to a cvs file 
$handle = fopen("result.csv","w"); 
foreach($data as $curline){ 
if(fputcsv($handle, $curline)==false){ 
die("cannot write CSV line"); 
} 
} 
fclose($handle); 
?> 
</PRE><BR> 
<BR> 
<PRE></PRE> 
©2014-2024 dbsqp.com