Class: PHPExcel_Shared_String

static string ControlCharacterOOXML2PHP( [string $value = ''])

Convert from OpenXML escaped control character to PHP control character Excel 2007 team: ---------------- That's correct, control characters are stored directly in the shared-strings table.

Convert from OpenXML escaped control character to PHP control character Excel 2007 team: ---------------- That's correct, control characters are stored directly in the shared-strings table. We do encode characters that cannot be represented in XML using the following escape sequence: _xHHHH_ where H represents a hexadecimal character in the character's value... So you could end up with something like _x0008_ in a string (either in a cell value (<v>) element or in the shared string <t> element.

Tags:

Parameters:

static string ControlCharacterPHP2OOXML( [string $value = ''])

Convert from PHP control character to OpenXML escaped control character Excel 2007 team: ---------------- That's correct, control characters are stored directly in the shared-strings table.

Convert from PHP control character to OpenXML escaped control character Excel 2007 team: ---------------- That's correct, control characters are stored directly in the shared-strings table. We do encode characters that cannot be represented in XML using the following escape sequence: _xHHHH_ where H represents a hexadecimal character in the character's value... So you could end up with something like _x0008_ in a string (either in a cell value (<v>) element or in the shared string <t> element.

Tags:

Parameters:

static string ConvertEncoding( string $value, string $to, string $from)

Convert string from one encoding to another.

Convert string from one encoding to another. First try mbstring, then iconv, or no convertion

Tags:

Parameters:

static int CountCharacters( string $value, [string $enc = 'UTF-8'])

Get character count.

Get character count. First try mbstring, then iconv, finally strlen

Tags:

Parameters:

static string FormatNumber( mixed $value)

Formats a numeric value as a string for output in various output writers forcing point as decimal separator in case locale is other than English.

Formats a numeric value as a string for output in various output writers forcing point as decimal separator in case locale is other than English.

Tags:

Parameters:

static boolean getIsIconvEnabled( )

Get whether iconv extension is available

Get whether iconv extension is available

Tags:

static boolean getIsMbstringEnabled( )

Get whether mbstring extension is available

Get whether mbstring extension is available

Tags:

static boolean IsUTF8( [string $value = ''])

Check if a string contains UTF8 data

Check if a string contains UTF8 data

Tags:

Parameters:

static string SanitizeUTF8( string $value)

Try to sanitize UTF8, stripping invalid byte sequences.

Try to sanitize UTF8, stripping invalid byte sequences. Not perfect. Does not surrogate characters.

Tags:

Parameters:

static string Substring( [string $pValue = ''], [ $pStart = 0], [ $pLength = 0], int $start, int $length)

Get a substring of a UTF-8 encoded string

Get a substring of a UTF-8 encoded string

Tags:

Parameters:

static string UTF8toBIFF8UnicodeLong( string $value)

Converts a UTF-8 string into BIFF8 Unicode string data (16-bit string length)

Converts a UTF-8 string into BIFF8 Unicode string data (16-bit string length) Writes the string using uncompressed notation, no rich text, no Asian phonetics If mbstring extension is not available, ASCII is assumed, and compressed notation is used although this will give wrong results for non-ASCII strings see OpenOffice.org's Documentation of the Microsoft Excel File Format, sect. 2.5.3

Tags:

Parameters:

static string UTF8toBIFF8UnicodeShort( string $value)

Converts a UTF-8 string into BIFF8 Unicode string data (8-bit string length)

Converts a UTF-8 string into BIFF8 Unicode string data (8-bit string length) Writes the string using uncompressed notation, no rich text, no Asian phonetics If mbstring extension is not available, ASCII is assumed, and compressed notation is used although this will give wrong results for non-ASCII strings see OpenOffice.org's Documentation of the Microsoft Excel File Format, sect. 2.5.3

Tags:

Parameters:

static void _buildControlCharacters( )

Build control characters array

Build control characters array

Tags: