python把数据写入excel_【IT专家】python将数据写入excel代码,python与office交互

本文由我司收集整编，推荐下载，如有疑问，请与我司联系

python

将数据写入

excel

代码，

python

与

office

交互

2017/08/10

0

#

-*-

coding:

utf-8

-*-from

smartframe.header

import

*import

pymysqlimport

jsonimport

importlib,sysimportlib.reload(sys)import

reimport

xlwtfrom

xlwt

import

Workbook,

Formulaimport

xlrd##

连接数据库

conn

=pymysql.connect(host=‘127.0.0.1’,port=3306,user=‘root’,passwd=‘root’,db=‘XXXX’,ch

arset=‘utf8’)#

创建游标

#

#

游标设置为字典类型

cursor

=

conn.cursor(cursor=pymysql.cursors.DictCursor)#

执行

sql

，并返回受到的影响行数

######sql=‘select

*

from

ceshi’cursor.execute(sql)#

获取所有数据

########result

=

cursor.fetchall()#

获取获取第一条数据

######result

=

cursor.fetchone()#print(result)#print

(len(result))datanew

=

{}for

item

in

result:#print(item)datanew[item[‘user_id’]]

=

list(eval(item[‘answer’]))#print(datanew)book

=

Workbook()sheet1

=

book.add_sheet(‘Sheet

1’)#

字典数据

#

循环字典

key

的值

num

=

[a

for

a

in

datanew]

#num1=[]#for

a

in

datax:#

print

(a)#if

a

not

in

num1:#num1.append(a)#num.sort()#print(num)lennum=len(num)#print(lennum)for

a

in

range(lennum):#print(num[a])lena=len(datanew[num[a]]);#print(lena)lena1=datanew[num

[a]];lena1.sort()#print(lena1)a1=num[a];sheet1.write(a+1,0,a1)#print(lenanew)b1x=[]for

b

in

range(lena):#print(b)#print

(lena1[b]);#print((lena1[b])[0])#print((lena1[b])[1])b1=(lena1[b])[0]b2=(lena1[b])[1]b1x.a

ppend(b1);#print(b)sheet1.write(a+1,b+1,b2)#print(b2)if

a==0:#print(b1x)for

y

in

range

(len(b1x)):bx=b1x[y]#print(b1x[y])#print(y)sheet1.write(0,y+1,bx)

book.save(‘C:/Users/Administrator/Desktop/ceshi0_1.xls’)connmit()#

获取自增

idnew_id

= cursor.lastrowid print (new_id)#

关闭游标

cursor.close()#

关闭连接

conn.close()

tips:

感谢大家的阅读，本文由我司收集整编。仅供参阅！