def list_dict(list_data):
  dict_data = {}
  for i in list_data:
    key, = i
    value, = i.values()
    dict_data[key] = value
  return dict_data


if __name__ == '__main__':
  list_data = [{'aa': 'aa'},
         {'bb': 'bb'},
         {'cc': 'cc'},
         {'dd': 'dd'}]
  print list_dict(list_data)

#coding=utf8
from selenium import webdriver
import xlrd,os 
 
dirname = os.path.dirname(os.path.dirname(__file__))
#join時，第二參數(shù)首位不能加/，加r的意思是原生字符串
filename = os.path.join(dirname,r'testdata/select_school.xlsx')
 
#row,col獲取哪行那列的值
def run_select_shool(row=1,col=1):
  #打開excel文件讀取數(shù)據(jù)
  data = xlrd.open_workbook(filename)
  table = data.sheet_by_index(0)
 
  row = row-1
  col = col-1
  #獲取整行整列的值
  nrows = table.row_values(row)
  ncols = table.col_values(0)
  print(nrows[col])
 
def run_select_school2(filename,sheet_index=0,table_header_row=0):
  # 打開excel文件讀取數(shù)據(jù)
  data = xlrd.open_workbook(filename)
  table = data.sheet_by_index(sheet_index)
  nrows = table.nrows
  nclos = table.ncols
 
  #獲取表頭行的信息，為一個列表
  header_row_data = table.row_values(table_header_row)
  #將每行的信息放入一個字典，再將字典放入一個列表中
  list = []
  for rownum in range(1,nrows):
    rowdata = table.row_values(rownum)
    #如果rowdata有值，
    if rowdata:
      dict = {}
      for j in range(0,len(header_row_data)):
        #將excel中的數(shù)據(jù)分別設(shè)置成鍵值對的形式，放入字典，如‘標題'：‘name'；
        dict[header_row_data[j]] = rowdata[j]
      list.append(dict)
  print(list)
  return list 
 
run_select_school2(filename)