how to transfer data in table to excel sheet

[Thandal]

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 upend to excel sheet
help me to slove my problem

[rolfk]

It seems to me that the example at examples\comm\ExcelExamples.llb\Write Table To XL.vi
should give you a very good idea how to go about this.

Rolf K

[Dave_Kaufman]

There are a couple ways to do this. One is to use NI's Excel toolkit, if you have it. If not, it's a $$ add-on you can get.

To do it yourself, you need to use ActiveX to communicate with Excel. Place an Excel.Application activeX control on your front panel. Now, in your diagram, feed that control into methods and properties nodes to get a workbooks object, a workbook object, a sheets object and then a range object. You can then write the table directly into Excel. The attached example may or may not work depending on your version of Excel (mine is XP).