Write table to spreadsheet with headers (updated)

[DavidT]

Hello all,
I am having problems writing a table with column and row headers to a spreasheet. At the moment, I am only intersted in writing to a txt file.
I can only manage to write the data but the headers are not writing.
I managed to do this already but I lost the VI and havent been able to do it since.
I think you can do it by using multiple "write to spreadsheet" VI's but im sure there is a quicker way to write the entire table.
I have attached the test Vi im using.



thanks in advance.

[ChristerLj]

Attached is a file that shows you a couple of options for writting data to file. I included an option to write the data to a table, but I didn't complete the task of taking the data (incl. headers) and writing to file. The key thing to remeber with tables is that the headers are not part of the dataset so you will have to use the property node of a table to extract this information (and write it as well). To creat the property node you simply right click on the table indicator from teh block diagram and select 'Create >> Property Node'. If you want to then add this data to the dataset you have to do it in the same fashion that I did in the write to file with headers data flow. Just don't forget that you need to add aempty element for the first row and f
irst column. Otherwise either the columns or rows will have an offset in the header. Hopefully the program makes more sense.

-Christer