Hello Hello 2014,with a Snoozy Scenario of a Automation – User friendly Tech help

Hello Automation Lovers,I just wanted to thanks a bunch for associating with uftHelp.com throughout 2013, and hope we further enrich this relationship in 2014.
n
nNothing much to share on the last eve of 2013, just an idea that how automation can be a boon for lethargic people like me :).
n
nComing to Scenario:-
n
nWe created Test Sheets for our “Keyword Driven Framework“,it was more than 
n20 sheets and each having lot number of test steps.Now as are moving into Agile world, so are our clients, thus all of a sudden  they wanted each test step in test sheet to have a 
nTest case-ID column with increasing values.
n
nSolution:-
nManual Approach:- Go to each sheet and add Test Case ID to each Test step, and it is very monotonous and tedious task at least for a automation engineer.
n
nSo we created one simple script that  added TC-ID to all the Test Steps, which are
n added as comments to the test sheet(Comments begin with some symbol like in our case 
nit was ‘X’).
nLearn about Excel automation here…
n
nLogic:- 
nAdd TC-ID in increment fashion where we are having comments.
n
nEnjoy testing 🙂 and Happy New Year, 2014 …Cheers!!!!
n
Code:-

n

n

Test Sheet:- ?, is where we needed the TC-ID to be added
n
n
n

Was this article helpful?
YesNo

Similar Posts