php excel A 列字符串替换成B列 字符串

假如

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");


?>