php 操作EXCEL文件

	<?php
	error_reporting(E_ALL ^ E_NOTICE); 
	if($_POST){ 
	$Import_TmpFile = $_FILES['file']['tmp_name']; 
	require_once 'conn.php';  
	require_once 'Excel/reader.php'; 
	$data = new Spreadsheet_Excel_Reader(); 
	$data->setOutputEncoding('gbk'); 
	$data->read($Import_TmpFile); 
	$array =array(); 
	
	for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) { 
	for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) { 
	$array[$i][$j] = $data->sheets[0]['cells'][$i][$j]; 
	} 
	} 
	sava_data($array); 
	
	} 
	function sava_data($array){    
	$count =0;    
	$total =0; 
	
	
	foreach( $array as $tmp){ 
	
	$strs=$tmp[14];//这个数字是控制数量的
	$newdate = explode("/", $strs);
	$wokao=	$newdate[2]."-".$newdate[1]."-".$newdate[0];
	$Isql = "Select product_id from  kc_product  where product_id='".$tmp[1]."'"; 
	$sql = "Insert into kc_product(product_id,bianhao,xinghao,chanshang,content,image,rosh,kucun,num,pihao,feng,onecolumnid,twocolumnid,time)value("; 
	$sql.="'".$tmp[1]."','".$tmp[2]."','".$tmp[3]."','".$tmp[4]."','".$tmp[5]."','".$tmp[6]."','".$tmp[7]."','".$tmp[8]."','".$tmp[9]."','".$tmp[10]."','".$tmp[11]."','".$tmp[12]."','".$tmp[13]."','".$wokao."')"; //,'".$wokao."'时间
	 //echo $sql;上面这个是我的数据表名和字段，大家自己修改下就可以了	 
	if(! mysql_num_rows(mysql_query($Isql) )){ 
	if( mysql_query($sql) ){ 
	  $count++; 
	} 
	} 
	$total++; 
	} 
	echo "<script>alert('共有".$total."条数据，导入".$count."条数据成功');</script>"; 
	geturl("product.php");	
	
	} 
	
	function TtoD($text){ 
	$jd1900 = GregorianToJD(1, 1, 1900)-3; 
	$myJd = $text+$jd1900; 
	$myDate = JDToGregorian($myJd); 
	$myDate = explode('/',$myDate); 
	$myDateStr = str_pad($myDate[2],4,'0', STR_PAD_LEFT)."-".str_pad($myDate[0],2,'0', STR_PAD_LEFT)."-".str_pad($myDate[1],2,'0', STR_PAD_LEFT); 
	return $myDateStr;        
	} 
	?>