To write data to a text-based spreadsheet file, use LabVIEW to format data as a spreadsheet string and write the string to a file. The following are examples of using LabVIEW to write data to spreadsheet files depending on the type of data to write and your performance needs:

  • To write 1D or 2D array data to a spreadsheet file one time, use the Write Delimited Spreadsheet File VI.
  • To write data of different data types and of any dimension, use the Array to Spreadsheet String function.
  • If you require multiple write operations, use a disk streaming programming pattern to stream data to spreadsheet files.