Submit and vote on feature ideas.

Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

How do I use an Excel Spreadsheet as a data source

LegacyForum Posts: 1,664 ✭✭
edited December 2016 in SOAtest
  1. Right-click the root Project tree node.
  2. Choose Add Data Source from the shortcut menu.
  3. (Optional) Change the data source label in the Name field of the Data Source panel.
  4. Choose Excel Spreadsheet from the Type box.
  5. (Optional) Use the Rows controls to indicate the range of rows you want to use and whether the rows can be used concurrently.
    • If you only want to use selected rows, click the Range button, then enter the desired range (assuming a one-based index) by typing values into the From and To fields. For example, to use only the first 10 rows, enter 1 in the From field and 10 in the To field. To use only the fifth row, enter 5 in the From field and 5 in the To field.
    • If the values in each data source should only be used by one virtual user at a time, clear the Rows Can Be Used Concurrently check box. Disabling this option is particularly useful if you want SOAPtest to assign login username/password pairs from this data source, but your site prohibits multiple simultaneous logins from each user.
  6. Click the Location field's Browse button and use the file chooser that opens to specify the location of the Excel file. If you want the path saved as a relative path (for example, to facilitate project sharing), check the Persist as Relative Path option.
  7. Select the sheet of the specified Excel file you would like to use from the Sheet menu.