<?php
$data = array (
0 =>
array (
0 => 'ABC',
1 => 'XYZ'
),
1 =>
array (
1 => 'ADW',
20 => 'XYZ',
26 => 'AA2',
30 => 'PQR',
60 => 'WWW',
701 => 'ZZZ'
)
);
$result = array();
foreach ($data as $rownum => $row) {
foreach ($row as $colnum => $value) {
if ($colnum >= 26) {
$col0 = $colnum % 26;
$col1 = intdiv($colnum, 26);
$colstr = chr(64 + $col1) . chr(65 + $col0);
}
else {
$colstr = chr(65+$colnum);
}
$result[$colstr . ($rownum+1)] = $value;
}
}
print_r($result);
- Output for 7.4.0 - 7.4.33, 8.0.1 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.26, 8.4.1 - 8.4.13
- Array
(
[A1] => ABC
[B1] => XYZ
[B2] => ADW
[U2] => XYZ
[AA2] => AA2
[AE2] => PQR
[BI2] => WWW
[ZZ2] => ZZZ
)
preferences:
97.39 ms | 407 KiB | 5 Q