|
|
发表于 2016-1-23 13:18:13
|
显示全部楼层
- #coding:utf-8
- import time
- import xlsxwriter
- class Loginfo(object):
- def __init__(self, path = '', mode = 'w'):
- fname = path + time.strftime('%Y-%m-%d', time.gmtime())
- self.log = open(path + fname + '.txt', mode)
- def log_init(self, sheetname, *title):
- pass
- def log_write(self, msg):
- self.log.write(msg)
- def log_close(self):
- self.log.close()
- class Xlloginfo(object):
- def __init__(self, path=''):
- fname = path + time.strftime('%Y-%m-%d', time.gmtime())
- self.row = 0
- self.xl = xlsxwriter.Workbook(path+fname+'.xlsx')
- self.style = self.xl.add_format({'bg_color':'red'})
- def xl_write(self, *args):
- col = 0
- style =''
- if 'Error' in args:
- style = self.style
- for val in args:
- self.sheet.write_string(self.row, col, val, style)
- col += 1
- self.row+=1
- def log_init(self, sheetname, *title):
- self.sheet = self.xl.add_worksheet(sheetname)
- self.sheet.set_column('A:E', 30)
- self.xl_write(*title)
- def log_write(self, *args):
- self.xl_write(*args)
- def log_close(self):
- self.xl.close()
- if __name__ == '__main__':
- xinfo = Xlloginfo()
- xinfo.log_init('test', 'uname', 'pwd', 'result', 'info')
- xinfo.log_write('123', '123', 'Error', 'error')
- xinfo.log_close()
复制代码 |
评分
-
查看全部评分
|