Writing Data to a Spread Sheet With Formatting (Titles)

[Warren]

This is kind of a minor detail, but I'm going to be distributing the results of my data (and there's alot) and I was wondering if there was a way to include descriptive titles for each column of data I'm importing to excel (for example). I've been "Writing to Spreadsheet" a 2D array with all my data and I want to title each column. I've been messing with combining separate arrays of type double and type string (titles) in a cluster, but the "write to Spreadsheet" doesn't like that. If anyone has any suggestions it would be greatly appreaciated.

Regards, - Warren.

[jdunham]

QUOTE (Warren @ May 21 2009, 02:05 PM)

This is kind of a minor detail, but I'm going to be distributing the results of my data (and there's alot) and I was wondering if there was a way to include descriptive titles for each column of data I'm importing to excel (for example). I've been "Writing to Spreadsheet" a 2D array with all my data and I want to title each column. I've been messing with combining separate arrays of type double and type string (titles) in a cluster, but the "write to Spreadsheet" doesn't like that. If anyone has any suggestions it would be greatly appreaciated.

There isn't a one-stop solution for writing a great spreadsheet file. You have to just write your sections in separate chunks. Here is a simple example:

http://lavag.org/old_files/monthly_05_2009/post-1764-1242946205.png' target="_blank">

[ShaunR]

You can also write headers and footers in one hit.

[PaulG.]

For all the data I want to save I make a cluster. On the Init state I write the cluster labels to the file from that cluster via properties > label text. Those are my column headers. Then when I run my VI and save the data it's parsed into the proper column.

[Warren]

Thanks for the help everyone! - I got it working and I think its going to make organizing everything really nice.

- Warren.