LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

how to transfer data in table, to excel sheet

In my vi,on button click i am adding new entries in table,now i want
1. when i press a button to write data in table, same time my data (set of data(i have 7 columns))must append to excel sheet
help me to slove my problem
0 Kudos
Message 1 of 4
(2,741 Views)
The first place you should look is at the shipping example called Write Table to XL (Help>Find Examples). It uses ActiveX. It won't do everything you need because it creates a new sheet for writing but it wouldn't take much to modify it to keep track of the last row written in a shift register for example. The second place to look is this page on NI's Developer Zone. The third place to look is this forum. doing a search for Excel shows about 1000 questions in the last 2 years. Many of these include examples. Once you've written something, please post again if you need some more help.
Message 2 of 4
(2,741 Views)
go to NI website:

http://www.ni.com/devzone/dev_exchange/ex_search.htm

and search for "excel goop"

You want the excel toolkit(GOOP)


this helped me do something very similiar to what you want to do.

Thandal wrote in message news:<506500000008000000E0CC0000-1079395200000@exchange.ni.com>...
> In my vi,on button click i am adding new entries in table,now i want
> 1. when i press a button to write data in table, same time my data
> (set of data(i have 7 columns))must append to excel sheet
> help me to slove my problem
0 Kudos
Message 3 of 4
(2,741 Views)
thanks for ans.
i am tryinf to download toolkit ,
but i don't know what is problem it's giving me error,
If you have some download then please send to me
0 Kudos
Message 4 of 4
(2,741 Views)