column names/headers for arrays in Excel

[sacsk123]

I have 10 arrays of numbers which are saved to 10 columns in Excel file using "Write To Measurement File".

Now i want to give names to the columns means Headers. How can i?

Yes i tried "Set Dynamic Data Attributes" but with this i can add only 1 column name at a time. so i have to use 10 blocks for 10 columns? This is not a good idea.

so help me to give names for all 10 columns in easy way.

[ingram.weeks · Accepted solution]

sacsk123

You can call the "Write to Spreadsheet File.vi" and write an array of strings corresponding to your desired headers.

Once you have created your headers, you can then append your measurement data to the file.

I hope this helps,

Ingram

[sacsk123]

this works but i like the "write to measurement" and directly write into excel file. ok thats fine.

now i have few arrays of elements coming out of for loop. i want to save them in single ROW in excel with headers. How can i do this?

means i get array of 4 numbers.save them to 1 ROW but with column names.

[dhans · Accepted solution]

Hi, 

did you try this method? If not, try it as in an attached image.