Selenium Automation Framework : Reporting Suite Execution Status In Excel

STEP 12
Prerequisite : All previous (STEP 1 to STEP 11) selenium test framework creation steps should be Implemented.

As described In previous post, Your test execution status will be reported In testng report automatically by
SkipException. But If you wants to report execution status (Skipped or Executed) In excel file then once more you have to modify SuiteOneBase.java and SuiteTwoBase.java files.

How To Report Suite Execution Status In Excel
If you know, We have "WriteResultUtility" function In SuiteUtility class. We will use this function In our both test suite's base files to report execution status In TestSuiteList.xls file. Before test suite execution, It will check the "SuiteToRun" flag for that specific test suite. And report "Skipped/Executed" = "Skipped" status against that test suite If "SuiteToRun" = "N". Same way, If found "SuiteToRun" = "Y" then It will report "Skipped/Executed" = "Executed" status against that test suite In TestSuiteList.xls file.
Extract the downloaded folder and replace those files with existing files of "WDDF" project In Eclipse as described bellow.
(Note : It should replace existing file when paste It on package. It should not Insert new file.)

  • Paste SuiteOneBase.java File on com.stta.SuiteOne Package.
  • Paste SuiteTwoBase.java File on com.stta.SuiteTwo Package.
Now open your TestSuiteList.xls file from "com.stta.ExcelFiles" folder of "WDDF" project and set "SuiteToRun" = "N" for "SuiteTwo" as shown bellow.


Now save the TestSuiteList.xls file and close It.

Run Test Suite To Report Execution Status
Note : Before running test suite, Please make sure that your all .xls files are closed. If any file Is open then you will get an error during test suite execution.

Now we are all set for running test suite. Run your both test suites using testng.xml file In eclipse. When eclipse completes execution, open  TestSuiteList.xls file and verify that execution status Is updated or not against both test suites. You will see result as shown bellow.


As you can see In above Image, "SuiteOne" has been marked as "Executed" and "SuiteTwo" has been marked as "Skipped" using our selenium webdriver data driven automation framework.


at July 19, 2014
Related Articles : , , , , ,

15 comments:

  1. Tarun2 October 2014 at 07:50

    I am able see the results exactly what you are saying... but not able to the code logic which you provided in TestOneBaseOne.java, Read_XLS.java, SuitBase.java etc....

    Any suggestion to understand these code logic?? You will help is highly appreciable.

    ReplyDelete
  2. Unknown1 February 2015 at 19:52

    For me, both the suite "SuiteONe" and "SuiteTwo" are executed even though SuiteOne is marked as "N" in TestSuiteList.xls file.
    Also the column "Skipped/Executed" is not updated.

    ReplyDelete
    Replies
    1. Aravind6 February 2015 at 23:25

      have you downloaded Download Step 12.zip and updated all files? Give me your email ID so we can chat to resolve Issue.

      Delete
    2. Unknown24 February 2016 at 09:39

      This Skipped/Executed functional not working as describe

      Delete
    3. Anant18 July 2016 at 20:44

      I am observing the same issue.

      Delete
    4. Anant18 July 2016 at 20:45

      I am observing the same issue. Both test suites are being run and excel file is not getting updated.

      Delete
    5. Unknown16 January 2017 at 15:12

      This Skipped/Executed functional not working as describe

      Delete
  3. Unknown6 February 2015 at 22:00

    Any update on my query? I am waiting ......could not proceed to the next step.....

    ReplyDelete
  4. Unknown18 September 2015 at 10:45


    Cannot open TestSuiteList.xls fie from com.stta.ExcelFiles folder. Everything further is pending because of that. Please help!

    ReplyDelete
  5. sourav23 December 2015 at 21:12

    Hi Aravind, can you re-upload the doc of Step12.zip. The link throws an error and I am not able to download it.
    Thanks/Sourav

    ReplyDelete
  6. Unknown18 September 2016 at 23:55

    Hi Aravind, can you pls explain the code logic like how does it find location of the respective Excel files??..

    ReplyDelete
  7. Unknown18 September 2016 at 23:57

    Hi Aravind, can u pls explain me the code logic of class files.. i am not able to understand utility class code logic functions..?

    ReplyDelete
  8. Unknown10 February 2017 at 05:08

    after run TestSuiteList.xls file captured

    ReplyDelete
  9. Unknown25 May 2017 at 18:10

    Getting teh following error
    org.apache.poi.poifs.filesystem.NotOLE2FileException: Invalid header signature; read 0x0000000000000000, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document
    at org.apache.poi.poifs.storage.HeaderBlock.(HeaderBlock.java:181)

    Everything worked up until this step... where to from here ?

    ReplyDelete
  10. Unknown7 January 2018 at 17:42

    Getting the following error
    org.apache.poi.poifs.filesystem.NotOLE2FileException: Invalid header signature; read 0x0000000000000000, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document
    at org.apache.poi.poifs.storage.HeaderBlock.(HeaderBlock.java:181)

    could you please help . When opening the TestSuite file it seems corrupted.

    I tried setting the maven filtering to false.but still doesnt work

    ReplyDelete

Subscribe to: Post Comments (Atom)