LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

write in spreadsheet ActiveX

hi all,

 

i have a spreadsheet activeX control. i am able to read the it's contents by giving cell range.Likewise I need to write on it.Anyone having idea.

 

 

 

Thanks in advance.... 

0 Kudos
Message 1 of 7
(4,206 Views)
You have to specify the cell no. and data. Same way as you are reading.
0 Kudos
Message 2 of 7
(4,197 Views)

You will need to open the references to the correct worksheet and add the range data. see the example

 

 Example.gif

Tim
GHSP
0 Kudos
Message 3 of 7
(4,183 Views)
If you're using activeX controls to work with Excel, you might find this VI useful - it can handle writing pretty much anything into any cell or range of cells, though formulae may have to be entered individually.


Never say "Oops." Always say "Ah, interesting!"

0 Kudos
Message 4 of 7
(4,181 Views)

hi

 

Here i have attached the screen shot of the code for Read and write in activeX Spreadsheet.In that, Read is working. Wite method is not working but it doesn't shows any error.see my attachment....

0 Kudos
Message 5 of 7
(4,177 Views)
Try giving the starting cell only on the range input i.e C3 not C3:D6
Tim
GHSP
0 Kudos
Message 6 of 7
(4,175 Views)

Like this

 

Example.gif

Tim
GHSP
0 Kudos
Message 7 of 7
(4,172 Views)