04-08-2014 01:15 PM
Hi,
I would like to read multiple csv files from excel to labview, creating a duplicate of the tables in excel, which would allow me to then draw some graphs for data analysis and comparison between the two.
Are there any examples that could be useful to what I am trying to do?
Thanks
04-08-2014 01:33 PM
If the files are really csv format, simply read them using "read from spreadsheet file", and wire a comma as delimiter.
04-08-2014 04:41 PM
That worked great, thanks.
From one of the csv files, I only require 3 of the columns. Is there a way to only read that part of the csv file?
04-08-2014 05:06 PM - edited 04-08-2014 05:06 PM
Patel33 wrote:From one of the csv files, I only require 3 of the columns. Is there a way to only read that part of the csv file?
No. The characters in a file are just one long string and delimiters and linefeeds are special characters that defined where fields and lines start and end. As such, columns are interlaced into the file and consists of many small sections, where the position depends on the number of characters in each field, which is typically variable. You really need to read the entire file, then only look at the interesting columns later.
04-08-2014 05:14 PM
Ok. How do I add a graph, and only pull the three columns of data that is needed for it?
Thanks
04-08-2014 05:21 PM
You can use "array subset" to get a subset of adjacent columns. If the desired columns are not adjacent, use e.g. undex array to get the desired columns.
04-09-2014 01:54 PM
I have another question.
Iv'e decided to use tab control, I have the data in the first tab and would like to have the graph displayed in the second tab. Would the array subset and undex array still work for this? Or would I have to use a different function?
Thanks
04-09-2014 01:54 PM
I have another question.
Iv'e decided to use tab control, I have the data in the first tab and would like to have the graph displayed in the second tab. Would the array subset and undex array still work for this? Or would I have to use a different function?
Thanks
04-09-2014 02:09 PM
The Tab Control is just a front panel container. It has no bearing on what functions you use in your block diagram.
04-10-2014 09:32 AM
Hi,
I have a read from spreadsheet for two different files each connected to an index array to grab a column from each table. These are wired to the xy inputs of the graph, but im not getting a plot on the graph. Any ideas on how to solve this?
Thanks