python 利用openpyxl读取Excel表格中指定的行或列教程

table = xlrd.open("path_to_your_excel", 'rb')

try：
  table = xlrd.open("path_to_your_excel", 'rb')
except Exception, e
  print str(e)

sheet1 = table.sheet()[1] or
sheet1 = table.sheet_by_index() or
sheet1 ＝table.sheet_by_name("sheetname")

nrow_value = sheet.row_values(number)

ncol_value = sheet.col_values(number)

data_list = []
title = sheet.row_values(0)
for i in range(1, sheet.nrows):       
  data_values = OrderedDict()
  row_value = sheet.row_values(i)
#从第二行开始遍历，根据行数获得每行的数据list
for j in range(0, len(row_value)):    
  data_values[title[j]] = row_value[j]
print ([title[j]], row_value[j])data_list.append(data_values)
# result = json.dumps(data_list)
#需要转化成为json格式
return data_list