SoftArtisans ExcelWriter Guide

All Functions Math Functions String Functions Logical Functions
Time Functions Statistical Functions Information Functions
Lookup & Reference Functions Database Functions Financial Functions

Information Functions

The only functions available in
ExcelWriterSE and ExcelWriterLE
are sum and average.

iserr*
iserror*
isnumber*
type*

String Functions

iserr*

Checks the type of value and returns True if it is any error value except #N/A, and False if it is not.

iserror*

Checks the type of value and returns True if it is any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and False if it is not.

isnumber*

Checks the type of a value and returns True if it is a number, and False if it is not. For example, isnumber(18) returns True, and isnumber("Sunday") returns False. If the value in b7 is 12, the following will display "True" in cell b8.

	ws.Cells("b8").Formula = "=isnumber(b7)"

type*

Returns the type of value. Use type when the behavior of another function depends on the type of value in a particular cell. Type takes one argument, value, which can be any Microsoft Excel value, such as a number, text, or a logical value.

If value is	Type returns
`Number`	`1`
`Text`	`2`
`Logical Value`	`4`
`Error Value`	`16`
`Array`	`64`

*This function is not available in ExcelWriterSE, ExcelWriterLE, or ExcelWriterFree. The only functions available in ExcelWriterSE, ExcelWriterLE, and ExcelWriterFree are sum and average.