python读取xls文件

#!/usr/bin/python

#-*-coding:utf-8-*-

import tg

import xlrd

bk = xlrd.open_workbook("data.xlsx")

try:

    sh = bk.sheet_by_index(0)

except:

    print 'no excel'

nrows = sh.nrows

reader = []

for i in range(nrows):

    row_data = sh.row_values(i)

    reader.append(row_data)

res = []

allfee = 0.00

for r in reader:

    f = 0.00

    try:

        f = float(r[4])

    except:

        pass

    allfee += f

    res.append({'a':r[10], 'b':r[1]})

print allfee