# VRf Vee to Excel problems

Question asked by VRFuser on Mar 18, 1996

You also can use Formula and For Count
to describe proper cell, which is Item in DDE object.

+---------+     +------------+      +-------------------------+
|For Count+--+  |  Fromula   |      |    To/From DDE          |
+---------+  |  |------------|      |-------------------------|
+--+ "R1C"+(A+1)+------+ WRITE ITEM:a TEXT b EOL |
|  +------------+      |                         |
+--------+          +--+                         |
|          |  |                         |
+-----+------+   |  +-------------------------+
| Measurement+---+
+------------+

- here, "Measurement" is the measurement routine like UserObject,
"b" in To/From DDE is the measured value.

Good Luck.

Ikuyo Tokunaga
Hewlett-Packard Japan Ltd.
------------------------------------------------------------------------------
From: "andrew" <andrew@charybdis.microunity.com>
Subject: RE: VRf  Vee to Excel problems
To: hpvxd_xc@hpislsup.lvld.hp.com, "Peter M. Andersson" <ei2petan@ite.his.se>
Status: RO

Have you tried collecting all of your data and then formatting the results
into an array in Vee?  Then use a "To File" block to write the result array
to a single file.  Under the "To File" PROPERTIES submenu, set the EOL
sequence to "
" and the array separator to "     " (tab).  EXCEL can then
easily read this file format.  Each element in the array will end up in a
different cell.  You can format the Vee array to suit your needs.

Hope this helps

Andrew Rhind
MicroUnity Systems Engineering
_______________________________________________________________________________
From: Peter M. Andersson on Tue, Mar 12, 1996 6:47 AM
Subject: VRf  Vee to Excel problems
To: hpvxd_xc@hpislsup.lvld.hp.com

Hi
We're having trouble getting our measured values into an excel sheet.
We want to get our results into excel after every measurement in
different columns, but excel writes over the previous value in the
first cell.
We've tried to put different escape characters in the EOL box but
none will work. If we put \ in the EOL box for an example excel will write a
""
after our value, but       will not work.

regards

Peter & Ola

Regementsgatan 4          E-Mail@work: ei2petan@ite.his.se
S-541 46 Skoevde           Phone@home : +46(0)500489884
Sweden                    http://www.his.se/ite/~ei2petan/

--
o~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~o
((    Ikuyo Tokunaga           TMO Customer Training Center                 ))
)                             Hewlett-Packard Japan, Ltd.                  (
o~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~o