Data Driven Loops

Question

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():
Check_V = ""
Check_Amt_V = ""
Check_Date_V = ""
Project.Variables.LoopD.Reset()
RecordIdx = 1
while RecordIdx <= 105:
#Derive DataLoop
#Retrieves the Excel cell value and saves it as Last Operation Result.
#LastResult = Excel.Open("C:\\Smartbear\\Documentation\\Formatted Pension.xlsx").SheetByTitle["Pension Formatted"].CellByName["AB1"].Value
#Check_Amt_V = LastResult
#Posts an information message to the test log.
Log.Message(Project.Variables.LoopD, "HappyBirthday")
#Retrieves the Excel cell value and saves it as Last Operation Result.
LastResult1 = Excel.Open("C:\\Smartbear\\Documentation\\Formatted Pension.xlsx").SheetByTitle["Pension Formatted"].CellByName["AB1"].Value
#Derive CheckAmt
Check_Amt_V = LastResult1
#Posts an information message to the test log.
Log.Message(Check_Amt_V, "")
#Derive Payee
#Retrieves the Excel cell value and saves it as Last Operation Result.
LastResult2 = Excel.Open("C:\\Smartbear\\Documentation\\Formatted Pension.xlsx").SheetByTitle["Pension Formatted"].CellByName["A1"].Value
Check_V = LastResult2
#Posts an information message to the test log.
Log.Message(Check_V, "")
#Opens the specified URL in a running instance of the specified browser.
#Browsers.Item[btIExplorer].Navigate("https://qat1.q.pers.state.or.us/Clarety/SANavigator.do?event=R_GO")
#Derive Check Date
#Retrieves the Excel cell value and saves it as Last Operation Result.
LastResult3 = Excel.Open("C:\\Smartbear\\Documentation\\Formatted Pension.xlsx").SheetByTitle["Pension Formatted"].CellByName["AA1"].Value
Check_Date_V = LastResult3
#Posts an information message to the test log.
Log.Message(Check_Date_V, "")
Project.Variables.LoopD.Next()
RecordIdx = RecordIdx + 1

marsha_r · Accepted Answer

You have the concept, but you're working too hard here
&nbsp;
See the Iterating through records section at this link
https://support.smartbear.com/testcomplete/docs/testing-with/data-driven/drivers.html
&nbsp;
You'll have one loop that iterates through the records.&nbsp; The driver is only opened and closed once.
As you work with a particular row, you can refer to the cells by column name.

markschofer · Answer

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 · Answer

Here is my solution&nbsp;def CurDriverExample():# Creates a driverDDT.ExcelDriver("C:\Smartbear\Documentation\FormattedPension.xlsx", "FP")# Iterates through recordswhile not DDT.CurrentDriver.EOF():# Gets a value from the storage and posts it to the logcount = DDT.CurrentDriver.ColumnCountfor 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 driverDDT.CloseDriver(DDT.CurrentDriver.Name)

marsha_r · Answer

Closer!
&nbsp;
You should be able to change these sort of blocks&nbsp;
aqTestCase.Begin("GetCheckNumber")Log.Message(DDT.CurrentDriver.Value[2])aqTestCase.End()
&nbsp;
to something like
aqTestCase.Begin("GetCheckNumber")Log.Message(DDT.CurrentDriver.NameOfCheckNumberColumn)aqTestCase.End()
&nbsp;
That's assuming you have a header row&nbsp;

markschofer · Answer

I learned something here. I do not have column headers as that is system dependent.For the&nbsp;Excel driver, the names and number of columns and rows are determined by the populated cells in the underlying Excel sheet.&nbsp;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 · Answer

You mentioned using a .csv file - that would be the easier way to go and that will get you the column headers.&nbsp; 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.&nbsp; &nbsp;

Forum Discussion

Data Driven Loops

6 Replies

Related Content

Data-Driven Loop in BDD Tests

Using Excel Sheet for Data Driven Loop with Empty Cells

How to user parameters in a data-driven loop?

Data-Driven Loop

Region Checkpoints in Data Driven loops

Recent Discussions

Searching for mapped object took too much time msg

Multiple execution of a test plan with different values from an Excel table

mht files are by default opening in Edge browser and its blank

Azure Devops Integration supports Testcomplete Base Fixed Dektop Module License

Devops integration support