Pasting Excel data into front panel table

[kc64]

Is there a method that allows a user to paste a spreadsheet snippet into a LV front panel table control?  My client has specified LV2009SP1 and I have a lot of data (more than 4 cols by 100 rows) that I would really like to not retype.

[PaulRB]

Hi kc64,

This example should do what you want. All you have to do is change the 2D output array to a table control.

http://zone.ni.com/devzone/cda/epd/p/id/3177

[kc64]

Thanks for your reply.  This example actually does not address the method that I seek.  Instead of pasting the data into the table, the example opens the Excel file and imports the data without ever using a front panel table control.  Any other ideas?

[10Degree]

kc64,

I do a lot of copy / paste and data interchange between Excel and LabVIEW.  When you copy data from Excel, it will be TAB delimited array data in a spreadsheet string.  This is easy to parse in LabVIEW using the spreadsheet string to array.vi.  To paste to a table, read the clipboard string, parse the string to an array, and write to the value property of your table.  See that attached 2010 vi and pictures.

-cb

[rpecas]

Hi,

Many thanks for this solution. It works very well.

[ChrisLudwig]

That solution works from word tables as well.  Very handy.  

Kudos for the neat trick.

[breezy45]

Awesome solution even 12 years later!