class WriteThread(QtCore.QThread):
    '''
    工作线程，处理txt转xlsx
    '''
    _signal = pyqtSignal(int, str)

    def __init__(self, srcfiles, dstfiles, split, coding):
        super(WriteThread, self).__init__()
        self.srcfiles = srcfiles
        self.dstfiles = dstfiles
        self.split = split
        self.coding = coding

    def run(self):
        currentfile = ''
        try:
            for i in range(len(self.srcfiles)):
                currentfile = self.srcfiles[i]
                self.txt_to_xlsx(self.srcfiles[i], self.dstfiles[i], self.split, self.coding)
            self._signal.emit(0, "OK")
        except Exception as e:
            self._signal.emit(-1, currentfile + ':' + str(e))
    def txt_to_xlsx(self, filename, outfile, split, encoding):
        fr = codecs.open(filename, 'r', encoding=encoding)
        wb = openpyxl.Workbook()
        ws = wb.active
        row = 0
        for line in fr:
            row += 1
  #          line = line.strip() 2020年3月28号
            line = line.split(split)
            col = 0
            for j in range(len(line)):
                col += 1
                ws.cell(column=col, row=row, value=line[j])
        wb.save(outfile)