LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Column headers in data files

I have been saving to file columns of numeric data using the write to spreadsheet
vi.
I would like to put column descriptors (lables) at the top of each column
so that others who open the data files know what each column is for.
How is this done?
0 Kudos
Message 1 of 4
(3,165 Views)
First of all, open "write to spreadsheet file" VI. Save a
copy as "write string spreadsheet file" and open its block
diagram. Follow the instructions in there to change the
numeric input to a string input, and from there, use first
this modified VI to write string headers and then append
data as numerics in the same file.
Hope this helps

Gorka Larrea
glarrea_1@hotmail.com


* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
0 Kudos
Message 2 of 4
(3,165 Views)
Pblue wrote:
>
> I have been saving to file columns of numeric data using the write to spreadsheet
> vi.
> I would like to put column descriptors (lables) at the top of each column
> so that others who open the data files know what each column is for.
> How is this done?

Here is 2 alternatives:


1. Use Array To Spreadsheet string function to convert the array to string,
make a string containing the header and concat ( Concatenate Strings )
them , and write the result string to a file.

2. Write the header string to a file, then write the data with write to
spreadsheet file vi. connect "append to file" input to true constant to
make the vi append the data rather than owerwrite.



Timo

--
-------------------------------------------------
Timo Miettunen


Fincitec Oy Production Department
e-mail: timo.miettunen@fincitec.fi
Address:
Lumikontie 2 Tel: +358-16-2151245
PO BOX 11 Fax: +358-16-221561
FIN-94600 KEMI Finland
-------------------------------------------------
0 Kudos
Message 3 of 4
(3,165 Views)
Try the following. The file will be stored in *.DAT form. Open the saved file in Origin (or Wordpad).
Download All
0 Kudos
Message 4 of 4
(3,165 Views)