Facing problem in writing data to excel sheet using ActiveX

[Rikki]

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

[Rudi_N]

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.

[Rudi_N]

Sorry, here is the second example.

[Rikki]

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

[Joe_H]

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.

[Rudi_N]

Rikki:

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

Regards,
Rudi N.

[Joe_H]

There is also an example in the example finder under active X called write table to excel. Have a look at that example

[Rikki]

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

[JLS]

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

[Rikki]

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