LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

copying the contents of a cell in Excel and paste to the a word document

Hello

Can anyone help me in copying the contents of a cell in Excel and
paste to the a word document. With a VI i was able to get the
contents in a cell in excel , but as a table. When i directly connect
the output from "array to spreadsheet string" to a specific position
in word it does not work. Can any one help?

0 Kudos
Message 1 of 2
(2,409 Views)

Hello,

If you're able to read the excel cell, you're half way home 🙂  To add text to your word document, you probably just want to use a string searching function (match pattern perhaps) to find the location which you'd like to insert the new text from your excel cell.

This should be just simple file i/o VIs - open the word doc, read it into a string in LabVIEW, search/find the insert location and insert your text, and finally write that new total string back as the file and close it.

Check out the file i/o examples in the Example Finder to get started (see Help -> Find Examples... in LabVIEW).

Best Regards,

JLS

Best,
JLS
Sixclear
0 Kudos
Message 2 of 2
(2,392 Views)