[FEATURE] Excel Test Report

StatCan / tass-ssat

Testing and Automated Services Suite – Suite et service d’automatisation et de testing

Apache License 2.0

0 stars 0 forks source link

[FEATURE] Excel Test Report #163

Open ty-desj opened 1 month ago

ty-desj commented 1 month ago

Create an Excel report module. Convert JSON output to an excel workbook including some basic charts/graphs.

Requires #165

Charts/Graphs/Views to include:

[ ] Pie Chart
- [ ] Pass/Fail/Status
[ ] Bar Graph
- [ ] Pass/Fail by Browser
[ ] Elapsed time

ty-desj commented 1 month ago

@DominicParent @Pswenne I have included a few of the data views/charts we discussed the other day. Any other suggestions for what to include in the default excel report?

DominicParent commented 1 month ago

Can't think of anything else to include by default. Chris might have some ideas.

ty-desj commented 1 month ago

After reviewing some of the openpyxl features and our own JSON result document. I think it might be beneficial to refactor the json output to better organize/display the results in a way that is more easily readable by both people and the machine.

I've created a new issue to track this change separately from the Excel report function. It should be completed before a full Excel reporting implementation to minimize risk of breaking changes to the Excel reporting. #165