Forum Discussion

MarkSchofer's avatar
MarkSchofer
Frequent Contributor
4 years ago

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...
MarkSchofer's avatar
MarkSchofer
Frequent Contributor

Yes that is a perfect response given it is a Monday here in the Pacific North West - That is pretty darn easy and now I have to the 23bit 64 bit matching game. I am going to give it a try with a CSV file.   It recommends a 32 bit version of TC or a 64 bit version of excel.    

**bleep** that was really easy. I did download the driver and it worked like a charm. Yes I was working far too hard.

MarkSchofer's avatar
MarkSchofer
Frequent Contributor
4 years ago

Here is my solution

 

def CurDriverExample():
# Creates a driver
DDT.ExcelDriver("C:\Smartbear\Documentation\FormattedPension.xlsx", "FP")
# Iterates through records
while not DDT.CurrentDriver.EOF():
# Gets a value from the storage and posts it to the log
count = DDT.CurrentDriver.ColumnCount
for i in range (0, count):
column = DDT.CurrentDriver.ColumnName[i]
#Log.Message(DDT.CurrentDriver.Value[1])
aqTestCase.Begin("GetCheckNumber")
Log.Message(DDT.CurrentDriver.Value[2])
aqTestCase.End()
#Log.Message(DDT.CurrentDriver.Value[3])
aqTestCase.Begin("GetCheckDate")
Log.Message(DDT.CurrentDriver.Value[26])
aqTestCase.End()
aqTestCase.Begin("GetCheckAmt")
Log.Message(DDT.CurrentDriver.Value[27])
aqTestCase.End()
DDT.CurrentDriver.Next()
# Closes the driver
DDT.CloseDriver(DDT.CurrentDriver.Name)

  • Marsha_R's avatar
    Marsha_R
    Moderator
    4 years ago

    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
      4 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
        Moderator
        4 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.