Table Of Contents

Write to Spreadsheet File (String) (G Dataflow)

Last Modified: January 9, 2017

Converts a 1D or 2D array of string 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.

connector_pane_image
datatype_icon

format

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
  • %d — converts the data to integer form using as many characters as necessary to contain the entire number

Default: %s — copies the input string

datatype_icon

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.

datatype_icon

2D data

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

datatype_icon

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.

datatype_icon

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

datatype_icon

transpose?

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

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

Default: False

datatype_icon

delimiter

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

datatype_icon

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