how to create report on excel without excel toolkit??

[LV_Enthu]

Can anyone please tell me how to create an excel based report (much like what an excel toolkit produces) without having the luxury of

an additional Microsoft Office toolkit/???

thanks

[D Robertson]

Active X is the answer.  Below are some links to a few Developer Zone articles.  Using Active X isn't the easiest thing I've ever done using LabVIEW, but it is possible.

http://zone.ni.com/devzone/cda/tut/p/id/3520

http://zone.ni.com/devzone/cda/epd/p/id/3934

Good Luck,

Dave

[smercurio_fc]

You can also look over the many examples in the Excel thread. Note: Do not post questions in that thread.

[LV_Enthu]

okey... simple question... i got the NI OFFICE toolkit, and i want to save all my DAQ data on an excel sheet and plot the graph for it....(create a report)

my sampling speed it not much, 1 sample/sec. i am using the MS Office Report.vi to save the report to a file. however, i observe that if i add the MS Office Report.vi in while loop,

the program keeps on asking for a file name every iteration unlike the Save to Measurement file.vi (where it asks only once and then keeps on adding data to the next file unless 

any other logic is applied). also, it only saves the first 3 rows of data.

how do i make the code so that the excel file saves the entire data and the graph plots a summary kind of plot of the data i have from the DAQ.

Thanks in advance.

[LV_Enthu]

here is the vi. forgot to attach