Spread.NET 17 Formula Reference
Formula Functions / Functions T to Z / TOCOL
In This Topic
    TOCOL
    In This Topic

    This function returns the array in a single column.

    Syntax

    =TOCOL(array, [ignore], [scan_by_column])

    Arguments

    The function has the following arguments:

    Argument

    Description

    array

    		 The array or reference to return as a column.
    ignore

    [Optional] Whether to ignore certain types of values. By default, no values are ignored.Specify one of the following:

    • 0   Keep all values (default)

    • 1    Ignore blanks

    • 2    Ignore errors

    • 3    Ignore blanks and errors
    scan_by_column

    [Optional] Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column.

    Data Types

    The function returns an array, the type of each value in the array depends on the parameter.

    Examples

    Version Available

    This function is available in product version 16.0 or later.

    Note: The TOCOL function is only available in Beta Insiders builds of Excel for Office 365 currently. Hence, without the Beta Insiders build you cannot import/export the XLSX using this function from/to Excel.