def data_split(self): data = DB.get_data() self.headers = data[0] del data[0] for line in data: if line[10] == None: self.geen_mail.append(line) elif '@' and '.' not in line[10]: self.geen_mail.append(line) elif line[6] == 'Niet gepland': self.niet_gepland.append(line) elif line[5] == 'privé': self.wel_gepland_prv.append(line) else : self.wel_gepland.append(line)
def init_table(self): self.setGeometry(530, 350, 1300, 800) self.data_list = DB.get_data() self.table = QtWidgets.QTableWidget(self) self.table.setRowCount(len(self.data_list)) self.table.setColumnCount(len(self.data_list[0])) hor_headers = window.Trans_Reader.headers self.table.setHorizontalHeaderLabels(hor_headers) self.data_to_table() self.table.resizeColumnsToContents() self.table.resizeRowsToContents() grid_box = QtWidgets.QVBoxLayout() grid_box.addWidget(self.table, 100) self.setLayout(grid_box)