reading mesurements from excel file using labview

[Brainiac91]

Hello LabVIEW community,

i want to develop a simple VI that read mesurements which are stored in an EXCEL file in real time. Can i have acces to that file which is opened by another application and read these meserments on the same time ( the file is opened by both the application and the VI) ?? and if is it OK , how can i can i do that?

Thnks

[PalanivelThiruvenkadam]

Your Query is on how to access  Excel File/ How access when file is been used (accessed) by other application.

If Your query is on First Point use RGT / Develop VI to Invoke Excel Application.

For the Second point i guess its difficult, i experienced error while accessing an excel from different application.

If you state the actual need we can provide alternative way

[Brainiac91]

i'll rephrase my issue,

there is an application that store some mesurement in an EXCEL file continuesly , i want to develop a VI that read these mesurements in real time , so the EXCEL file is opened by both applications , my question is : is it possible to read from an EXCEL file that is already open ?? and how can i test the file is modified and ENREGISTRED so i can begin the exploitation of the file

[JÞB]

---

@Brainiac91 wrote:

i'll rephrase my issue,

there is an application that store some mesurement in an EXCEL file continuesly , i want to develop a VI that read these mesurements in real time , so the EXCEL file is opened by both applications , my question is : is it possible to read from an EXCEL file that is already open ?? and how can i test the file is modified and ENREGISTRED so i can begin the exploitation of the file

---

Use TDMS files.  They can be set to have concurrent access and Excal imports them easily with the TDMS AddIn for excel.

[Hooovahh]

If you do use the TDMS method as Jeff suggested, you might want to look into converting this TDMS into an Excel file so the users don't need the NI Addin to open your file.  I've done this in places so that my users have an Excel file that they can email to others to open, but I have the TDMS file so it can be indexed with DataFinder or DIAdem.  Here is a tool I made which can convert TDMS to XLSX by leveraging NI's Addin.

[Brainiac91]

i succeeded in reading the excel file but i have an issue.

in the picture below i have a table of measermenets , i want to filtre the measurement in the red rectangle and put them in a 1d table , can anyone help me??

[JÞB]

Why yes I can help.... but its soooooo much easier with a TDMS file and there a lots of examples plus the TDMS file viewer that does all of that for you:)

[Brainiac91]

@ Jeff·Þ·Bohrer 

i didn't use TDMS file before, can u help me with a VI??

[nyc_(is_out_of_here)]

---

@Brainiac91 wrote:

@ Jeff·Þ·Bohrer 

i didn't use TDMS file before, can u help me with a VI??

---

Jeff is a paid consultant.

Unless, your company wants to pay him, I suggest you make an attempt on your own, in other words, program a VI, and he can help you fix it if it doesn't work.

If you can't do the job, maybe it is time to tell your manager of your inadequacies.

.

[StefanR]

labview\examples\File IO\TDMS\Standard Read and Write\TDMS Standard Read and Write.lvproj

labview\examples\File IO\TDMS\Advanced Read and Write\Asynchronous Read and Write\TDMS Advanced Asynchronous Read and Write.lvproj