[原创]php批量替换Excel文件内容

$excelPath = "e:\\excel";
$total = $success = $jump = 0;
$objExcel = new COM("excel.application") or die("不能打开Excel应用程序");
$handle = opendir($excelPath); //打开当前目录
readdir($handle); //排除"."
readdir($handle); //排除 ".."
//循环读取文件
while ($file = readdir($handle)) {
	$total++;
	//生成源文件名
	$fileName = $excelPath . DIRECTORY_SEPARATOR .$file;
	$pathinfo = pathinfo($fileName);
	if(strtolower($pathinfo['extension']) != 'xls'){
		echo "已跳过：".$file."，文件格式不对";
		$jump++;
		continue;
	}
	echo "正在替换文件：".$file."\n";
	if(file_exists($fileName)){
		if(!$objExcel->Application->WorkBooks->Open($fileName)){
			echo $file."打开失败，跳过！";
			$jump++;
			continue;
		}
	}
	else{
		echo $fileName."文件不存在\n";
		$jump++;
		continue;
	}
	$totalRow = $objExcel->ActiveSheet->UsedRange->Rows->Count;
	for($i=1;$iWorksheets(1)->Range("A".$i)->Value);//获取到值
		if(in_array($keyword,$replaceIn)){//判断后在这里进行替换
			$objExcel->Worksheets(1)->Range("B".$i)->Value = $replaceRule[$keyword];
			$objExcel->Worksheets(1)->Range("B".$i)->Font->Name = "黑体";
			$objExcel->Worksheets(1)->Range("B".$i)->Font->Size = 12;
		}
	}
	if(!$objExcel->ActiveWorkBook->Saved)
	{
		$objExcel->ActiveWorkBook->save();
		echo $file."保存成功！\n";
		$success++;
	}
	//关闭工作簿
	$objExcel->Quit();
}
echo "\n全部替换完成！共{$total}个，成功{$success}个，跳过{$jump}个！\n";
//清空对象
$objExcel = null;
exit;