AnsweredAssumed Answered

vrf VEE data multiple columns in Excel

Question asked by VRFuser on Feb 17, 2005

Like • Show 0 Likes0
Comment • 3

<html><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 10 (filtered)"><style></style></head><body lang=EN-US link=blue vlink="#606420"><div class=Section1><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> Giovannae,</span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> Use For Loop to Index yourarray and put in Excel with same number for column and Index for row increment.</span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> For Code, look into the Helpfor example in Excel.</span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> Han</span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p><p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><spanstyle='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----
<b><span style='font-weight:bold'>From:</span></b> Giovonnae Anderson-McQuate[mailto:vonniea@clear-stream-technologies.com]
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, February 16, 200510:14 PM
<b><span style='font-weight:bold'>To:</span></b> VRF
<b><span style='font-weight:bold'>Subject:</span></b> [vrf] VEE data multiplecolumns in Excel</span></font></p><p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><spanstyle='font-size:12.0pt'> </span></font></p><div><p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><spanstyle='font-size:12.0pt'>Hi </span></font></p></div><div><p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><spanstyle='font-size:12.0pt'> Can anyone please tell me how to getmultiple 1D arrays into consecutive columns in Excel. I'm using VEE6.0 </span></font></p></div><div><p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><spanstyle='font-size:12.0pt'>and Excel 2000.</span></font></p></div><div><p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><spanstyle='font-size:12.0pt'> Thanks,</span></font></p></div><div><p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><spanstyle='font-size:12.0pt'> Giovonnae</span></font></p></div><p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><spanstyle='font-size:12.0pt'>--- You are currently subscribed to vrf as:tranh@tycoelectronics.com To subscribe send a blank email to"join-vrf@it.lists.it.agilent.com". To unsubscribe send a blank emailto "leave-vrf@it.lists.it.agilent.com". To send messages to thismailing list, email "vrf@agilent.com". If you need help with themailing list send a message to "owner-vrf@it.lists.it.agilent.com".</span></font></p></div>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list, email "vrf@agilent.com". <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></html>

No one else has this question

Outcomes

3 Replies

vonniea Feb 16, 2005 7:13 AM
Mark Correct
Correct Answer
<div>Hi </div>
<div>   Can anyone please tell me how to get multiple 1D arrays
into consecutive columns in Excel. I'm using VEE6.0 </div>
<div>and Excel 2000.</div>
<div>      Thanks,</div>
<div>
Giovonnae</div>

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
VRFuser Feb 16, 2005 9:18 AM
Mark Correct
Correct Answer
> Can anyone please tell me how to get multiple 1D arrays into
> consecutive columns in Excel.

Well there's one thing about columns: it's *way* easier to work with rows.
The attached shows some stuff about transferring data to Excel.

Naturally, you can activate one cell, write a value, offset to the next
cell, write a value... but that's a huge waste of time.

A better idea is to use transpose to swap rows and columns - either in VEE
or in Excel.
-SHAWN-

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
VRFuser Feb 16, 2005 9:26 AM
Mark Correct
Correct Answer
"Drago, William @NARDAEAST" <William.Drago@L-3com.com> wrote:
> Hi Shawn,
>
> It doesn't work in a user object or a function either--with the error pin on
> the object/function of course.
>
> So, can anyone suggest a way for me to test a var type? If it's a record, do
> x. If it's not a record, do y. That's what I was trying to do with the error
> pin.

Why not just use typeName(a) ?

Stan

--------------------------------------------------------------------------
Stan Bischof Agilent Technologies 707-577-3994 stan_bischof@agilent.com
--------------------------------------------------------------------------

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions

vrf VEE data multiple columns in Excel

Outcomes

Related Content

Recommended Content