import openpyxl
import os
book = openpyxl.load_workbook('d:\\data\\test.xlsx')
sht = book.active
for row in sht.rows:
    name = row[0].value