From: Haiyang Zhao <haiyangx.zhao@intel.com>
To: Lijuan.Tu@intel.com, dts@dpdk.org
Cc: Haiyang Zhao <haiyangx.zhao@intel.com>
Subject: [dts] [PATCH V1 4/7] framework/excel_reporter: add dpdk version in excel result
Date: Fri, 27 Nov 2020 10:50:26 +0800 [thread overview]
Message-ID: <20201127025029.22276-5-haiyangx.zhao@intel.com> (raw)
In-Reply-To: <20201127025029.22276-1-haiyangx.zhao@intel.com>
add dpdk version in excel result and modify the other element index.
Signed-off-by: Haiyang Zhao <haiyangx.zhao@intel.com>
---
framework/excel_reporter.py | 54 ++++++++++++++++++++-----------------
1 file changed, 29 insertions(+), 25 deletions(-)
diff --git a/framework/excel_reporter.py b/framework/excel_reporter.py
index 65d26b6..89b9a17 100644
--- a/framework/excel_reporter.py
+++ b/framework/excel_reporter.py
@@ -76,38 +76,40 @@ class ExcelReporter(object):
def __add_header(self):
self.sheet.write(0, 0, 'DUT', self.header_style)
- self.sheet.write(0, 1, 'Target', self.header_style)
- self.sheet.write(0, 2, 'NIC', self.header_style)
- self.sheet.write(0, 3, 'Test suite', self.header_style)
- self.sheet.write(0, 4, 'Test case', self.header_style)
- self.sheet.write(0, 5, 'Results', self.header_style)
-
- self.sheet.write(0, 7, 'Pass', self.header_style)
- self.sheet.write(0, 8, 'Fail', self.header_style)
- self.sheet.write(0, 9, 'Blocked', self.header_style)
- self.sheet.write(0, 10, 'N/A', self.header_style)
- self.sheet.write(0, 11, 'Not Run', self.header_style)
- self.sheet.write(0, 12, 'Total', self.header_style)
-
- self.sheet.write(1, 7, Formula('COUNTIF(F2:F2000,"PASSED")'))
- self.sheet.write(1, 8, Formula('COUNTIF(F2:F2000,"FAILED*") + COUNTIF(F2:F2000,"IXA*")'))
- self.sheet.write(1, 9, Formula('COUNTIF(F2:F2000,"BLOCKED*")'))
- self.sheet.write(1, 10, Formula('COUNTIF(F2:F2000,"N/A*")'))
- self.sheet.write(1, 12, Formula('H2+I2+J2+K2+L2'))
+ self.sheet.write(0, 1, 'DPDK version', self.header_style)
+ self.sheet.write(0, 2, 'Target', self.header_style)
+ self.sheet.write(0, 3, 'NIC', self.header_style)
+ self.sheet.write(0, 4, 'Test suite', self.header_style)
+ self.sheet.write(0, 5, 'Test case', self.header_style)
+ self.sheet.write(0, 6, 'Results', self.header_style)
+
+ self.sheet.write(0, 8, 'Pass', self.header_style)
+ self.sheet.write(0, 9, 'Fail', self.header_style)
+ self.sheet.write(0, 10, 'Blocked', self.header_style)
+ self.sheet.write(0, 11, 'N/A', self.header_style)
+ self.sheet.write(0, 12, 'Not Run', self.header_style)
+ self.sheet.write(0, 13, 'Total', self.header_style)
+
+ self.sheet.write(1, 8, Formula('COUNTIF(G2:G2000,"PASSED")'))
+ self.sheet.write(1, 9, Formula('COUNTIF(G2:G2000,"FAILED*") + COUNTIF(G2:G2000,"IXA*")'))
+ self.sheet.write(1, 10, Formula('COUNTIF(G2:G2000,"BLOCKED*")'))
+ self.sheet.write(1, 11, Formula('COUNTIF(G2:G2000,"N/A*")'))
+ self.sheet.write(1, 13, Formula('I2+J2+K2+L2+M2'))
self.sheet.col(0).width = 4000
- self.sheet.col(1).width = 7500
- self.sheet.col(2).width = 3000
- self.sheet.col(3).width = 5000
- self.sheet.col(4).width = 8000
- self.sheet.col(5).width = 3000
- self.sheet.col(6).width = 1000
- self.sheet.col(7).width = 3000
+ self.sheet.col(1).width = 4500
+ self.sheet.col(2).width = 7500
+ self.sheet.col(3).width = 3000
+ self.sheet.col(4).width = 5000
+ self.sheet.col(5).width = 8000
+ self.sheet.col(6).width = 3000
+ self.sheet.col(7).width = 1000
self.sheet.col(8).width = 3000
self.sheet.col(9).width = 3000
self.sheet.col(10).width = 3000
self.sheet.col(11).width = 3000
self.sheet.col(12).width = 3000
+ self.sheet.col(13).width = 3000
def __styles(self):
header_pattern = xlwt.Pattern()
@@ -223,6 +225,8 @@ class ExcelReporter(object):
if self.result.is_dut_failed(dut):
self.__write_failed_dut(dut)
else:
+ self.col = self.col + 1
+ self.sheet.write(self.row, self.col, self.result.current_dpdk_version(dut), self.title_style)
self.__write_targets(dut)
self.row += 1
--
2.17.1
next prev parent reply other threads:[~2020-11-27 2:56 UTC|newest]
Thread overview: 9+ messages / expand[flat|nested] mbox.gz Atom feed top
2020-11-27 2:50 [dts] [PATCH V1 0/7] framework: record DPDK version in result Haiyang Zhao
2020-11-27 2:50 ` [dts] [PATCH V1 1/7] framework/dut: record DPDK version in host DUT Haiyang Zhao
2020-11-27 2:50 ` [dts] [PATCH V1 2/7] framework/virt_dut: record DPDK version in guest DUT Haiyang Zhao
2020-11-27 2:50 ` [dts] [PATCH V1 3/7] framework/dts: save dpdk version in global result Haiyang Zhao
2020-11-27 2:50 ` Haiyang Zhao [this message]
2020-11-27 2:50 ` [dts] [PATCH V1 5/7] framework/json_reporter: add dpdk version in json Haiyang Zhao
2020-11-27 2:50 ` [dts] [PATCH V1 6/7] framework/test_result: add dpdk_version in Result Haiyang Zhao
2020-11-27 2:50 ` [dts] [PATCH V1 7/7] framework/stats_reporter: add dpdk version in stats_reporter Haiyang Zhao
2020-12-01 1:33 ` [dts] [PATCH V1 0/7] framework: record DPDK version in result Tu, Lijuan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=20201127025029.22276-5-haiyangx.zhao@intel.com \
--to=haiyangx.zhao@intel.com \
--cc=Lijuan.Tu@intel.com \
--cc=dts@dpdk.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for NNTP newsgroup(s).