数据字典情况如下
代码如下
import openpyxl,pprint
import os
wb = openpyxl.load_workbook(r'C:\Users\044572\Desktop\数据字典.xlsx')
sqlfile = r'C:\Users\044572\Desktop\DDL.txt'
# remove if exists sqlfile
if os.path.exists(sqlfile):
os.remove(sqlfile)
ws = wb['数据字典-1'] #specify worksheet name
max_row = ws.max_row
for row in range(2,max_row+1): #first row from row2
table_name = ws['B'+str(row)].value #表名获取在B列
col_name = ws['E'+str(row)].value
col_type = ws['F'+str(row)].value
# print(ws['H'+str(row)].value)
#精度 decimal(10,2) varchar(100)
col_int = ws['G'+str(row)].value #
col_small = ws['H'+str(row)].value #
if ws['H'+str(row)].v