Extracting test case from Excel using rqmexcelimporter and FindCell()

Hello,

I try to import test cases from Excel. This works quite fine, only the Find*() functions are not working

Example:

testcase.dc:title=FindCell("Title") + (0,1)

After import In RQM the title field contains "Title". It seems that "+ (0,1)" is ignored.

If I specify a string which can not be found in the excel sheet (e.g. Titlex) I get:

Getting artifacts from document - "UnitTestCases.xls".....
Error: Configuration File, Line 31, In the FindCell function, the search string "Titlex" was not found.
Error: Configuration File, Line 31, Found a value that reduced to "1", but was expecting a value equivelant to a column, cell, or literal.

*** Exporting Aborted: Errors found! ***

that means the importer understands the function FindCell() :-)

Another side effect is that not the exact string is searched. In the above example I had also another Cell with text "Tile:". FindCell("Title") did return "Title:". Is there a description how FindCell searches?

But most important: what is the correct syntax?  " + (0,1)" at least is ignored :-(!

  Thanks, Joerg



___________________________________
the documentation for the feature in "excel Migration configuration.doc" is:

...

Constants can also be added to the function calls.

So FindRow(“Data that is in the second row”) + 1 would return 3

Also FindCell(“Data that is in A1”) + (1, 1) would return B2.

Lastly if you just add one number to a FindCell it adds it to the row. For Examaple FindCell(“Data of A1”) + 1 would return A2.

The related sample xls/cfg files are titled “Requirements 001 with dynamic directive setting.”

...