LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to read excel file in LabVIEW

Dear Sir

 

I have data saved in excell file. What I know is that Labview cant read excell file. So can you please guide me in which format I should save data so that it could be read through "read from measurement file.vi in Labview"

 

Kind Regards

0 Kudos
Message 1 of 17
(23,577 Views)

Labview can read data from an Excel (.XLSX) file.  On the Report Generation pallet, you should find a set of VIs that can read and modify Excel files.  More specifically in the Excel General subpallet is Excel Get Data

Capture.PNG

aputman
------------------
Heads up! NI has moved LabVIEW to a mandatory SaaS subscription policy, along with a big price increase. Make your voice heard.
0 Kudos
Message 2 of 17
(23,570 Views)

Here's a tutorial for the Report Generation Toolkit.

 

Note: This toolkit does not come with all versions of LabVIEW. It is an add-on that is only included for free with Professional and above (maybe Student as well).

 

Excel Read.png

Cheers


--------,       Unofficial Forum Rules and Guidelines                                           ,--------

          '---   >The shortest distance between two nodes is a straight wire>   ---'


Message 3 of 17
(23,551 Views)
Even if you don't have the report federation toolkit, you can still read a native Excel file. There have been hundreds of posts on this subject. You should search before posting a question. Saving your Excel file as text (i.e. a csv) is also a very discussed subject.
0 Kudos
Message 4 of 17
(23,540 Views)

@tronoh wrote:

 

I have data saved in excell file. What I know is that Labview cant read excell file.


That's not true, please read this whitepaper http://www.ni.com/white-paper/3520/en/
However, you can use http://zone.ni.com/reference/en-XX/help/371361J-01/glang/read_from_spreadsheet_file/ if you can save your file in csv format for example https://support.bigcommerce.com/articles/Public/What-is-a-CSV-file-and-how-do-I-save-my-spreadsheet-...

@tronoh wrote:

So can you please guide me in which format I should save data so that it could be read through "read from measurement file.vi in Labview"

 


The express vi you mention can read from lvm files http://www.ni.com/tutorial/4139/en/ or tdms http://www.ni.com/white-paper/3727/en/

 


CLA CTAChampionI'm attending the GLA Summit!
Subscribe to the Test Automation user group: UK Test Automation Group
0 Kudos
Message 5 of 17
(23,534 Views)

Yeah the report generation toolkit is some times included but it requires having Excel installed to read and write XLS and XLSX files.  There is another option and that is a toolkit by XLR8.

 

http://sine.ni.com/nips/cds/view/p/lang/en/nid/212056

Message 6 of 17
(23,501 Views)

@Hooovahh wrote:

Yeah the report generation toolkit is some times included but it requires having Excel installed to read and write XLS and XLSX files.  There is another option and that is a toolkit by XLR8.

 

http://sine.ni.com/nips/cds/view/p/lang/en/nid/212056


I second the use of XLR8, as Hoovahh said the LV Report Generation toolkit requiers Excel to be installed on the target machine.

 

Also I have found that since the Report Generation tool kit uses ActiveX it is prone to failure due to minor differences in ActiveX and Excel versions as are the pure ActiveX methods of reading and writing Excel files you will find here.

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 7 of 17
(23,492 Views)

why you do not use write spreadsheet files?!

0 Kudos
Message 8 of 17
(23,464 Views)

@Hatef wrote:

why you do not use write spreadsheet files?!


Write Spreadsheet File works for CSV files (comma separated values), which can be exported from most Spreadsheet programs.

aputman
------------------
Heads up! NI has moved LabVIEW to a mandatory SaaS subscription policy, along with a big price increase. Make your voice heard.
0 Kudos
Message 9 of 17
(23,455 Views)

yes But I do not know what is problem if it work CSV anyway so the remain solution is use report generation as friends mention or use active x that I think there is some example of them inside labview example 

0 Kudos
Message 10 of 17
(23,442 Views)