excel to labview on 2 different computer

[Dennis_Knutson]

There are numerous examples of how to read an Excel program with LabVIEW. Did you search the board? Do you have the report generation toolkit? Reading native Excel requires using ActiveX. LabVIEW typically reads the file. I'm not sure how you would setup Excel to send.

[preston_johnson]

If you have the excel data on Computer B, can you simple share the data folder where the excel sheets are saved?  Then computer A can access the files on computer B directly. 

In LabVIEW, look under the file function pallette and you will find tools to read spreadsheet files.  (you may need to save the spreadsheet file as a CSV file instead). 

If you are clever, you can even detect when a new CSV file has arrived and have LabVIEW automatically open it and read the data. 

What types of analytics are you hoping to perform in LabVIEW? 

[minghui]

Currently my excel spreadsheet is saved in xlsm format. I have my labview diagram created out. 

Problem now is my excel data can only be send to labview if they are on the same computer.

What I need is to send excel data in computer A to labview in computer B. But I'm not sure of what I need to include in my labview in order to do so. 

My data are from Wind turbine and solar panel. It is to use to analyse their pattern and maybe can use for cost calculation etc. The data receive at the labview will be send to a meter in my school lab at the end of the day. 

Any advise?

[preston_johnson]

can you acces your xlm files from another computer?  What I am asking is whether the directory on computer A is sharable.  If you can map the drive and folder on computer A from another computer, inlcuding computer B,  then programs on other computers can access the xlsm files.  I suspect you really do not need to move the files, simple access them.  Can you ask a computer support person in your organization to help you share (read access only) the directory on computer A where the xlsm files are stored?