LabVIEW Tutorial: How to Read & Write Excel Data by Selecting a Sheet

In this LabVIEW tutorial, I will show you how to read and write Excel data. We will use standard functions from the Report Generation Toolkit. We will not use Express VIs, so you can learn how to control your program better! In this video, you will learn how to: -Check and open an Excel file in LabVIEW. -Select an Excel sheet using a Text Ring menu. -Read data from specific rows and columns. -Write new data into an Excel sheet. -Fix and draw table borders automatically. -Clear old data before saving new data. -Write data by referencing a "Cell Name" instead of an index. -------------------------------------------- ⏱️ Video Chapters (Timestamps): 00:00 - Introduction 00:45 Example 1: Check the file using File I/O functions 01:56 Example 2: Select the sheet 03:45 Example 3: Reading data from the selected sheet 04:56 Example 4: Writing data and fixing table borders 08:02 Example 5: Writing data using Cell Names -------------------------------------------- 💻 Software Used in this video: LabVIEW 2021 (64-bit) Report Generation Toolkit -------------------------------------------- 📥 Get the code here: You can download the file from this video here: 📥 https://github.com/PLS-C/LabVIEW-Exam... Or, you can download the whole example here: 📂 https://github.com/PLS-C/LabVIEW-Exam... -------------------------------------------- Reference Write Data to an Excel File Using the LabVIEW Report Generation Toolkit https://knowledge.ni.com/KnowledgeArt... #LabVIEW #ExcelWithLabVIEW #ReportGenerationToolkit