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

[ShazRahath]

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

[ShazRahath]

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

[Bob_Schor]

LabVIEW 2014 includes the Report Generation Toolkit.  With this, it is very easy to write to a specific cell in Excel.  There are numerous examples that illustrate how to do this, including several in this forum (one of which I posted almost two years ago).

Bob Schor

[Wayne.C · Accepted solution]

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.

[ShazRahath]

Hi Bob,

I tried the same witht report genearation toolkit. Still, some error is showing. Please help on this if possible.

Thanks,

Shaz Rahath

[nyc_(is_out_of_here)]

---

@ShazRahath wrote:

Hi Bob,

I tried the same witht report genearation toolkit. Still, some error is showing. Please help on this if possible.

Thanks,

Shaz Rahath

---

Did you bother reading the error message?

It says that the cell is protected.

[ShazRahath]

HI,

Sorry for that image. I changed the cell protection. Even aftert that its showing different error. When i give only two cells, its showing no error. when i add all the other elements (cells) its showing error. Pls find the attached error image.

Error 1 occurred at Incorrect function.
in Write to Excel - Specific Cells.vi

Possible reason(s):

LabVIEW: An input parameter is invalid. For example if the input is a path, the path might contain a character not allowed by the OS such as ? or @.
=========================
NI-488: Command requires GPIB Controller to be Controller-In-Charge.

Thanks and regards,

Shaz Rahath

[nyc_(is_out_of_here)]

---

@ShazRahath wrote:

HI,

Sorry for that image. I changed the cell protection. Even aftert that its showing different error. 

Thanks and regards,

Shaz Rahath

---

Then you should have attached the JPG of the new "different" error.

Also, have you done anything to follow Wayne C's suggestions?

I would suggest that you actually do some work to try to fix this problem.

[ShazRahath]

Hi,

I tried all the possibilities suggested. I didnt understand the Wayne C's suggestion. if i am supposed to open each reference for every worksheet , then every time the excel repoens and saves the data repeatedly. I tried to put close reference individualy for each reference as per Wayne C's suggestion. But, its showing this error. Please reply.

Error 1 occurred at Incorrect function.
in Write to Excel - Specific Cells.vi

Possible reason(s):

LabVIEW: An input parameter is invalid. For example if the input is a path, the path might contain a character not allowed by the OS such as ? or @.
=========================
NI-488: Command requires GPIB Controller to be Controller-In-Charge.

Thanks in advance,

Shaz Rahath

[Joe_H]

These questions have been answered many time in this forum. Please have a look at the LabVIEW examples there is one that is called Write table to Excel. That will hekp you out. For more information and some sample VI's and tool kits, you can go to the excel board.

[Bob_Schor · Accepted solution]

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