creating a excel file and saving data in it using ActiveX

[Rikki]

Hi All

I am using LabVIEW 8.0. I want to write data in to excel file using ActiveX. When i am  writing in to a file which is created manully by me then it is writing perfectly.

I used in my VI Open/Create File function. So if the file is not present LabVIEW is creating a file for me. But i am not able to write data in to it. I set the property of the file as Read-Write only. Still it is not able to save in to the file.

Please help.

Thanks in advance.

Rikki

[Christian Mergl]

Hi,

I would suggest to build up on a example "write table to excel.vi", which you will find with the NI Example Finder. This example is using activeX to write a table to excel, which shows the most common steps and also includes a good documentation.

BR, Christian

[Rikki]

Thanks Christian

I tried the write to table.vi which you have suggested me. It is creating the file and writing the data but when i again  try to write in to it it gives a message "File Existe do  you want to replace it" though i gave true to Save Changes as well as the file name when i am closing the workbook. Dont know the reason why it is asking for that.

Rikki

[Kalin_T]

Rikki,

Change the function to Create or Replace (for the Open/Create/Replace VI) and see if that works better for you.

Best regards,

[Rikki]

Thanks for the reply.

I tried the same way as you told but the same problem.Please see the attached photo whether i am doing correctly or not.

Rikki

[Kalin_T]

Rikki,

See my previous message. You are still using Open or Create.
Best regards,

[Rikki]

Thanks Kalin

The problem is solved. Thanks for your help.

Rikki

[Rikki]

Just for your information....

I tried that way also but was not able to do...

Rikki

[oneFranck]

Hi,

I need to open and write into an existing excel worksheet that already has some function in it.  

The VIs attached (xls Test VI.vi) are doing this ok... but I have a message from excel saying if I want to replace it.  I have to click yes for the program to continue, but in the future we would want it to be automatic.  

Can anyone point out what could be modified in order to perform this action without input?

Thx

FB'

[Gak]

hi oneFrank,

i couldn't open ur file..i use labview 8.5.i had faced same problem,so if i could open ur file i can help u. can u send me file saved in 8.5 version?