#!/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