Labview will not read data from an Excel file that is already open.

[cocilovo]

I want to read data from an Excel file.  Currently the user specifies the Excel file path, then the New Report.vi creates a template from the file, and then the Excel Get Data.vi reads the data.  This works unless the file is already open.  How can I either read the data while the file is open or close the file?

[Anil_Reddy]

we can not open 2 instances of same excel file. It will detect that the file is already open and asks for confirmation to discard the previous instance and open new one..........

[Cory_K]

Is the file open in Excel, or is it open because your VI is writing data to it somewhere in your code?

If the latter case is true, you can use a semaphore to ensure that a read and write operation are not trying to occur simultaneously.

[cocilovo]

---

Cory K wrote:

Is the file open in Excel, or is it open because your VI is writing data to it somewhere in your code?

If the latter case is true, you can use a semaphore to ensure that a read and write operation are not trying to occur simultaneously.

---

The file is open in Excel.