def combo_box_change(self, row, col, text):
item = QTableWidgetItem(text)
self.ui.tableWidget.setItem(row, col, item)
changedata = self.ui.tableWidget.item(row,col).text()
print(self.ui.tableWidget.item(row,col).text())
print(changedata)
print(row)
print(col)
data = pd.read_csv(open_path, dtype={'Num': str})
self.ui.tableWidget.setColumnCount(data.shape[1])
self.ui.tableWidget.setRowCount(data.shape[0])
for i in range(data.shape[0]):
for j in range(data.shape[1]):
# self.ui.tableWidget.setItem(i, j, QTableWidgetItem(str(data.iloc[i, j])))
infosss = self.ui.tableWidget.item(i, j).text()
# print(infosss)
data.iat[i, j] = infosss
# a = self.ui.tableWidget.item(31, 10).text()
# print(a)
data.to_csv(save_path, encoding='utf-8', index=False)
# QMessageBox.information(self, '提示', 'Save Successfully')
self.reload_all_infos()
# print(item)
def show_info(self):
data = pd.read_csv(open_path, dtype = {'Num':str})
self.ui.tableWidget.setColumnCount(data.shape[1])
self.ui.tableWidget.setRowCount(data.shape[0])
for i in range(data.shape[0]):
for j in range(data.shape[1]):
item = QTableWidgetItem(str(data.iloc[i, j]))
self.ui.tableWidget.setItem(i, j, item)
if j == 2:
a=i
b=j
infosss = self.ui.tableWidget.item(i, j).text()
items1 = ["Service", "AmazeFP", "AmazeSys-Physical", "Tweaker", "AmazeDRCLite", "IndustrialLM", " "]
p = items1.index(infosss)
self.combo_box = CustomComboBox(self)
self.combo_box.addItems(items1)
self.combo_box.setCurrentIndex(p)
self.ui.tableWidget.setCellWidget(i, j, self.combo_box)
text = self.combo_box.currentText()
self.combo_box.currentTextChanged.connect(lambda text, row=a, col=b: self.combo_box_change(a, b, text))
# print(self.ui.tableWidget.item(i, j).text())
if j == 3:
infosss = self.ui.tableWidget.item(i, j).text()
items2 = ["Kick-off", "Accomplished", "On going", "Not Started", " "]
p = items2.index(infosss)
self.combo_box2 = CustomComboBox(self)
self.combo_box2.addItems(items2)
self.combo_box2.setCurrentIndex(p)
self.ui.tableWidget.setCellWidget(i, j, self.combo_box2)
# self.combo_box.currentTextChanged['QString'].connect(lambda: self.combo_box_change())
choose_infos3 = self.combo_box2.currentText()
# print(choose_infos3)
# self.ui.tableWidget.setItem(i, j, QTableWidgetItem(str(choose_infos3)))
# print(self.ui.tableWidget.item(i, j).text())
if j == 4:
infosss = self.ui.tableWidget.item(i, j).text()
items3 = ["Normal", "Good", "Need Attention", "Not Good", "-", " "]
p = items3.index(infosss)
self.combo_box3 = CustomComboBox(self)
self.combo_box3.addItems(items3)
self.combo_box3.setCurrentIndex(p)
self.ui.tableWidget.setCellWidget(i, j, self.combo_box3)
choose_infos4 = self.combo_box3.currentText()
# self.ui.tableWidget.setItem(i, j, QTableWidgetItem(str(choose_infos4)))
# for i in range(data.shape[0]):
# for j in range(data.shape[1]):
# self.ui.tableWidget.setItem(i, j, QTableWidgetItem(str(data.iloc[i, j])))
# box_info = self.combo_box.currentText()
# print(box_info)
# 展示列表行索引
self.ui.tableWidget.setHorizontalHeaderLabels(data.columns)