LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

overwrite to a particular cell in a spreadsheet

Hello everyone 🙂

 

I'd like to know how to overwrite data into a specific cell in a spreadsheet. For example, I have a word 'Tree' in row 2 column 1 which i need to change to 'blue tree'. Can someone please tell me how this can be done?

0 Kudos
Message 1 of 4
(2,294 Views)

Read the file, use the index row and column to access the element and use "Replace array subset" primitive to replace the old with the new one. Then write this array to the same file. Go through the LabVIEW basic tutorials to understand the basic functional blocks.

-----

The best solution is the one you find it by yourself
0 Kudos
Message 2 of 4
(2,288 Views)

Can you please tell me how to write back into the same file? this is the VI i have designed. It is showing an error if I wire the same file name to both the read and write VIs. Can you tell me how to make sure the dialog box does not appear twice?

0 Kudos
Message 3 of 4
(2,278 Views)

Please attach the code in 2011 version.

-----

The best solution is the one you find it by yourself
0 Kudos
Message 4 of 4
(2,275 Views)