遍历带有多个sheet的Excel表格

打开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