01-09-2007 07:36 AM
01-09-2007 07:55 AM
01-09-2007 08:06 AM
Marc,
I have the full version which does have the report generation tools, if that is what you are considering the tool kit. I have been through the training and understand how the activeX works but have not had to use it, until now I have a feeling. If you could throw together an example to give me an idea of the process that would be greatly appreciated.
Thanks,
Troy
01-09-2007 08:25 AM - edited 01-09-2007 08:25 AM
Well the report generation VIs that come with it are different. The toolkit interacts with MS Office to create reports. I haven't used it, but I'm pretty sure it does exactly what you want. You can do everything it does with ActiveX calls though. I'll throw together something that shows how to open Excel and get things started. I've only used Word extensively, but Excel can't be too much different.
What version of LabVIEW do you have?
Message Edited by Marc A on 01-09-2007 09:25 AM
01-09-2007 09:07 AM
well ther are a couple of ways. You could use the standard report generation VI's and make a complete report with the image of the graph embedded into the report with the raw data or you could use activeX and control excel thru LV and put the raw data into excel directly and have excel graph the data without any user interaction. I have posted a slew of VI's on the excel board if you do not have the report generation toolkit. If you could tell me which way you want to go I could possibly send you an example.
For more information and some sample VI's and tool kits, you can go to the excel board
01-09-2007 09:13 AM
01-09-2007 09:21 AM
Looks like Joe has a lot more experience with Excel, so I would suggest going to look at what he has. ActiveX is what you want for the greatest amount of flexibility. I have a set of Word VIs that I use in several projects when I need to create reports.
Of course you could always just pony up the cash to NI to get the Office Report Generation toolkit if you don't want to bother writing everything yourself.
01-09-2007 10:05 AM
OK here is my take on this.
Excel is great for this and there is an entire toolset on the excel board with lots of examples. but if there is not a huge amount of data then just use the regular standard report tools and embed the image of the graph into it. Have a look at the example called example html report.vi and sample test report.vi
But if you insist on using activeX for excel then have a look at the excel board and I will try to provide you with an example later.
For more information and some sample VI's and tool kits, you can go to the excel board
01-09-2007 10:10 AM
Joe,
Thanks for all the help. I actually download your Excel VIs a couple of days ago taking a look at what you have done. I have then on my functions pallete. Anyway I will take a look at the report generation VI as you have suggested and see what I can do. I do not have to use Excel, it was just what I have been using for the raw data and plotting to date.
01-09-2007 10:52 AM