01-26-2011 10:48 AM
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.
01-26-2011 12:19 PM - edited 01-26-2011 12:21 PM
WARNING::: DON'T RUN CRACKJACK'S VI. You'll quickly have 10's to hundreds of excel spreadsheets opening up.!
You have it set to open in Excel, not save to File. And it proceeded to continually open a new sheet without asking for a filename.
Why do you have the Office Report Express VI in a loop? It seems like something you should write out to Excel when you are done acquiring data. If you convert the Express VI to Save to File, there are settings in there as to which file name to save to and whether you want to save to a series of files.
01-26-2011 03:21 PM
Ravens Fan, firstly sorry for the trouble caused by opening my VI... yeah, i made the changes accordingly, but still i have to make sure the Office Report Express.vi has to be enabled
every time to create a report; correct??? or is it just one time enabling and then the vi keeps on creatng report?
can you send me an example please??
01-26-2011 10:20 PM
I don't have LabVIEW on this PC right now to be able to look at your VI again and try to create any examples.
But what I can suggest is that you get away from the express VI, and use some of the lower level VI's that make up the report generation toolkit palette.
Also, a good way to learn how the express VI is working is to right click on it, Open Front Panel, and allow it to convert to a regular subVI. Then you can open that and see how the underlying code works.
01-27-2011 10:30 PM
i tried doing i, where i am stuck is appending the data to the same excel file.. like in write to measurement file. vi, i cannot get it done in excel report ... can you help me with it/
01-28-2011 10:17 AM
Look at the Excel attachment, is this what you're trying to achieve?
01-28-2011 07:42 PM
ChristopherS, what i want is much more complex than this... i know this is the default template that you have generated the excel file from...
what i want is the user should be able to select when he should start writing the data to the file... unfortunately, if we put the MSofficeReport.vi
into a loop, it pops out too many word files as it did in my previous posts... also, i would like to have much more rows than merely
'operator's Name' and 'Company'... i woudl like to have date, date chart names... etc...
01-28-2011 07:42 PM
ChristopherS, what i want is much more complex than this... i know this is the default template that you have generated the excel file from...
what i want is the user should be able to select when he should start writing the data to the file... unfortunately, if we put the MSofficeReport.vi
into a loop, it pops out too many word files as it did in my previous posts... also, i would like to have much more rows than merely
'operator's Name' and 'Company'... i woudl like to have date, date chart names... etc...