def upload_excel():
# excel_path = '/usr/local/nginx/html/zhouwei/app/static/' # 服务器路径
excel_path = '/Users/xiaomao/PycharmProjects/zhouwei/app/static/' # localhost 路径
excel = request.files['excel']
excel_name = secure_filename(excel.filename)
excel.save(os.path.join(excel_path, excel_name))
from excel import open_excel
data = open_excel(file='/Users/xiaomao/PycharmProjects/zhouwei/app/static/%s' % excel_name)
table = data.sheets()[0]
nrows = table.nrows
# ncols = table.ncols
datas = []
for i in range(nrows):
rs = table.row_values(i)
datas.append(rs)
for email_list in datas:
email_db = ZwMySQL()
name = email_list[0]
email = email_list[1]
belong = email_list[2]
try:
email_db.add_email(name, email, belong, '')
flash('add success')
except Exception as e:
flash('add %s error' % email)
app.logger.error("add %s error %s" % (email, e))
return render_template('upload_excel.html',
url='upload_email',
user='******',
per_act='active',
datas=datas,
person_no=len(datas))
def add_email():
name = request.form.get('name')
email = request.form.get('email')
belong = request.form.get('belong')
type = request.form.get('type')
email_db = ZwMySQL()
email_db.add_email(name, email, belong, type)
return redirect(url_for('periodical'))
