Agilent Technologies VEE Pro Guia do Utilizador descarregar pdf (Página 292)

100

101

264 VEE User’s Guide

6 Creating Reports Easily Using ActiveX Chapter

Creating an Agilent VEE to MS Excel Template

In this exercise, you will create a program to display an array of

VEE test data in MS Excel. You can use this program as a

template for displaying the results of other tests in MS Excel

spreadsheets.

Lab 6-2: Creating an Agilent VEE to MS Excel Template

1 Open results_average.vee.

2 Change the For Range object to loop 10 times.

3 Add the input B to Fill in Cells and change the statement inside

to read: sheet.cells(A+1,1) = B[A-1].

4 Click Device ⇒ Formula, rename it to Array of Test Data,

and enter the embedded functions randomize(ramp(20),

4.5, 5.5) to create a random array of 20 elements with

values from 4.5 to 5.5. Delete the input pin and connect the

data output pin to the B input of Fill in Cells.

5 Change the range in the Formula box on the bottom of the

screen from A21 to A11. The statement should now read:

set range = sheet.range(“A2:A11");

6 Save the program as report_template.vee and run it. Compare it

to the Excel worksheet as shown in

Figure 155 and the

complete program as shown in Figure 156.

1 2 ... 287 288 289 290 291 292 293 294 295 296 297 ... 601 602

Comentários a estes Manuais

Sem comentários

Agilent Technologies VEE Pro Guia do Utilizador Página 292

Comentários a estes Manuais

Manuais e produtos relacionados com Software Agilent Technologies VEE Pro