LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Facing problem in writing data to excel sheet using ActiveX

Hi.
I want to write data from a one dimesional array to a particular excel sheet in a particular row.Please see the attached vi for explantion.
It is giving error.But If I give a new file name when the appliation is getting closed it is writing data to the new excel file.
Please help.
Thanks in advance
0 Kudos
Message 1 of 12
(3,952 Views)
Rikki:

I slightly modified the example vi that you posted. You should be able to write data to some particular cells that you specify within a speadsheet. I have also attached another example to help with this application. Let me know if this answers your questions.

Regars,

Rudi N.
0 Kudos
Message 2 of 12
(3,898 Views)
Sorry, here is the second example.
0 Kudos
Message 3 of 12
(3,896 Views)
Thanks Rudi,,,,
Sorry to reply you late...
Actually i am using LabVIEW 7.1. If possible please send the code in LabVIEW 7.1 or send the screen shot of the code.
Thanks Alot.
Rikki
0 Kudos
Message 4 of 12
(3,878 Views)
HI Rikki
 
Have a look in the excel board in this board are many VI'S that will help you. There is a whole excel toolkit and many explanations of how to do things in excel. I think most of the VI's in the toolkit were made in LV7. If you need some of the VI's I think I may still have them in or may be able to convert them to 7.0
 
I hope these VI'S help you out.



Joe.
"NOTHING IS EVER EASY"
0 Kudos
Message 5 of 12
(3,868 Views)
Rikki:

You should now be able to open up the example using LabVIEW 7.1. I hope it helps.

Regards,
Rudi N.
0 Kudos
Message 6 of 12
(3,859 Views)
There is also an example in the example finder under active X called write table to excel. Have a look at that example



Joe.
"NOTHING IS EVER EASY"
0 Kudos
Message 7 of 12
(3,852 Views)
Thanks Jhoskin and Rudi .......
 
I am able to write data to excel sheet now. I am attaching one"test.zip" file that contains a VI named "Squence.vi "that contains another subVI named "Write U94006 Table To XL.vi"which does the functionality of counting the number of rows in the excel sheet and writing data in the next blank row. I am using the same subVI in the VI named "Sequence.vi"two times so it is taking a lot of time in opening and closing the excel sheet. Will you please suggest some way of calling the subVI only one time.
 
Rikki
0 Kudos
Message 8 of 12
(3,838 Views)
Hello,
 
I'm getting into this thread late, but if you're trying to call a subVI only once, you can use a case structure to case on if this was the "frist call" to that code - see the Advanced -> Synchronization palette if you're in LabVIEW 7.1 for the "First Call?" function.
 
If your problem is more subtle, just let us know!
 
Thank you,
 
JLS
 
 
Best,
JLS
Sixclear
0 Kudos
Message 9 of 12
(3,822 Views)
Hi JLS
Thanks....
I think first call function only makes the restriction that SubVI runs only for one time. In my code.....firstly I have to check the number of rows filled in the excel sheet so that i can fill the intial value in Step field in the main vi named "Sequence.vi" and then i have to save the data in the next blank row in the excel sheet. But saving of the data should be done on click of the save button. Si i am calling "Write U94006 Table To XL.vi" again. because "Write U94006 Table To XL.vi" does both the functionality of saving as well as counting the number of filled rows.
Regards
Rikki
0 Kudos
Message 10 of 12
(3,814 Views)