Hi, I have a few questions about using excel as data source. I am trying to use excel file as data source as I need to be able to change the data for parameter prior prior to executing the test in automated environment. However, I am always getting "Not supported file type in </path/to/excel/spreadsheet> was chosen as data source. I would like to know what kind of excel spreadsheet's extension is supported? xls, xlsx and/or csv?
Also, the path that I specified for excel data source seems to be always relative to jubula workspace. For e.g.: if I specified /a/b/c as excel path, Jubula will be checking for </path/to/jubula/workspace>/a/b/c for excel file. I have tried setting AUT base directory so it is relative to the specified directory but it doesn't seem to be working as expected.
I have read user manual for excel configuration and defined my excel spreadsheet with parameter on first row, and data value on second row and named my sheet en_US. Please let me know what I have missed out.
In terms of the actual Excel file, I tried using Excel 2010 in both .xlsx and .xls (compatibility mode) and also received errors. I'll check to see if there's something I'm missing and open a bug if not. In the meantime - what data do you need to change prior to test execution? Could using variables in the test or system variables help you out?
Update on the Excel: I've now tried it with a file created with Excel 2003 and had no problems, so it is definitely a version issue. Anything created with Excel 2010 won't work - I assume this has something to do with the support in the library we use to read Excel files.
In terms of reading and using variables from the AUT: if you have e.g. running customer numbers (or other things that can't be defined in advance), then you can read the value that is shown in the AUT, store it in a variable, and enter the variable as $VAR_NAME later on in the test so you can use the value without ever having to know what it was. There are specific actions available to handle the storing of variables.