openpyxl 根据字母获取指定列的值为列表

file_path = 'xxx.xlsx'
sheet_name = 'xxx'
wb = load_workbook(file_path)
self.ws = wb[sheet_name]
self.frist_col_values = [i.value for i in self.ws['A']]
self.second_col_values = [i.value for i in self.ws['B']]