Excel解析到数据库

def excel_insert_data():
    for files in os.listdir(path):
        print(files)
        # if os.path.splitext(files)[1] == '.xls' or os.path.splitext(files)[1] == '.xlsx':
        try:
            book = xlrd.open_workbook(path + '/' + files)
            sheet = book.sheet_by_index(0)
            tables = ['sequence_number', 'drug_name', 'enterprise', 'batch_number', 'specification',
                      'source', 'standard', 'result', 'defective_item', 'certification_body', 'placeholder1',
                      'placeholder2', 'placeholder3', 'placeholder4', 'placeholder5', 'placeholder6', 'placeholder7',
                      'placeholder8', 'placeholder9', 'placeholder10', 'placeholder11', 'placeholder12',
                      'placeholder13',
                      'placeholder14', 'placeholder15', 'placeholder16', 'placeholder17', 'placeholder18']
            table_jsda = ', '.join(tables[0: sheet.ncols])
            values_s = ', '.join(['%s'] * sheet.ncols)
            # 创建一个for循环迭代祛除xls文件每行数据,从第四行开始是要跳过标题
            for rx in range(1, sheet.nrows):
                values = []
                for ncol in range(0, sheet.ncols):
                    values.append(sheet.cell(rx, ncol).value)
                sql_query = 'insert into jsda(%s) values(%s)' % (table_jsda, values_s)
                cursor.execute(sql_query, values)
        except Exception as e:
            print(e)