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.

Nothing much to share on the last eve of 2013, just an idea that how automation can be a boon for lethargic people like me :).

Coming to Scenario:-

We created Test Sheets for our “Keyword Driven Framework“,it was more than 
20 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 
Test case-ID column with increasing values.

Solution:-
Manual 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.

So we created one simple script that  added TC-ID to all the Test Steps, which are
 added as comments to the test sheet(Comments begin with some symbol like in our case 
it was ‘X’).
Learn about Excel automation here…

Logic:- 
Add TC-ID in increment fashion where we are having comments.

Enjoy testing 🙂 and Happy New Year, 2014 …Cheers!!!!

Code:-

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