function

savexls . string . sncode

VERSIONlatest Export data to xls (Excel format)

SAVEXLS

NAME

savexls - Exports data to xls (Excel format), note that this function only supports .xls format

SYNOPSIS

savexls(data,file)

PARAMETERS

data: The data to be exported. file File where it has to be saved.

RETURN

Returns true if the operation has succedeed, and returns false otherwise.

EXAMPLES

savexls(
        [
            ['title1','title2'],
            ['aaa',123],
            [124,'dfg']
        ]
        ,'test.xls'
        ,true);

AUTHOR

Written by Pusnei Sergey and Caroline Laplante, <sergey@sednove.com>

Other functions in String

addslashes

Quote string with slashes.

base64_decode

Decodes data with MIME base64

base64_encode

Encodes data with MIME base64

bin2hex

Converts binary data into hexadecimal representation

cgidata

parse cgidata

chr

Return a specific character

chunk_split

Split a string into smaller chunks.

Count_chars

Return information about characters used in a string.

crc32

Calculates the crc32 polynomial of a string.

This function is used to use any characters as quotes in str ...

esc

This function is used to apply a filter to a string.

explode

Split a string by string

extention

Return the length of an expression.

find_in_set

This function is used to check is a value is set within a li ...

getnbre

This function returns the number of match regular expression

getoffset

This function returns the position of the last match regular ...

getre

This function return the value of a named parameter in a reg ...

hash

Calculate the hash of a string.

hex2bin

Decodes a hexadecimally encoded binary string.

hmac

Compute HMAC

html2text

Convert html text to plain text.

htmlentities

Convert all applicable characters to HTML entities.

htmlspecialchars

Convert special characters to HTML entities.

htmlspecialchars_decode

Convert HTML entities to special characters

html_entity_decode

Convert all HTML entities to special characters

implode

Join array elements with a string.

isalnum

This function is used to verify that the argument string con ...

isalpha

Checks for an alphabetic character.

isascii

Checks whether c is a 7-bit unsigned char value that fits in ...

isblank

Test for whitespace wide character.

iscntrl

Checks for an control character.

isdigit

Checks for a digit (0 through 9).

isfloat

Checks if the argument is a float number.

isgraph

Checks whether c is a character with graphical representatio ...

isinteger

Checks for a digit (0 through 9) that may be preceed by + or ...

islower

Checks for a lower-case character.

isprint

Checks for any printable character including space.

ispunct

Checks for any printable character which is not a space or a ...

isset

This function is used to check if a value is contained in a ...

isspace

Checks whether c is a white-space character.

isupper

Checks for a upper-case character.

iswalnum

This function is used to verify that the argument string con ...

iswalpha

Checks for an alphabetic character.

iswblank

Test for whitespace wide character.

iswcntrl

Checks for an control character.

iswdigit

Checks for a digit (0 through 9).

iswgraph

Checks whether c is a character with graphical representatio ...

iswlower

Checks for a lower-case character.

iswprint

Checks whether c is a character with graphical representatio ...

iswpunct

Checks for any printable character which is not a space or a ...

iswspace

Checks whether c is a white-space character.

iswupper

Checks for a upper-case character.

iswxdigit

Checks for a hexadecimal digits, i.e. one of 0 1 2 3 4 5 6 7 ...

isxdigit

Checks for a hexadecimal digits, i.e. one of 0 1 2 3 4 5 6 7 ...

This function returns the lowercase value of a string.

lcfirst

Returns lc value of a string’s first character.

length

Returns the length of an expression

levenshtein

Return the distance between 2 strings.

ltrim

Eliminates whitespace from the beginning of a string.

money_format

Formats a number as a currency string.

nl2br

Inserts HTML line breaks before all newlines in a string

number_format

Formats a number as a regional number string

ord

Return Unicode value of character.

parse

Parse strings.

parse_query_string

This function is used to parse a query string.

Output a string.

printf

Print formatted text.

quotemeta

Quote meta characters.

resub

Perform a regular expression substitute.

rindex

Locate character in string (last occurence).

rtrim

Strip whitespace (or other characters) from the end of a str ...

savecsv

Stores array to a file.

setlocale

Strip whitespace (or other characters) from the end of a str ...

split

This function is used to split a string.

splitre

This function is used to split a string with a regular expre ...

strcasecmp

Case-insensitive string comparison.

strcspn

Find length of initial segment not matching mask.

strinatcmp

Case insensitive string comparisons using a natural order al ...

stringnify

Take an expression and return a string.

stripos

Find the position of the first occurrence of a case-insensit ...

stripslashes

Un-quotes a quoted string

strip_tags

Strip HTML and extenso tags from a string.

strnatcmp

String comparisons using a natural order algorithm.

strncasecmp

Case-insensitive string comparison of the first n characters ...

strncmp

Comparison of the first n characters.

strpos

Find the position of the first occurrence of a substring in ...

strrev

Reverse a string

strripos

Find the position of the last occurrence of a case-insensiti ...

strrpos

Find the position of the last occurrence of a substring in a ...

strsub

return a substring from the original string.

strtr

Translate characters or replace substrings.

strtr_ctx

Translate substrings.

strtr_list

Translate substrings.

str_getcsv

Parse a CSV string into an array.

str_ireplace

Replace all occurrences of the search string with the replac ...

str_pad

Pad a string to a certain length with another string.

str_repeat

Repeat a string

str_replace

Replace all occurrences of the search string with the replac ...

str_shuffle

Randomly shuffles a string

str_split

Convert a string to an array.