FieldPoint Family

cancel
Showing results for 
Search instead for 
Did you mean: 

I can't get data to appear where I need it in a excell spreed sheet. "again?!?!"

I've attached my VI and an Excel file that shows the results that are returned with the attached VI. The problem is that the data called (0PTthrottleMAX, 0PTthrottleMIN, 1STBthrottleMAX, 1STBthrottleMIN) does not fall into the column I want it to. I've tried every thing I know but to no avail. If I can get it to fall into the columns then I can get rid of the "Line Feed" so there is on empty lines between the data.

I did notice that if I re-aranged the way the data went into the "Concatenated String"(inside the loop) that I could get all the data to fall into there assigned catagory. But I had to first change the location of the headers mentioned above with (0TemperatureZone1, 1TemperatureZone2, 2PTtroll, 4STBtroll). This was done because when I traded the above strings (0PTthrottleMAX, 0PTthrottleMIN, 1STBthrottleMAX, 1STBthrottleMIN) with (0TemperatureZone1, 1TemperatureZone2, 2PTtroll,4STBtroll) at the point they enter the second "Concatenated String inside the loop" the data actually fell into the right column but the header to the column was wrong. Thats why I had to rearange the headers going into the first "Concatenated String" outisde the loop.

Now I've also attacted the VI after I arranged all the headers and strings to make the data fall into the assigned columns. I just want to know how I could have done this without re-aranging all the headers and strings. The VI that was not working is call WrongVI and its associted excel file to show how the data comes out is called Wrong.xls the other is rightVI and its data file is right.xls. Again in this file everything is in its assigned column but you can see that I had to rearange the headers and the way they enter the "concatenated String Vis" as mentioned above.

Thanks again
still learning...

P.S I can only attache three files so I combined the excell file called combined. I made it so you can tell how each VI out puts it data.

P.S. I tried to attach the files but it seems that National Instruments is having system problems and it wouldn't allow any atttachments I keep getting Errors I did e-mail the notification of these errors.

If there is someone I can e-mail the files to just let me know.

thanks again.
0 Kudos
Message 1 of 3
(3,162 Views)
Marine,

You would probably have better luck posting that question in the LabVIEW section...

Regards,

Cyril Bouton
Applications Engineer
National Instruments
Cyril Bouton
Active LabVIEW Developper
0 Kudos
Message 2 of 3
(3,162 Views)
OK thank You..
0 Kudos
Message 3 of 3
(3,162 Views)