Most suitable language for performing Excel operations
Adding one to an upper case character using the increment operator
Search for a command to run...
Adding one to an upper case character using the increment operator
No comments yet. Be the first to comment.
Clean your email list even before sending it to a mass emailing solution like AutoSend to avoid a high bounce rate

Try using an alternative to openclaw, which they claim is cheaper to use

Using types (and interfaces) to define a blueprint of a variable

Using GraphQL as an alternative to REST API for Hashnode

making makemigrations work in Django when migrations is not pushed to git

In which language where you increment a character (well .... it has to be uppercase in this case) by 1 and you get the next character in ASCII (also alphabetic) sequence ?
I don't know if this is supported in any other language but this is doable in PHP (even in older versions).
$column = 'B';
echo ++$column;
will output C
But these won't work :
$column = $column + 1; - will throw string to integer operation error - TypeError: 'str' object cannot be interpreted as an integer$column-- will not give you the previous charcater in sequence. Will not throw any errors though. Will retain value as 'B'$column = 'b';This is what I did in a real use-case : (I got the XLSX sheet's data map to a PHP array using another script)

<?php
$data = [
'B' => [5=>105,15,205,22,35,332],
'D' => [5=>95,95,99,32,442,95],
'E' => [5=>62,89,51,55,32,95],
'F' => [5=>66,78,44,9,329,55],
'G' => [5=>55,100,80,63,951,32],
'H' => [5=>10,55,591,32,200,80]
];
?>
<table border="1">
<?php
for ($i = 5; $i <= 10; $i++)
{
echo "<tr>";
for ($j = 'B'; $j !== 'I'; $j++)
{
# echo $j;
if ($j == 'C') continue;
echo "<td>";
if (!isset($data[$j][$i])) continue;
$value = $data[$j][$i];
echo $value;
echo "</td>";
}
echo "</tr>";
}
?>
</table>

Isn't this just so cool ?