Table Of Contents

Write to Spreadsheet File (Integer) (G Dataflow)

    Last Modified: January 9, 2017

    Converts a 1D or 2D array of integer values to a text string and writes the string to a file.

    This node creates a text file readable by most spreadsheet applications. This node opens or creates the file before writing to it and closes it afterwards.



    A string that uses format specifiers to determine how to convert the data to characters. Examples:

    • %3f — creates a string to represent the number with three digits to the right of the decimal point
    • %s — copies the input string

    Default: %d — converts the data to integer form using as many characters as necessary to contain the entire number


    file path

    The file that this node writes to. The node opens the specified file without requiring you to call Open/Create/Replace File first.

    Default: No value — Displays a file dialog box that prompts you to select a file.


    2D data

    Data the node writes to the file if 1D data is not wired or is empty.


    1D data

    Data the node writes to the file if this input is not empty. The node converts the 1D array into a 2D array before proceeding.

    If transpose? is False, each call to this node creates a new line or row in the file.


    append to file?

    A Boolean that determines whether to add data to the end of the file. If you do not specify a file, the node creates a new file.

    True Appends data to the existing file.
    False Replaces the data in the file.

    Default: False



    A Boolean value that determines whether to transpose the data before conversion.

    True Transposes the data.
    False Does not transpose the data.

    Default: False



    A character or string of characters used to separate fields in the spreadsheet text. For example, a value of , (comma) specifies a single comma as the delimiter.

    Default: \t — single tab character


    new file path

    Path to the file.

    Where This Node Can Run:

    Desktop OS: Windows

    FPGA: All devices (only within an Optimized FPGA VI)

    Recently Viewed Topics