假如
A替换成B
$st是要替换的字符串
<?php header ( "Content-type: text/html; charset=utf-8" ); date_default_timezone_set ( 'PRC' ); //设置中国时区 include 'PHPExcel.php'; $dir=dirname(__FILE__); echo "<form action='' enctype='multipart/form-data' method='post' name='uploadfile'> <h3>导入Excel表:</h3><input type='file' name='upfile' /> <input type='submit' value='导入' /> </form>"; if(empty($_FILES['upfile'])){ echo 'empty'; exit; } echo "<br>"; $filename = $_FILES['upfile']['tmp_name']; $objPHPExcel = PHPExcel_IOFactory::load($filename);//加载文件 $i=0; $j=0; foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) { //遍历工作表 foreach ($worksheet->getRowIterator() as $row) { //遍历行 $cellIterator = $row->getCellIterator(); //得到所有列 $cellIterator->setIterateOnlyExistingCells( false); // Loop all cells, even if it is not set foreach ($cellIterator as $cell) { //遍历列 if (!is_null($cell)) { //如果列不给空就得到它的坐标和计算的值 if($i%2==0){ $a[$j][0] = $cell->getCalculatedValue(); }else{ $a[$j][1] = $cell->getCalculatedValue(); $j++; } $i++; } } } } $st = ''; foreach ($a as $value){ $st = str_replace($value[0],$value[1],$st); } error_log($st,3,dirname(__FILE__)."/stpx.txt"); ?>