需求:
已设计好表头,读取mysql数据,填写数据到excel
环境:
python34
mysql 5.6
依赖模块:
pyexcel-xls
mysql-connector-python
# -*- coding: utf-8 -*-
from pyexcel_xls import save_data
from pyexcel_xls import get_data
from collections import OrderedDict
import mysql.connector
#和数据库建立连接
cnx =mysql.connector.connect(user='root', password='',
host='127.0.0.1',
database='test')
#查询语句
sql = "select my_name,my_value from tbl_members "
#执行查询