Forum Discussion

MarkSchofer's avatar
MarkSchofer
Frequent Contributor
3 years ago
Solved

Data Driven Loops

They seem easy enough. Read a CSV file (I have done that). The parameters are for only an individual cell and I am not able to get the looping working here is the script version. def Loopy(): Chec...
Marsha_R's avatar
Marsha_R
Champion Level 3

Closer!

 

You should be able to change these sort of blocks 

aqTestCase.Begin("GetCheckNumber")
Log.Message(DDT.CurrentDriver.Value[2])
aqTestCase.End()

 

to something like

aqTestCase.Begin("GetCheckNumber")
Log.Message(DDT.CurrentDriver.NameOfCheckNumberColumn)
aqTestCase.End()

 

That's assuming you have a header row 

MarkSchofer's avatar
MarkSchofer
Frequent Contributor
3 years ago

I learned something here. I do not have column headers as that is system dependent.

  • For the Excel driver, the names and number of columns and rows are determined by the populated cells in the underlying Excel sheet. Depending on certain Windows Registry settings, the driver may recognize the first row of an Excel worksheet as column names or data.

    I am the later.

  • Marsha_R's avatar
    Marsha_R
    Champion Level 3
    3 years ago

    You mentioned using a .csv file - that would be the easier way to go and that will get you the column headers.  You can still open it in Excel for editing if need be, but I've run into issues with Excel files before where the cells get hidden characters or otherwise corrupted and the only way to fix it is to make a new sheet.