第一部分:根据文件生成txt文件(主体)
import win32ui
import xlrd
import time
now = time.strftime("%Y%m%d",time.localtime(time.time()))
class ExcelToSql1():
def __init__(self,file_name,sheet_name,table_name):
self.file_name = file_name
self.sheet_name = sheet_name
self.table_name = table_name
self.excel_title = None
self.excel_data = []
def read_excel(self):
# 打开excel文件
work_book = xlrd.open_workbook(self.file_name)
# 读取sheet文件
content = work_book.sheet_by_name(self.sheet_name)
# 读取第一行数据
self.excel_title = content.row_values(0)
for row in range(content.nrows-1):
# 从第二行开始读数据
self.excel_data.append(list(str(val) for val in content.row_values(row+1)))
def to_sql(self):
sql1 = "INSERT INTO %s (%s)"%(self.table_name,",".join(self.excel_title))#可写死
f = open('新-'