Write header and mixed data to spreadsheet

[jcannon]

Hi everyone,

I am having some problems writing my data to a spreadsheet file... Basically, I have crunched my data and obtained the values I want... When I stop the the loop I want the data to be saved to a spreadheet file... The first line should be a header, and the lines below should be the corresponding data consisting of a string and numerical data... See example below.

Subject Name, Max Force (N), Mean Force (N), Min Force (N);
David, 2134, 23, 284;
Phil, 1234, 43, 321;
Tina, 4059, 335, 55;

Can anyone please help with this?

Kind regards,

Jack

[smercurio_fc]

Since you are writing everything at the end, convert your array of data to string, and then prepend your row of headers.

[apok · Accepted solution]

this will create a file(test.csv), checks if file exists(no: creates header plus data...if yes:appends data only):save vi to a folder first...test.csv will be saved in that folder also.

[jcannon]

Hi apok,

Thanks heaps for this... Works a treat!

I made a couple of changes... See attached anyone interested...

Kind regards,

Jack