User`s guide

Creating Reports Easily Using ActiveX Chapter 6
VEE User’s Guide 267
On Your Own
Generate a waveform and strip out the Time Span to get an
array. Create a VEE object for MS Excel with a worksheet
and set it to an Object variable. Make the application visible.
Then put the 256 point array into the worksheet range
"A1:A256" in one step, instead of one cell at a time.
Use an Unbuild Waveform object. Use the [a] build array
syntax to create a 2D array from a 1D array. Then call the
function transpose() to make it a 256 x 1 array instead of a
1 x 256 array for Excel to accept it in one step, as shown in
Figure 157.
Figure 157 Program for On Your Own Exercise
Extending Capabilities With MS Excel
Figure 158 shows a more elaborate example of a program to
display test results in MS Excel. You can see how knowledge
of a few more calls in the MS Excel library can expand the
template for displaying VEE data in MS Excel.