Duplicate a row in an excel file

[Hugh]

Is there any easy way to duplicate a entile row in an exsisting Excel file
inside labview? Thanks.

Hugh

[Khalid]

.



You can use the DDE VIs for this with the following settings:

DDE Open Conversation.VI:
Service = Excel
Topic = Book1.xls

DDE Request.VI:
Item = r4

This will get you the whole of 4th row as a string in the 'Data' terminal of the 'DDE Request.VI'

You can play with other DDE VIs available for a continuous update of the data.

Rgds,

Khalid 🙂


.

[Albert.Geven]

Our department submitted a GOOP excel library to the resource library.
You can find a description at: http://zone.ni.com/devzone/explprog.nsf/931ca51408547952862568720062e1de/e9b00485fca7df3e8625699d004eeeec?OpenDocument
simply searching for excel does not work
You can read a row easily and copy it to another row via activeX that is much faster than dde.