LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

reading from spread sheet vi

Dear All,
I am trying to read this text file saved in ASCII but it does not load the data correctly, I saved this file in matlab using the command "save moonman y -ascii -double -tabs". then i used read from spread sheet.vi to open it, i want to see the data in waveform chart. I attached the waveform chart both with all rows and first row? and used double...can any one help.
thank you.
0 Kudos
Message 1 of 8
(4,563 Views)
I think the attached will do what you want.  It reads in your file, decodes the tab delimited string, and plots in a waveform chart.

Paul
Message 2 of 8
(4,553 Views)
Dear Paul Schlagheck,
thank you for the wonderful program but in the waveform chart, the waveform that is saved shows up distrorted.
Could you maybe tell why this is ?
sincerely,
Munir.
0 Kudos
Message 3 of 8
(4,532 Views)
Glad to try and help.  Distorted?  Could you please clarify that?

Paul
0 Kudos
Message 4 of 8
(4,526 Views)

hi Paul, i have attached a screen shot, and also the file, the pic. shows how the waveform looks like.

thanks in advance.

0 Kudos
Message 5 of 8
(4,502 Views)
Interesting... That is the same plot I got based on the file you posted me.  Not sure why you would not have gotten the same out of the box with my example.  Interesting.  did you modify the code I sent you?  I downloaded your file, and my example... and I have attached the result.

Paul
0 Kudos
Message 6 of 8
(4,493 Views)

Hello,

the problem is the decimal-character. If you change all the dots to commas in your text-file, it will work. Or you change the setting of your LabView Program under options -> frontpanel -> local decimal-character

Hope this helps,

                                    Magnus

 

0 Kudos
Message 7 of 8
(4,483 Views)
Good catch... I do not deal with localization often. 
Thanks

Paul
0 Kudos
Message 8 of 8
(4,471 Views)