Spreadsheet String To Array Function

LabVIEW 2018 Help

Edition Date: March 2018
Part Number: 371361R-01
View Product Info

DOWNLOAD (Windows Only)

LabVIEW 2016 Help
LabVIEW 2017 Help
LabVIEW 2018 Help
LabVIEW 2019 Help
LabVIEW 2020 Help

Owning Palette: String Functions

Requires: Base Development System

Converts the spreadsheet string to an array of the dimension and representation of array type. This function works for arrays of strings and arrays of numbers.

The connector pane displays the default data types for this polymorphic function.


delimiter specifies the value or values used to separate fields in the spreadsheet file. The default is a single tab character. You can specify multiple delimiters by wiring an array of strings to delimiter. Each element of the array should contain a different delimiter. For example, if you wire an array that contains two elements — a space character in one and a tab character in the other — the function allows either a space character or a tab character to separate elements in the output array.
format string specifies how to convert the spreadsheet string into an array. Use %s to convert spreadsheet string to an array of strings. Use %d or %f to convert spreadsheet string to an array of numbers. Use the format string syntax.
spreadsheet string contains numeric or string values separated into columns by delimiters, such as tabs or commas, with an end-of-line (EOL) character separating rows. The function converts each element in spreadsheet string according to format string and stores the resulting values in array.
array type is the data type input for the array. The default is a 2D array of double-precision, floating-point numbers. Refer to Array To Spreadsheet String for information about the spreadsheet format expected for arrays of three dimensions or more.
array is spreadsheet string converted to an array of the dimension and representation of array type.


Refer to the Tab-Delimited Data.lvproj in the labview\examples\File IO\Spreadsheet\Tab-Delimited Data directory for an example of using the Spreadsheet String To Array function.


Not Helpful