Clipboard (Copy & Paste from Excel / CSV) to 2D Double Array with Headings

[samsharp99]

Overview
This example VI converts comma or tab delimited data from the clipboard (copied from Excel or a CSV file opened in notepad) into a 2D array of numeric data.

Description
This example VI provides a way to read data from CSV files into your processing Vis. With this VI you can logged experimental data into a .CSV (Comma Seperated Values) file on the PC firstly, and then processed it in another VI. All the data from the CSV files will be read into a 2D array of numeric data. Anyone that uses LabVIEW for research or processing experimental data that stored in a spreadsheet may find that this can save a lot of time trying to figure out how to get data from Excel into LabVIEW quickly and easily.

This VI is designed base on the 3 articles on the knowledgebase below.

• http://digital.ni.com/public.nsf/allkb/38AEA2B236E43837862574400064C7A7 - Spreadsheet String to Arra...
• http://digital.ni.com/public.nsf/allkb/AE3293F9277FFFC98625752E007AF77C - Programmatically Access th...
• http://digital.ni.com/public.nsf/allkb/38AEA2B236E43837862574400064C7A7  - Copy and Paste Data From ...

There two controllers on the front panel, the "Header Row Button" decide whether removed the first row and the "TAB Delimited Button" will be click when the file is a CSV/Tab-delimited file rather than a CSV file.

Requirements

• LabVIEW 2012 (or compatible)

Steps to Implement or Execute Code

1. Unzip the attached folder to your computer
2. Open the VI "Clipboard to Numeric Array 2012 NIVerified.vi"
3. Chose the state of "Header Row Button" and "TAB Delimited Button"
4. Run the program

Additional Information or References
VI Block Diagram

 

 **This document has been updated to meet the current required format for the NI Code Exchange.**

[peterbaum]

awesome, thanks!