AnsweredAssumed Answered

Help passing array variable to Excel via ActiveX

Question asked by dgoderich on Sep 12, 2013
Latest reply on Oct 9, 2013 by dgoderich

Like • Show 0 Likes0
Comment • 2

Hi Folks,
I am trying to pass an array variable of 601 points to an Excel sheet via ActiveX/formula object. I have tried the following code below but what it does is it places the first item of the array in all 601 cells.

The Excel sheet name is "TRACE DATA", the variable which is an array of 601 real numbers is in the array variable TRACEDATA_8563

Here is the code in the formula object:

ExcelApp.Sheets("TRACE DATA").Range("B1:B601").Value=TRACEDATA_8563;

Any suggestions will be appreciated.

Thanks
Damian.
dgoderich@gmail.com

No one else has this question

Outcomes

dBdetlef Sep 20, 2013 7:12 AM

I do not see any code attached, anyhow, you should just use one cell, and if you put an array in this cell, excel will enhance it atomatically.
You can choose if your data should go vertical or horizontal before. Do you use ecxel lib for this? or in other words, what vee version are you using? 9.31 ?

detlef

Actions

dgoderich Oct 9, 2013 11:56 AM

Answered my own question:

1st *Declare variable* Amp_range

Name Amp_range:
Scope:GLOBAL
Type: Object
Sub Type:Any

TRACEDATA_8563 Being the variable array holding 601 points from Spectrum Analyzer.
A: being variable holding the range of cells

*INSIDE FORMULA BOX (ActiveX)*SET Amp_range = excelApplication.Sheets("TRACE DATA").Range(A);
Amp_range = transpose ([TRACEDATA_8563 ])

If this is not clear to anyone with a similiar question, I can post a VEE File with all the Code.

Damian.

Actions

2 Replies

dBdetlef Sep 20, 2013 7:12 AM
Mark Correct
Correct Answer
I do not see any code attached, anyhow, you should just use one cell, and if you put an array in this cell, excel will enhance it atomatically.
You can choose if your data should go vertical or horizontal before. Do you use ecxel lib for this? or in other words, what vee version are you using? 9.31 ?

detlef
Like • Show 0 Likes0
Actions
dgoderich Oct 9, 2013 11:56 AM
Mark Correct
Correct Answer
Answered my own question:

1st *Declare variable* Amp_range

Name Amp_range:
Scope:GLOBAL
Type: Object
Sub Type:Any

TRACEDATA_8563 Being the variable array holding 601 points from Spectrum Analyzer.
A: being variable holding the range of cells

*INSIDE FORMULA BOX (ActiveX)*SET Amp_range = excelApplication.Sheets("TRACE DATA").Range(A);
Amp_range = transpose ([TRACEDATA_8563 ])

If this is not clear to anyone with a similiar question, I can post a VEE File with all the Code.

Damian.
Like • Show 0 Likes0
Actions

Help passing array variable to Excel via ActiveX

Outcomes

Related Content

Recommended Content