python连接Navicat线上数据库并将excel表格中的内容导入进去
import time
import pymysql
import xlrd
# 连接数据库
try:
#financial为数据库名
db = pymysql.connect(host='xxx', port=3306, user='xxx', password='xxx', db='financial')
except:
print("could not connect to mysql server")
# 打开excel表格
def open_excel():
try:
# file_path为路径
current_time = time.strftime('%Y-%m-%d', time.localtime()