http://zorba.io/modules/excel/information

View as XML or JSON.

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

Function Summary

is-blank ($value as xs:anyAtomicType?) as xs:boolean

Test if the passed argument is empty of not.

is-even ($value as xs:anyAtomicType?) as xs:boolean

Test is a number is even.

is-odd ($value as xs:anyAtomicType?) as xs:boolean

Test is a number is odd.

islogical ($value as xs:anyAtomicType?) as xs:boolean

Tests if the passed $value is a logical value.

isnumber ($value as xs:anyAtomicType?) as xs:boolean

Tests if the passed $value is a number.

istext ($value as xs:anyAtomicType?) as xs:boolean

Tests if the passed $value is a string.

n ($value as xs:anyAtomicType?) as xs:anyAtomicType

Converts a $value to a number.

na () as xs:anyAtomicType

Raises the error value #N/A.

Functions

is-blank#1

declare  function excel-information:is-blank($value as xs:anyAtomicType?) as xs:boolean
Test if the passed argument is empty of not.

Parameters

value as xs:anyAtomicType
the value.

Returns

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

is-even#1

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

Parameters

value as xs:anyAtomicType
the value.

Returns

xs:boolean
TRUE if number is even, FALSE if number is odd.

is-odd#1

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

Parameters

value as xs:anyAtomicType
the value.

Returns

xs:boolean
TRUE if number is odd, FALSE if number is even.

islogical#1

declare  function excel-information:islogical($value as xs:anyAtomicType?) as xs:boolean
Tests if the passed $value is a logical value.

Parameters

value as xs:anyAtomicType
the value.

Returns

xs:boolean
TRUE if $value refers to a logical value.

isnumber#1

declare  function excel-information:isnumber($value as xs:anyAtomicType?) as xs:boolean
Tests if the passed $value is a number.

Parameters

value as xs:anyAtomicType
the value.

Returns

xs:boolean
TRUE if $value refers to a number.

istext#1

declare  function excel-information:istext($value as xs:anyAtomicType?) as xs:boolean
Tests if the passed $value is a string.

Parameters

value as xs:anyAtomicType
the value.

Returns

xs:boolean
TRUE if $value refers to text.

n#1

declare  function excel-information:n($value as xs:anyAtomicType?) as xs:anyAtomicType
Converts a $value to a number.

Parameters

value as xs:anyAtomicType
the value.

Returns

xs:anyAtomicType
A $value converted to a number.

na#0

declare  function excel-information:na() as xs:anyAtomicType
Raises the error value #N/A.

Parameters

Returns

xs:anyAtomicType
The error value #N/A. #N/A is the error value that means "no value is available."