python从excel读取数据显示_Python从excel读取数据抛出

我试图用xlrd模块从excel文件中读取日期。下面是我的代码：# Variables

myfile = '/home/mobaxterm/.git/Operation_Documentation/docs/Servicing Portal User & Certificate Inventory.xlsx'

mydate = 'Expiration Date'

row_head = 0

# Import required modules

import xlrd

import datetime

today = datetime.date.today()

book = xlrd.open_workbook(myfile)

sheet = book.sheet_by_index(1)

for col_index in range(sheet.ncols):

print xlrd.cellname(row_head,col_index),"-",

print sheet.cell(row_head,col_index).value

if sheet.cell(row_head,col_index).value == mydate:

for raw_index in range(sheet.nrows):

expire = sheet.cell(raw_index,col_index).value

print expire

expire_date = datetime.datetime(*xlrd.xldate_as_tuple(expire, book.datemode))

print 'datetime: %s' % expire_date

break

运行代码时，出现以下错误：

^{pr2}$

有人能告诉我这里的问题是什么吗？在

谢谢你的时间。在