LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to write a single Value to an excel spreadsheet

Solved!
Go to solution

Hi,

   I am using an excel spreadsheet as if it were an external code module. It does lots of calculations, all I have to do is write a sigle value to it, let it calculate what it needs to then read single a value back from it.

I already have a structure that can read back an array, but could someone help me with a peice of code that could write a single value?

(Maybe to read a single value too would be handy)

 

Also, I have the new LabVIEW 2009, so if any one fancy's dropping a bit of code here as a .PNG, it would be nice to see if that new feature works! 🙂

 

Many thanks, Alec

0 Kudos
Message 1 of 4
(3,208 Views)

A little searching of the forums could find that answer.

 

Here is one link.  http://forums.ni.com/ni/board/message?board.id=170&message.id=129120&query.id=1876179#M129120

0 Kudos
Message 2 of 4
(3,206 Views)
yes, but thats not actually an answer. I have been trawling the forums but am new to ActiveX, this is the first time I have ever used it so could just do with a prod in the right direction
0 Kudos
Message 3 of 4
(3,199 Views)
Solution
Accepted by topic author alecjcook

Try this. There are 2 methos item(get ) and item (put)  for reading and writting value respectively to a cell in excel .

Best of luck

Message Edited by gak on 08-10-2009 12:00 PM
Gaurav k
CLD Certified !!!!!
Do not forget to Mark solution and to give Kudo if problem is solved.
Message 4 of 4
(3,186 Views)