http://www.zorba-xquery.com/modules/excel/information

import module namespace excel-information = "http://www.zorba-xquery.com/modules/excel/information";

This is a library module offering the same set of functions defined by Microsoft Excel, under Information Functions.

Sorin Nasoi

xquery version "3.0" encoding "utf-8";

• the XQuery module can be found here.

Imported modules:

• http://www.zorba-xquery.com/modules/excel/math

For more details please also see:

• Excel Documentation: Information Functions

is-blank

declare function excel-information:is-blank (
            $value as xs:anyAtomicType? 
 ) as xs:boolean

Test if the passed argument is empty of not.

• $value the value.

• If the value of $arg is the empty sequence, the function returns true, otherwise the function returns false.

• http://www.w3.org/TR/xquery-operators/#func-empty

is-even

declare function excel-information:is-even (
            $value as xs:anyAtomicType? 
 ) as xs:boolean

Test is a number is even.

• $value the value.

• TRUE if number is even, FALSE if number is odd.

• excel-err:Value if provided value is not a number.

• http://office.microsoft.com/en-us/excel/HP052091481033.aspx

is-odd

declare function excel-information:is-odd (
            $value as xs:anyAtomicType? 
 ) as xs:boolean

Test is a number is odd.

• $value the value.

• TRUE if number is odd, FALSE if number is even.

• excel-err:Value if provided value is not a number.

• http://office.microsoft.com/en-us/excel/HP052091491033.aspx

islogical

declare function excel-information:islogical (
            $value as xs:anyAtomicType? 
 ) as xs:boolean

Tests if the passed $value is a logical value.

• $value the value.

• TRUE if $value refers to a logical value.

• http://office.microsoft.com/en-us/excel/HP052091471033.aspx

isnumber

declare function excel-information:isnumber (
            $value as xs:anyAtomicType? 
 ) as xs:boolean

Tests if the passed $value is a number.

• $value the value.

• TRUE if $value refers to a number.

• http://office.microsoft.com/en-us/excel/HP052091471033.aspx

istext

declare function excel-information:istext (
            $value as xs:anyAtomicType? 
 ) as xs:boolean

Tests if the passed $value is a string.

• $value the value.

• TRUE if $value refers to text.

• http://office.microsoft.com/en-us/excel/HP052091471033.aspx

n

declare function excel-information:n (
            $value as xs:anyAtomicType? 
 ) as xs:anyAtomicType

Converts a $value to a number.

• $value the value.

• A $value converted to a number.

• http://office.microsoft.com/en-us/excel/HP052091871033.aspx

na

declare function excel-information:na (
 ) as xs:anyAtomicType

Raises the error value #N/A.

• The error value #N/A. #N/A is the error value that means "no value is available."

• excel-err:NA the purpose of this function is to raise this error

• http://office.microsoft.com/en-us/excel/HP052091881033.aspx