write to excel

[fgarcia]

Hi!

I need to modify the Vi in attachment (taken from http://zone.ni.com/devzone/cda/epd/p/id/4523) in order to write  "Array2", "Array3" and "Array" in different excel sheets of the same excel file.  "Array" is composed by strings and the other arrays are numeric.

May you please help me?

[GGT]

Hi fgracia,

Well, I'm very new to ActiveX so you take your project in your hands listening to me! That said, I've been dragged by the scruff of my neck to get some ActiveX Excel stuff working very quickly so I've been forced onto a steep learning curve. Don't know if the attachments are any good to you but you might be able to modify them. The first is my Excel writer, only writes to Worksheet1 but some looping and data manipulation might get it doing what you want. Your cell converter VI is very poor and fails early. I attach my version, which should work ad infinitum (although Excel columns only go as far as XFD, as I understand them). That said, if you see my main attachment, a conversion node is available. Hope this helps.

GGT

[fgarcia]

Hi GGT.  Thnak you very much, but I forgot to say that I have Labview 8.0, then I can not see your files.  Would it be possible to post an image of the code?

Thank you very much!

Message Edited by fgarcia on 02-22-2010 07:14 PM

[Guruthilak]

here you go...

[Guruthilak]

and as a quick solution you have to repeat that nested for loop 3 times to write the array arrray2 and array 3 values.

Dont forget to point the reference to new worksheet between these for loops so that you write different arrays in defferent sheets. (actually since the data type of the 2 arrays are same i.e 2D of double, 2 sets of nested for loops will serve for you.)

[fgarcia]

Thank you!

I will try it and let you know.