Excel File

This generator pulls data from an Excel 2007+ file (*.xlsx).

How to configure the generator to use Excel file content

• Random values
  • Randomly generate values from an Excel file.
  • File. Specify the source of the Excel file. Use the Browse… button to select a file.
  • Worksheet. Specify the Worksheet to use.
  • Column. Specify the column to use.
  • First/Last rows. Specify the rows to get data.
  • Restrict to values between. Will only use values that are within the specified limits.
  • Include random blanks. Allowing random blanks will mean that you generate empty strings among the values for use in the field or data type.

• Sequential list
  • Generate a sequence of values from an Excel file starting with the first row.
  • File. Specify the source of the Excel file. Use the Browse… button to select a file.
  • Worksheet. Specify the Worksheet to use.
  • Column. Specify the column to use.
  • First/Last rows. Specify the rows to get data.
  • Restrict to values between. Will only use values that are within the specified limits.
  • Start new line. Always start with the first row in the Excel file.
  • Continue from previous list. If you run a test and it ends with the 13th entry, the next time, the test will start with the 14th entry.

Note: If more than one field is configured using the same worksheet, the same row will be applied across a message. In other words, you can use an Excel file to ensure that several values will be used together. This is useful when you need to link a city with a zip code or a first name with a gender.

The examples below use the following content from a file named C:MyDocumentsmyExcelFile.xlsx