Use the Read Delimited Spreadsheet VI to read double, integer, or string data from a text-based spreadsheet in LabVIEW.

To read from a spreadsheet file, complete the following steps.

  1. Create a relative path to the file from which you want to read data.
    1. Add the Build Path function to the block diagram.
    2. Wire any fixed part of the path to the base path input.
      For example, if your application stores spreadsheets in the default data directory for LabVIEW, wire a Default Data Directory constant.
    3. Wire the filename to read, along with any variable part of the path, to the name or relative path input.
  2. Add the Read Delimited Spreadsheet VI to the block diagram.
  3. Select the polymorphic instance of the Read Delimited Spreadsheet VI that corresponds to the type of data to read.
  4. Wire the appended path output of the Build Path function to the file path input of the Read Delimited Spreadsheet VI.
  5. Right-click the all rows output and select Create » Indicator.
  6. Run the VI.

LabVIEW returns the data from the spreadsheet file in the all rows indicator.