Using Microsoft Excel to Create Datapool Data
328
Chapter 11 - Working with Datapools
Maximum Number of Imported Columns
You can import a datapool that contains up to 32,768 columns. If you open an
imported datapool in the Datapool Specification dialog box, you can view and edit all
datapool column definitions up to that limit.
A datapool is subject to a 150-column limit only if you generate data for the datapool
from the Datapool Specification dialog box.
Creating a Column of Values Outside Rational Test
A datapool that you create with Rational Test can include a column of values supplied
by an ASCII text file. You could use this feature, for example, if you want the datapool
to include a column of values from a database.
Populating a datapool column with values from an external file requires two
basic steps:
1
Create the file containing the values.
2
Assign the values in the file to a datapool column through the standard data type
Read From File.
Step 1. Create the File
If you want to use a file as a source of values for a datapool column, the file must be a
standard ASCII text file. The file must contain a single column of values, with each
value terminated by a carriage return.
You can create this text file any way you like--for example, you can use either of these
methods:
s
Type the list of values in Microsoft Notepad.
s
Export a column of values from a database to a text file.
