3.12.10 Using an Excel file as an external data source

In the Properties View , you can add Excel files as a data source to Test Cases which contain parameters referenced from the Test Cases or Test Steps they contain.
\includegraphics[height=2cm]{danger} The addition of data via Excel is discouraged, because any problems with the data can only be found once the test is running. We recommend using the central data sets in Jubula to manage data within the Project 3.12.9.

  1. Navigate to the Properties View for the Test Case you want to add the Excel file to.
  2. Enter the path to the Excel file in the Excel data file field.

    The path to the Excel file can be absolute or relative (if you have specified a data files path 3.27).

    \includegraphics[height=2cm]{lightbulb} The Excel file must be configured in a specific way in order for Jubula to read it

  3. If you reuse this Test Case , the Excel file you enter will be reused along with the Test Case . When you reuse the Test Case , you can choose whether you leave this file or change it for another one.
    \includegraphics[height=2cm]{lightbulb} If you store your Excel files in your workspace, you will be able to open these directly in Jubula from the navigator view using the in-place editor.
  4. A Test Case with an Excel file as data is marked with a small Excel icon in the browsers to help you find it more easily later.
    \includegraphics[height=2cm]{danger} Please note that the Excel file is read at the start of the test execution. Any changes to the file after this will not affect the test data. For information on using the date function in Excel, see the section later


Copyright BREDEX GmbH 2013. Made available under the Eclipse Public License v1.0.