我正在try 将数据从QTableWidget传递到Excel.为什么Excel中只写入表的最后一行?(打印时,显示完整的表格).
rowCount = self.QTableWidget.rowCount()
columnCount = 5
for row in range(rowCount):
rowData = []
for column in range(columnCount):
widgetItem = self.QTableWidget.item(row, column)
if widgetItem and widgetItem.text:
rowData.append(widgetItem.text())
else:
rowData.append('NULL')
print(rowData)
df = pd.DataFrame(columns=rowData)
df.to_excel('Table.xlsx', index=False)