各位大佬，咨詢一個問題：使用Python 提取數(shù)據(jù)庫中數(shù)據(jù) 并錄入excel 指定也簽下的指定單元格。當(dāng)前，操縱數(shù)據(jù)庫，提取信息，等等步驟都沒有問題，但是最后一步出問題了： 數(shù)據(jù)無法正常寫入到excel中（excel中不顯示）如圖：我的代碼如下，請求大神指點啊import?pymysql import?tkinter import?os import?openpyxl from?tkinter?import?* import?time def?newcreated():?##?用來提取數(shù)據(jù) ????conn?=?pymysql.connect(host='localhost',user='root',passwd='QAZwsx12345678',db='test',port=3306,charset='utf8') ????cur?=?conn.cursor() ????cur.execute("use?test") ????cur.execute("SELECT?SUM(sql_data.`總價`)?FROM?sql_data?WHERE?sql_data.`銷售區(qū)域`=?'東大區(qū)'") ????a?=?cur.fetchall() ????time.sleep(0.2) ????cur.execute("SELECT?SUM(sql_data.`總價`)?FROM?sql_data?WHERE?sql_data.`銷售區(qū)域`=?'西大區(qū)'") ????b?=?cur.fetchall() ????time.sleep(0.2) ????cur.execute("SELECT?SUM(sql_data.`總價`)?FROM?sql_data?WHERE?sql_data.`銷售區(qū)域`=?'南大區(qū)'") ????c?=?cur.fetchall() ????cur.execute("SELECT?SUM(sql_data.`總價`)?FROM?sql_data?WHERE?sql_data.`銷售區(qū)域`=?'北大區(qū)'") ????d?=?cur.fetchall() ????#b?=?a.__str__() ????cur.close() ????conn.close ????return?a,b,c,d?##返回b的值 t?=?tuple(newcreated()) #print(t) class?control?: ??def?__init__(self,?master):?##用來建造GUI?控制界面 ????fm1?=?Frame(master) ????Button(fm1,?text='生成數(shù)據(jù)',command?=?self.exc).pack(side=TOP,?anchor=W,?fill=X,?expand=NO,padx?=?10,?pady?=?10,ipadx=10,ipady?=?4) ????fm1.pack(side=LEFT,?fill=BOTH,?expand=YES) ??def?exc(self):??##用來提取表格，并對表格進(jìn)行賦值的 ????wb?=?openpyxl.load_workbook('C:/Users/lenovo/Desktop/小小科技/show_6.15/6_15/show_6_15.xlsx') ????sheet?=?wb.get_sheet_by_name('頁簽1') ????sheet['C4']?=?t?[0][0][0] ????sheet['C5']?=?t?[1][0][0] ????sheet['C6']?=?t?[2][0][0] ????sheet['C7']?=?t?[3][0][0] ????print(sheet['C4'].value) ????print(sheet['C5'].value) ????print(sheet['C6'].value) ????print(sheet['C7'].value) ????wb.save('show_6_15.xlsx') root?=?Tk() root.title("Control") display?=?control(root) root.mainloop()