def __init__(self):
'''初始化参数'''
readConfig = RC.ReadConfig()
self.Msg_Title = readConfig.getMail('Msg_Title')
self.casePath = os.path.join(RC.path, 'test_case')
self.reportPath = os.path.join(RC.path, 'test_report')
self.Text_description = readConfig.getMail('Text_description')
self.on_off = readConfig.getMail('on-off')
# 实例化MyLog
self.log = MyLog.getLog('ExecuteCase')
self.logger = self.log.logger
def __init__(self):
'''初始化邮件属性'''
self.Rc = RC.ReadConfig()
self.server = self.Rc.getMail('Smtp_Server')
self.sender = self.Rc.getMail('Smtp_Sender')
self.receiver = []
self.password = self.Rc.getMail('Password')
self.LReceiver = self.Rc.getMail('OnLine_Receiver')
self.PReceiver = self.Rc.getMail('Pre_Receiver')
# self.PReceiver =
self.TReceiver = self.Rc.getMail('Test_Receiver')
self.Msg_Title = self.Rc.getMail('Msg_Title')
self.Content_Type = self.Rc.getMail('Content_Type')
self.Content_Disposition = self.Rc.getMail('Content_Disposition')
self.resultPath = self.Rc.getMail('resultPath')
# 实例化MyLog
self.log = MyLog.getLog('SendEmail')
self.logger = self.log.logger
# 实例化msg
self.msg = MIMEMultipart()
# coding=UTF-8
# FileName : Excel.py
# Author : Adil
# DateTime : 2017/12/10 13:08
# SoftWare : PyCharm
import xlrd
import os
from datetime import datetime
from openpyxl.reader.excel import load_workbook
from openpyxl import Workbook
from CiTest import readConfig as RC
Rc = RC.ReadConfig()
class Excel(object):
'''定义一个excel类'''
# 定义类变量
i = 0
def __init__(self):
'初始化基本信息'
self.path = Rc.path
self.readExcelPath = os.path.join(self.path, 'caseData')
self.reportPath = os.path.join(self.readExcelPath, 'caseReport')
# 创建caseReport 目录
if not os.path.exists(self.reportPath):
os.mkdir(self.reportPath)
self.reportDatePath = os.path.join(