def __init__(self,
basename="",
hlr_selected=False,
**kwargs):
for key in kwargs:
self.__dict__[key] = kwargs[key]
if "session_started" in self.__dict__:
Synergy.__init__(self,self.session_started)
if "general_output_txt" in self.__dict__:
CheckLLR.__init__(self,
basename,
hlr_selected,
general_output_txt=self.__dict__["general_output_txt"])
else:
CheckLLR.__init__(self,
basename,
hlr_selected)
self.index_row = 0
self.index_column = 0
self.log_filename = None
self.log_handler = None
def export(self):
wb = load_workbook(filename = 'template/clean_saq345_derived_requirement_review.xlsx')
#ws = wb['Register']
ws = wb.get_sheet_by_name(name = 'Register')
self.putLogo(ws)
#wb = Workbook(True)
#ws = wb.create_sheet()
# Title
ws.cell('C7').value = ""
# Reference
ws.cell('C8').value = ""
# Issue
ws.cell('C9').value = ""
row = 14
for req in self.tbl_req_derived:
line = []
value = self.tbl_list_llr[req]
# Create list from dictionary
file = self.list_llr_vs_file[str(req)][0]
line.append(file)
line.append(req)
body = CheckLLR.getAtribute(value,"body")
#row.append(Tool.removeNonAscii(body))
line.append(body)
rationale = CheckLLR.getAtribute(value,"rationale")
#row.append(Tool.removeNonAscii(rationale))
line.append(rationale)
line.append("B")
self.sqlite_connect()
chapter = self.sqlite_get(req)
line.append(chapter)
row += 1
for col_idx in range(1,7):
column = get_column_letter(col_idx)
ws.cell('%s%s'%(column, row)).value = '%s' % (line[col_idx - 1])
#ws.append(row)
CheckLLR.set_border(ws, "A12:P12")
CheckLLR.set_border(ws, "F2:J4")
CheckLLR.set_border(ws,
"C15:C%s"%(row),
font = Font(name='Arial',size=10,bold=False),
border_style=BORDER_THIN,
alignment_horizontal="left")
CheckLLR.set_border(ws,
"D15:D%s"%(row),
font = Font(name='Arial',size=10,bold=False),
border_style=BORDER_THIN,
alignment_horizontal="left")
# save the file
filename = "Derived_Req_Feedback_%d.xlsx" % floor(time.time())
wb.save(join("result",filename))
return filename
