mysql 与 excel

最新推荐文章于 2023-09-02 12:58:22 发布

unique碎

最新推荐文章于 2023-09-02 12:58:22 发布

阅读量587

点赞数

分类专栏： python项目文章标签： python

python项目专栏收录该内容

12 篇文章 0 订阅

订阅专栏

mysql：http://www.cnblogs.com/W-Kr/p/5456810.html


conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', password='root', db='txj', charset='utf8')
with conn.cursor() as cursor:
    sql = "select * from free"
    cursor.execute(sql)
    # fetchall取出所有数据，fetchmany(5)取出前5条数据，fetchone()取出第一条数据
    result = cursor.fetchall()
conn.close()

excel：读：http://www.cnblogs.com/lhj588/archive/2012/01/06/2314181.html
写：http://www.jb51.net/article/77626.htm

import xlwt
workbook = xlwt.Workbook()
sheet = workbook.add_sheet('sheet1', cell_overwrite_ok=True)
# init excel
sheet.write(0,1,'周一')
sheet.write(0,1,'周二')
sheet.write(0,1,'周三')
sheet.write(0,1,'周四')
sheet.write(0,1,'周五')
workbook.save('free.xls')