Selenium Automation Framework : Reporting Suite Execution Status In Excel

By AravindSelenium 2, selenium webdriver, WebDriver, WebDriver Datadriven Framework, WebDriver Examples, webdriver tutorials
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.

15 thoughts on “Selenium Automation Framework : Reporting Suite Execution Status In Excel”

  1. 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.

    Reply

  2. 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.

    Reply

  14. 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 ?

    Reply

  15. 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

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *