<?php
|
|
namespace PhpOffice\PhpSpreadsheet\Calculation\TextData;
|
|
use PhpOffice\PhpSpreadsheet\Calculation\ArrayEnabled;
|
use PhpOffice\PhpSpreadsheet\Calculation\Functions;
|
use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
|
|
class CharacterConvert
|
{
|
use ArrayEnabled;
|
|
/**
|
* CHAR.
|
*
|
* @param mixed $character Integer Value to convert to its character representation
|
* Or can be an array of values
|
*
|
* @return array|string The character string
|
* If an array of values is passed as the argument, then the returned result will also be an array
|
* with the same dimensions
|
*/
|
public static function character(mixed $character): array|string
|
{
|
if (is_array($character)) {
|
return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $character);
|
}
|
|
$character = Helpers::validateInt($character);
|
$min = Functions::getCompatibilityMode() === Functions::COMPATIBILITY_OPENOFFICE ? 0 : 1;
|
if ($character < $min || $character > 255) {
|
return ExcelError::VALUE();
|
}
|
$result = iconv('UCS-4LE', 'UTF-8', pack('V', $character));
|
|
return ($result === false) ? '' : $result;
|
}
|
|
/**
|
* CODE.
|
*
|
* @param mixed $characters String character to convert to its ASCII value
|
* Or can be an array of values
|
*
|
* @return array|int|string A string if arguments are invalid
|
* If an array of values is passed as the argument, then the returned result will also be an array
|
* with the same dimensions
|
*/
|
public static function code(mixed $characters): array|string|int
|
{
|
if (is_array($characters)) {
|
return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $characters);
|
}
|
|
$characters = Helpers::extractString($characters);
|
if ($characters === '') {
|
return ExcelError::VALUE();
|
}
|
|
$character = $characters;
|
if (mb_strlen($characters, 'UTF-8') > 1) {
|
$character = mb_substr($characters, 0, 1, 'UTF-8');
|
}
|
|
return self::unicodeToOrd($character);
|
}
|
|
private static function unicodeToOrd(string $character): int
|
{
|
$retVal = 0;
|
$iconv = iconv('UTF-8', 'UCS-4LE', $character);
|
if ($iconv !== false) {
|
$result = unpack('V', $iconv);
|
if (is_array($result) && isset($result[1])) {
|
$retVal = $result[1];
|
}
|
}
|
|
return $retVal;
|
}
|
}
|
