PHP處理excel cvs表格的方法

複製程式碼 程式碼如下:

<?php

$data = array();

//convert a cvs file to an array $data

$handle = fopen("","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("","w");

foreach($data as $curline){

if(fputcsv($handle, $curline)==false){

die("cannot write CSV line");

}

}

fclose($handle);

?>