Another Excel ActiveX Question

[George M. Callara]

I'm trying to save a 1D array to excel using ActiveX.

When I write 1 value to:

Worksheet Invoke Node -> Range/ Cell string wired to Cell 1
Range Property Node->Value / value wired to Value

It works great. However when I try to write a 1D array by:

Worksheet Inoke Node -> Range/ Beginning Cell string wired to Cell1 - Ending
Cell string wired to Cell2
Range Property Node ->Value/ 1D array wired to Value

What gets saved to excel is the value of the first element in the 1D array
throughout the entire range entered.

I'm using LabVIEW 5.1

Where oh where am I going wrong?

Thanks






-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==
Over 80,000 Newsgroups - 16 Different Servers! =-----

[dfbartel@my-deja.com]

I would recomend indexing the 1D array and writing the elements
individually to Excel.

In article <38ddabab_1@news5.newsfeeds.com>,
"George M. Callara" wrote:
> I'm trying to save a 1D array to excel using ActiveX.
>
> When I write 1 value to:
>
> Worksheet Invoke Node -> Range/ Cell string wired to Cell 1
> Range Property Node->Value / value wired to Value
>
> It works great. However when I try to write a 1D array by:
>
> Worksheet Inoke Node -> Range/ Beginning Cell string wired to Cell1 -
Ending
> Cell string wired to Cell2
> Range Property Node ->Value/ 1D array wired to Value
>
> What gets saved to excel is the value of the first element in the 1D
array
> throughout the entire range entered.
>
> I'm using LabVIEW 5.1
>
> Where oh wher
e am I going wrong?
>
> Thanks
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
>


Sent via Deja.com http://www.deja.com/
Before you buy.

[George M. Callara]

Thanks,
I am already doing that and it is slow. Wiring a 1D array is supposed to be
nearly instantaneous.

wrote in message news:8bnjq0$p9r$1@nnrp1.deja.com...
> I would recomend indexing the 1D array and writing the elements
> individually to Excel.
>
> In article <38ddabab_1@news5.newsfeeds.com>,
> "George M. Callara" wrote:
> > I'm trying to save a 1D array to excel using ActiveX.
> >
> > When I write 1 value to:
> >
> > Worksheet Invoke Node -> Range/ Cell string wired to Cell 1
> > Range Property Node->Value / value wired to Value
> >
> > It works great. However when I try to write a 1D array by:
> >
> > Worksheet Inoke Node -> Range/ Beginning Cell string wired to Cell1 -
> Ending
> > Cell string wired to
Cell2
> > Range Property Node ->Value/ 1D array wired to Value
> >
> > What gets saved to excel is the value of the first element in the 1D
> array
> > throughout the entire range entered.
> >
> > I'm using LabVIEW 5.1
> >
> > Where oh where am I going wrong?
> >
> > Thanks
> >
> > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----

[MaxMar]

You might try the alternative syntax for the Worksheet Invoke
Node->Range method. Instead of wiring a string to both the
Cell1 and Cell2 inputs, wire an A1-style range to Cell1 only.
For example, if you have a 25 element array, wire the string
A1:A25 to cell1. You can pop-up on the Range method to get the
online help for the syntax.

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

[George M. Callara]

Thanks,
I tried that and got the same results. The entire range was filled with the
value of the 1st element of the array.


"MaxMar" wrote in message
news:05265e58.ee335ca2@usw-ex0106-047.remarq.com...
> You might try the alternative syntax for the Worksheet Invoke
> Node->Range method. Instead of wiring a string to both the
> Cell1 and Cell2 inputs, wire an A1-style range to Cell1 only.
> For example, if you have a 25 element array, wire the string
> A1:A25 to cell1. You can pop-up on the Range method to get the
> online help for the syntax.
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>




-----= Posted
via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----

[MaxMar]

George:

I just went back and looked at some of my vi's (which I should
have done in the first place). Build your 1D array into a 2D
array and pass that to the Value property node. If you want
columns, transpose the array before passing it. Sorry about the
earlier non-solution.

MaxMar

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!