LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Reading an Excel file through a network without excel installed.

I don't know if this is possible, but I have a program running on a computer that does not have Excel installed. I would like to read an Excel file into Labview from a computer on the same network that does have Excel installed. I do have the report generation toolkit for Excel.

Any help is appreciated.

Thanks.
0 Kudos
Message 1 of 4
(3,120 Views)
You may try using the Read From Spreadsheet File.vi under the File I/O palette. You will have to save your Excel file in a tab delimited text format.
0 Kudos
Message 2 of 4
(3,114 Views)
Because you don't have Excel on the target machine, the Excel-interaction utility of the Report Generation Toolkit is pretty much unavailable there. And I assume that you don't want the overhead of having to remember to save a .TXT version of your Excel files every time they are created or edited.

So, here's a solution: you can use VI Server to make the machine that does have Excel do all the work (I'll call this the server) and simply return the data to your client LabVIEW app. The basic scenario would be:

1. Build a VI on the server that inputs a pathname to an Excel file and then uses ActiveX to open the Excel file, grab the data you're after, and output the data (as a 2D array, etc.). Search the NI site for "read from excel" to find example snippets to do this.
2. Make sure the VI works on the server itself.
3. Build a VI on the client machine that calls your server VI using VI Server functions (Application Control >> Open VI Reference).

Step 3 is incredibly easy, so if you can bootstrap yourself with some example code and your Excel files are not too complicated, this should be a piece of cake.

Hope it helps,
John
Message 3 of 4
(3,106 Views)
Thanks!

That is exactly what I was looking for.
0 Kudos
Message 4 of 4
(3,080 Views)