04-19-2018 08:06 PM
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.
Solved! Go to Solution.
04-19-2018 09:17 PM
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.
04-19-2018 09:32 PM
Ok. ill try that thanks
@RavensFan
04-20-2018
11:16 AM
- last edited on
02-26-2025
05:30 PM
by
Content Cleaner
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.
04-20-2018 11:20 AM
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.
04-22-2018 03:43 PM
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
04-22-2018 07:46 PM
do u happen to have the block diagram for me to use excel in labview?
04-22-2018 07:48 PM
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
04-22-2018 09:14 PM
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
04-22-2018 09:19 PM
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