Forum Discussion

diogormendes's avatar
diogormendes
New Member
4 years ago

Connect Excel to Zephyr to retrieve data based on filter and create graphics

Is there a way to connect Excel to the Zephyr project whereas I can make formulas to be able to create filter? Example: From all tests, I want the ones with COMPONENT "Layout" and Status "AUTOMATED"...
Reports
  • MisterB's avatar
    MisterB
    4 years ago

    Hi,

     

    There is the ability to return detailed test data in the Reports area of Zephyr Scale.  The data is generally the same for all reports that you run (try the Test Execution Results List report).  To access the data in Excel format, run the report, then in the top right-hand corner click on the button to export dataset to Excel.

     

    Does that work for you?

     

     

sonya_m's avatar
sonya_m
SmartBear Alumni (Retired)
4 years ago

Hi diogormendes !Looks like your post was on the Collaborator forum board, I moved it to Zephyr forums. Could you specify which Zephyr product you are using? Thank you

  • MisterB's avatar
    MisterB
    Champion Level 3
    4 years ago

    Hi,

     

    There is the ability to return detailed test data in the Reports area of Zephyr Scale.  The data is generally the same for all reports that you run (try the Test Execution Results List report).  To access the data in Excel format, run the report, then in the top right-hand corner click on the button to export dataset to Excel.

     

    Does that work for you?