#coding :utf-8
import time
import xlsxwriter
import xlrd
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_write(self,msg):
self.log.write(msg)
def log_close(self):
self.log.close()
def log_init(self, sheetname, *title):
pass
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+'.xls')
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)
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__':
'''
log = Loginfo()
log.log_write('test Loginfo 测试')
log.log_close()
'''
xinfo = xlloginfo()
xinfo.log_init('test', 'uname', 'pwd', 'result', 'info')
xinfo.log_write('123', '123', 'Error', 'error')
xinfo.xl.close()