StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Follow these steps from NI: <a href="http://digital.ni.com/public.nsf/allkb/99F61B6AB9CD6AFA8625734600814D6B" rel="nofollow">Reading Microsoft Excel Numeric Data Into LabVIEW</a>. Quoting the link:</p> <blockquote> <p><strong>Use the Read From Measurement File Express VI:</strong> </p> <p>You may read numeric data in an Excel spreadsheet into LabVIEW using the Read From Measurement File Express VI through a two step process. First, save your Excel spreadsheet as a tab delimited text file. Then, rename the *.txt file as a *.lvm file. The Read From Measurement File Express VI can now read the numeric data into LabVIEW. The following steps will walk you through the procedure.</p> <ol> <li>Open your Excel spreadsheet containing simple numeric information.</li> <li>Save your Excel spreadsheet as a tab delimited text file.</li> <li>Click OK. Note that you are only saving numeric data from the active worksheet.</li> <li>Click Yes.</li> <li>Close your Microsoft Excel document.</li> <li>Navigate to the location where you saved your Excel document as a tab delimited text file, right-click on your filename.txt document, select Rename, and rename you file with a .lvm extension so that your file now appears as filename.lvm.</li> <li>Read your numeric spreadsheet data into LabVIEW by specifying filename.lvm as the File Name in the Read From Measurement File Express VI configuration window. </li> </ol> <p>Navigate to the location where you saved your Excel document as a tab delimited text file, right-click on your filename.txt document, select Rename, and rename you file with a .lvm extension so that your file now appears as filename.lvm.</p> <p><strong>Use the Read From Spreadsheet File VI:</strong></p> <p>The LabVIEW VI 'Read From Spreadsheet File.VI' does not directly read .xls files, but rather delimited text files.</p> <p>If you created your Excel spreadsheet by manually entering the data in (not using LabVIEW and the Write to Spreadsheet File VI) the Read From Spreadsheet File VI will not properly interpret your .xls file and will return zeros into your array. In order to get this data into an array in LabVIEW you will have to save the Excel file as a tab delimited text file. The procedure for this can be seen in the example above. Now inputting this new .txt file into the file path node of the Read From Spreadsheet File VI will populate your array with the proper data. If you just need the first column of data, you can wire a True constant to the Transpose? node, and the First Row output will give you an array with the values of your first column of data.</p> </blockquote>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload