python 将数据库表导出到EXCEL表格

from xlwt import *
import pymssql

workboot = Workbook(encoding='utf-8')
worksheet = workboot.add_sheet('my_sheet')
conn = pymssql.connect('localhost','sa','*****','*****')
if conn:
    print('succ')

cursor = conn.cursor()
sql = 'select top 1000 * from szmktj.dbo.peispatient'
cursor.execute(sql)
row = cursor.fetchone()
j = 0
while row:
    n = len(row)
    for i in range(0,n):
        worksheet.write(j,i,str(row[i]).encode('latin-1').decode('gbk'))
    j += 1
    row = cursor.fetchone()



workboot.save('date.xls')

cursor.close()
conn.close()