LabVIEW Idea Exchange

cancel
Showing results for 
Search instead for 
Did you mean: 
dfunk

Intelligent copy of data from Excel spread sheet to VI

Status: New

I run into many situations where data is collected and stored in an Excel spread sheet.   Moving this data into LabVIEW usually requires writing some code to either process the data after it has been saved into a .csv format or pasting the data as a single string and then parsing it in LabVIEW to get it into a usable format.

 

Usually, the data is in two or more columns where one column is an X axis and other columns are Y axis data points.  My life would be made better if I could select all of the data I want in Excel, copy it, and then paste it into LabVIEW as an XY array cluster.

 

Good Implementation: I can only select two columns.  The first (left most) column is always X axis points and the second Y axis points.

 

Better Implementation: I can select multiple columns of data and would be asked by LabVIEW which column to use as the X axis and all others are treated as Y axis data points.  This would paste into LabVIEW as an array of XY array clusters.

 

Best Implementation: In addition to the better implementation, I can also include the column title in my selection and LabVIEW will use it to name the data series, just like Excel does when you create a scatter plot.

 

excel paste.jpg