How to read excel file in LabVIEW

[tronoh]

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

[aputman]

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

[James.M]

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).

[Dennis_Knutson]

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.

[.aCe.]

---

@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/

[Hooovahh]

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

[RTSLVU]

---

@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.

[Hatef.fouladi]

why you do not use write spreadsheet files?!

[aputman]

---

@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.

[Hatef.fouladi]

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