擅长:python、mysql、java
<p>在Xyrus的帮助下,这就是我如何让它工作的</p>
<pre><code>def export(self):
sql = "SELECT WellID,AFEno,AFEsuppno,AccountCode,AFEAmount FROM WellAFEDetails WHERE WellID = ?"
df = pd.read_sql_query(sql,self.con, params=([self.wellid_bx.get()]))
writer = pd.ExcelWriter (r'C:\Users\bjenks\Desktop\ExcelOut.xlsx')
df.to_excel(writer, sheet_name='bar')
writer.save()
</code></pre>