打开excel
import xlrd
file_path = './mutil_intent.xlsx'
open_file = xlrd.open_workbook(file_path)
sheets = open_file.sheet_names()
遍历所有的sheet
for i in range(len(sheets)):
print i
each_sheet = open_file.sheet_by_index(i)
rows = each_sheet.nrows
for row in range(rows):
for query in each_sheet.cell_value(row, 4).split('\n'):
print query