Forum Discussion

BA_Service_Haus's avatar
BA_Service_Haus
Regular Contributor
16 years ago

Excel_DataSource: does not read 1st row

Hi,

this error was found with version 3.6.1 Pro.

Description:
We created a testcase using an excel datasource.
The first 3 lines (and 4 columns) of the Exel file were filled.
But when running the testcase only line 2 and 3 are read by soapUI.

Here is what I configured:


Please see the attached Excel sheet also.

Best regards
Nico

1 Reply

  • BA_Service_Haus's avatar
    BA_Service_Haus
    Regular Contributor
    Hi,

    now I think I've found the porblem.
    To delimit the number of datasource rows in soapUI, I've defined the values "Start Row = 1" and "End Row = 3" in the DataSource Options dialog. I found out that I can also delimit by checking "Goto Loop on Empty". So I removed the row values, and now everything works fine.

    I also found, that in the online documentation, there is an explaination:
    Start Row The first row in the configured DataSource to use (first row = 0)

    So this might explain my problem.


    Best regards
    Nico