Rif.: CVI to control Excel and Word

[Srm27]

Hi,

I understand I need to use ActiveX for the following, still have not go to grips with it!!

I have python code, our standard, to perform the production test and get data, 3 different arrays, into
Excel with data on one page and a graph on another.

This will extend out as this test will be repeated at different temperatures.

We also generate a test report for each UUT, with serial number that is read using the likes of TextPad.

The following is now the challenge??!!

We now need to get this information out of the Excel, data and charts and put it into a report which needs to be Word.

Also into this report we will need to put headers and footers, pictures on the UUT, diagrams, possible Jpg format ,a table of content, and table of equipment used.

Let’s not forget that the formatting of text with in the report will differ depending where it is to be placed

What do you think? Any pointers to some code that will help to build a frame work?

Thanks

Simon

[RobertoBozzolo]

Basically what you need is included into two separate instrument drivers that you need to add to your project: Excel report and Word report.

I suggest you look at the documentation and the examples that ships with CVI, that you can found into  <CVI folder>\toolslib\activex\excel and <CVI folder>\toolslib\activex\word folder.

You can also look at forum posts that address this argument.

This material will give you the basic framework to work on and some additional hints in using the instruments.