1 import MySQLdb 2 import xlwt 3 def outMySQL(file_name): 4 wb = xlwt.Workbook() 5 sh = wb.add_sheet('sheet 1',cell_overwrite_ok=True) 6 7 db = MySQLdb.connect("localhost","root","123","STUDENTS",use_unicode=1,charset='utf8') 8 cursor = db.cursor() 9 10 sql = '''SELECT * FROM STUDENTS '''11 12 cursor.execute(sql)13 data = cursor.fetchall()14 value = cursor.description15 rows = len(data)16 cols = len(map(list,zip(*data)))17 for v in range(0,len(value)):18 sh.write(0,v,value[v][0])19 for i in range(1,rows+1):20 for j in range(0,cols):21 sh.write(i,j,data[i-1][j])22 wb.save(file_name)23 cursor.close()24 db.commit()25 db.close()26 if __name__=="__main__":27 outMySQL('/home/wangzhch/excel.xls');