3v4l.org

run code in 300+ PHP versions simultaneously
<?php $labels = [ ["EY>Yes","Media Type>Category B","Coverage Type>Quote","Industry Programs>Communications","Score>1"], ["EY>No","Media Type>Category B2","Coverage Type>Quote2","Industry Programs>Communications2","Score>2"], ]; $i = 0; foreach($labels[0] as $ind=>$label){ $letter = range('A', 'Z')[$ind]; $tmp = explode('>',$label); $col_names[] = $tmp[0]; echo $letter.'1'."\r\n"; //$objPHPExcel->getActiveSheet()->setCellValue($letter.'1',$tmp[0]); echo "Column -> $tmp[0] \r\n"; } echo "\r\n\r\n"; // print_r($col_names); // column names /* ( [0] => EY [1] => Media Type [2] => Coverage Type [3] => Industry Programs [4] => Score ) */ foreach ($labels as $ind=>$item){ $index = $ind + 2; foreach($item as $ind2=>$data){ $letter = range('A', 'Z')[$ind2]; echo "$letter$index \r\n"; $val = explode('>',$data); //$objPHPExcel->getActiveSheet()->setCellValue("$letter$index",$val[1]); echo "Value at $index -> $val[1] \r\n\r\n"; } echo "\r\n\r\n"; }

preferences:
28.54 ms | 405 KiB | 5 Q