21,893
社区成员




<?PHP
if(ini_get('max_execution_time')<>0)ini_set('max_execution_time',0);
if (@ini_get('com.allow_dcom') != true) @ini_set('magic_quotes_sybase', true);
$host="********";
$user="********";
$pwd="********";
$db="********";
$tb="********";
$filename = "D:\www\xls\\model.xls";
$sheet1 = "sheet2";
$excel_app = new COM("Excel.application") or Die ("Did not connect");
$Workbook = $excel_app->Workbooks->Open("$filename") or Die("Did not open $filename $Workbook");
$con1=mysql_connect($host,$user,$pwd);
$db_query=mysql_select_db($db,$con1);
for($i=2;$i>0;$i++)
{
$Worksheet = $Workbook->Worksheets($sheet1);
$Worksheet->activate;
$excel_cell = $Worksheet->Range("A".$i);
$excel_cell->activate;
$excel_result1 = $excel_cell->value;
$excel_cell = $Worksheet->Range("B".$i);
$excel_cell->activate;
$excel_result2 = $excel_cell->value;
if($excel_result1<>""&&$excel_result2<>"")
{
$sql="update `".$tb."` set `products_model` = '".$excel_result1."' WHERE `products_model` = '".$excel_result2."'";
$query=mysql_query($sql);
}else
{
break;
}
}
#To close all instances of excel:
$Workbook->Close;
unset($Worksheet);
unset($Workbook);
$excel_app->Workbooks->Close();
$excel_app->Quit();
unset($excel_app);
?>
我excle表里面存两行数据一行新的数据,另一行是旧的需要改的数据