LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel and Labview

Solved!
Go to solution

Can anyone confirm if its possible to use an excel file WITHOUT changing the type of file? And if possible, do u have the block diagram to convert the excel file to be presented on the Front Panel? Thanks in advance.

0 Kudos
Message 1 of 14
(3,933 Views)

I don't understand your questions.  Why are you changing the type of Excel file?  What do you mean by "convert the excel file to be presented on the front panel"?

 

Do you have the Report Generation Toolkit?  That opens Excel files.  Search LabVIEW examples as well.

0 Kudos
Message 2 of 14
(3,912 Views)

Ok. ill try that thanks


@RavensFan 
0 Kudos
Message 3 of 14
(3,904 Views)

I also recommend the XLR8 add-on for LabVIEW.

 

XLR8 has the advantage of not needing Excel to be installed to be able to read and write Excel (.XLSX) files directly like the LabVIEW Excel Report Generation toolkit needs.

========================
=== Engineer Ambiguously ===
========================
Message 4 of 14
(3,869 Views)

Also if you open your Excel file in Excel and save it as a Comma Delimited text file (.CSV) you can open it using the Read Delimited Spreadsheet vi.

 

No conversion, add ins, or toolkits necessary.  

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 5 of 14
(3,866 Views)

You need to think about what it is you want to do.  Excel can read and write several types of files, two of which use an Excel-specific file structure and are characterized by the extensions .xls and .xlsx.  If you want LabVIEW to read these types of files, you need to use the LabVIEW Report Generation Toolkit (which can "talk to" Excel and get it to "do the dirty work" of managing the file format) or a third-party add-on that knows how to parse the file.  Note that the native Excel file has such features as Colored Cells, Borders, Graphs, etc.

 

On the other hand, if you have text data in a 2D format, with columns separated by <Tab> or some other character, such as a comma, and with rows separated by <NewLine>, then this text file can be read and parsed as a 2D array of String or Numeric data without needed Excel, just by using LabVIEW's Read/Write Delimited Spreadsheet File functions.  [The name of this function changed a few years ago when NI added an extra pair of terminals at the bottom for the Error Line].

 

Note that earlier answers to your question say more-or-less the same thing I've said -- I'm just wearing my "Professor" hat and trying to wrap it up in a single package ...

 

Bob Schor

Message 6 of 14
(3,831 Views)

do u happen to have the block diagram for me to use excel in labview?

 

0 Kudos
Message 7 of 14
(3,825 Views)

Thanks alot for replying. but i got into quite abit of bs when i changed the type of excel file. as i understand, my supervisor doesnt want me to change the type of excel to like CSV or Delimited text file etc 

0 Kudos
Message 8 of 14
(3,823 Views)

There are a number of examples that come with LabVIEW, and others that can be found on the Forum (I wrote one of them).  But it doesn't make much sense to suggest an example if we have no idea what you are trying to do.  Are you trying to read an existing Excel file?  [If so, attach a sample file and explain what you hope to do with the data].  Are you trying to write data as an Excel file?  [If so, describe the data and attach an example of the Excel file you hope to create].

 

Bob Schor

0 Kudos
Message 9 of 14
(3,817 Views)

My supervisor wants me to write a program that can read an excel file in LabVIEW. And eventually create a program that would read the excel file as a map for "SLAM" robot

Download All
0 Kudos
Message 10 of 14
(3,815 Views)