cellecting and saving data into excel or CSV file spreadsheet

[RavensFan]

The minus 50 and times 2 serve no purpose either as those calculations go nowhere.  You should put a wait statement inside your while loop so that the CPU doesn't run full speed polling those controls.

[Hueter]

...had some extra time today so i fixed up your code and added some new features.

Message Edited by Hueter on 07-24-2009 02:25 PM

[alams]

Dear Hueter,

Thank you so much for your great work! your program is lot more efficient than mine. I have made some slight changes in your program just for my work purpose. I just have one more question: is there any way I can use LabVIEW to put Smell 1, smell 2, smell 3, smell 4, smell 5 in one row and the numbers acquired in the second row. I have added True constant to put the data in a row in the exl sheet. However, all the smell numbers and data are in one row instead of two. I have dragged the acquired numbers to the the second row. therefore the variable coresponding to the smell are side by side. I was wondering if LabVIEW can automatically send the smell types in one row, and the numbers in the other. If you just run the attached VI and see the collected data in the exl spreadsheet,  i think you will be more clear what I want to know.

Thanks,

Samia  

[Dennis_Knutson]

By adding the True constant to the transpose input, you changed the example that was posted. The example that was posted placed the smell names in one row and the values in another row. Undo your changes.

[Hueter · Accepted solution]

Check it out...

[alams]

Sorry, I meant putting the smell numbers in one COLUMN, and the variables in anothe COLUMN.

having them in two rows is pretty messy and there is a higher chance of making mistake while analyzing.  

[alams]

THANK YOU EVERYONE FOR ALL THE HELP!

~Samia

[Aneece]

if you to put the header in one raw and the reading in the other raw, you simply change the comma delimiter to the default tab (/t), just leave the delimiter unwired you will have 5 headers in the cells A1,B1,C1,D1,...so on, and the reading will be in A2,B2,C2,....so on.

i hope this will help

regards

Aneece

[eleorka]

Hi everyone,

Could you please let me know if there is a way to collect 1D data into specific column of a spreadsheet (CSV file)? I would like it to appear not on the first column but on the 2nd or 3rd?

Thanking everyone in advance

[GerdW]

Hi eleorka,

as CSV is just a textfile (with some fancy data separation) you have to include those empty columns before your own data...