Write To Spreadsheet File issue

[muks]

---

Today night (i.e 6:00 P.M) IST i would be sitting and debugging that issue..

---

SO got the hardware?

[muks]

---

That issue is also seen even i copied the content to other excel sheet.

---

You mean to say the problem is with ms office?

[suneelkv]

Hi Muks,

I suspect the problem with ms office....

But i am still not clear

Since the issue is reproducible 5/10 times...

so let me chek today and crack the snag.,.,,,,,

-SUneel

[suneelkv]

Hi Muks/Deepu,

I broke my head up and down but couldnt crack it....

See the atrtached JPG which is my main code,...

And inside you can figure out something like Comparison algorithm.vi which is having this write to spreadsheet file.VI

Which i feel creating the issue.

Is it a good job to use set cell value.vi to write the data to excel sheet...

After my successive code walkthru i figured out the problem like this...

• I am opening the excel sheet to write the data....
• and in the Comparison algorithm.vi i am using write to spreadsheet file.vi which is again a spreadsheet concept.
• So two times excel sheet might be creating this issue,....

Please share your thoughts....

-Suneel

[Dennis_Knutson]

Your attempt to attch something did not work.

Some of your statements are also confusing. You mention using a set cell value function and also the Write to Spreadsheet. One uses ActiveX and the other is a write to text file. Do not mix the two.

[suneelkv]

SOrry the attaachement is here.......

error is somethign like this.

Possible reason:Duplicate path

NI 488: New I/O attempted with old I/O in progress.

[RavensFan]

You have some race conditions for your Test Case and HRL indicators.  In all likelihood, the values will get read from those indicators by the local variables in the frame at the top of your screenshot BEFORE the values get extracted from the array.  Thus you may be creating an invalid name for your wave file.

(By the way, the two index arrays at the bottom can be merged into one by exanding the bottom of the Index Array function.)

Try feeding wires from  Test Case and HRL to the top of your structure and DON'T USE LOCAL VARIABLES.

[RavensFan]

Also, dont' forget to close your reference to the sheet.