Hi, I need some help to insert some data to specific cells in Excel In LabVIEW. Im using Active-X for executing this. Its show errors while running it. Errors are attached in this post. But. while running it in"Highlight Execution mode", it shows no errors. Please help me on this. Is there any alternative method other than using Active -X for writing data to specific cells. Thanks in advance. Shaz M Rahath

When I ran you code, the Error tha LabVIEW popped up was that the requested cells were "protected", or Read-On\ly. removing the Protection enalbed the code to run and "do what you expted". I changed to two Cell Contets to Newer and Newest, and put the second Easy Table after the first, connecting it to the Passthrough Report Object and Error Line wires. I hope you agree (once you fix the bug in the data, not in your code) that this little piece of code is much easier to understand (and modify) than is ActiveX. Bob Schor

Shaz, You are opening a single reference to a worksheet and then in parallel you have multiple instances of 'Close Reference.vi' racing to close the same reference. As soon as one of the instances closes the reference the rest of the code is broken.

LabVIEW

Writing value to specific Cell in Excel Sheet Using ActiveX in LabVIEW

Solved!

Author

HI everyone,

The issue has been solved. I thank everyone for their valuable suggestions and the the time of yours.

Thanks and regards,

Shaz Rahath

Message 11 of 11

(1,487 Views)

LabVIEW

Writing value to specific Cell in Excel Sheet Using ActiveX in LabVIEW

Re: Writing value to specific Cell in Excel Sheet Using ActiveX in LabVIEW