06-06-2017 09:53 AM
HI
I have a dataset in Matlab as shown in attachment. I am trying to open the data using read delimited spreadsheet vi but the output read 9 plots with sample length 34534.
Can anyone tell me what am I doing wrong
P.S both files are available in attatchments
Solved! Go to Solution.
06-06-2017 01:59 PM
@naseera wrote:
HI
I have a dataset in Matlab as shown in attachment. I am trying to open the data using read delimited spreadsheet vi but the output read 9 plots with sample length 34534.
Can anyone tell me what am I doing wrong
P.S both files are available in attatchments
Sure. Your file is an excel spreadsheet, not a delimited file. Either have the data saved as a delimited file or use ActiveX to read it.
06-06-2017 05:18 PM
How to convert data as delimited file. I had also attached the .mat file if is useful
06-06-2017 06:04 PM
Bundle of thanks for the reply
Okay I saved the file as delimited text and then run through the Labview file I get an output where values sometime reaches amplitude of 6 while if I plot the same parameters using orignal matlab my output alway lies within -4 to +4 range.
What might be the reason for the change in parameters
06-06-2017 08:03 PM - edited 06-06-2017 08:05 PM
I used Excel to save as a CSV (I think you already did this) then changed the datatype to double (your numbers have decimal places). It now reads properly.
If you only want to display integer values, round the output of the Read Delimited Spreadsheet function using a numeric conversion function like Round to Nearest or just To I32.