Read From Spreadsheet File

Reads a specified number of lines or rows from a numeric text file beginning at a specified character offset and converts the data to a 2D, single-precision array of numbers. You optionally can transpose the array. The VI opens the file before reading from it and closes it afterwards. You can use this VI to read a spreadsheet file saved in text format. This VI calls the Spreadsheet String to Array function to convert the data.

format specifies how to convert the numbers to characters. If the format is %.3f (default), the VI creates a string long enough to contain the number, with three digits to the right of the decimal point. If format is %d, the VI converts the data to integer form using as many characters as necessary to contain the entire number. Use the format string syntax.
file path is the path name of the file. If file path is empty (default) or is Not A Path, the VI displays a dialog box from which you can select a file. Error 43 occurs if you cancel the dialog box.
number of rows is the maximum number of rows or lines the VI reads. For this VI, a row is a character string ending with a carriage return, line feed, or a carriage return followed by a line feed; a string ending at the end of file; or a string that has the maximum line length specified by the max characters per row input. If number of rows is <0, the VI reads the entire file. The default is –1.
start of read offset is the position in the file, measured in characters (or bytes), at which the VI begins reading. The offset unit is bytes rather than numbers because byte stream files can contain segments of different types of data. Therefore, to read an array of 100 numbers that follows a header of 57 characters, set start of read offset to 57.
max characters/row is the maximum number of characters the VI reads before ending the search for the end of a row or line. The default is 0, which means that there is no limit to the number of characters the VI reads.
If transpose is TRUE, the VI transposes the data after converting it from a string. The default is FALSE.
delimiter is the character or string of characters, such as tabs, commas, and so on, to use to delimit fields in the spreadsheet file. The default is a single tab character.
new file path returns the path to the waveform file.
all rows is the data read from the file.
first row is the first row of the all rows array. You can use this output when you want to read one row into a 1D array.
mark after read is the location of the file mark after the read. It points to the character (byte) in the file following the last character read.
EOF? is TRUE if you attempt to read past the end of file.