1: 安装xlrd----python2.5选择对应版本 (不支持excel2007以上,另存为xls就可以)
#!/usr/bin/python
# -*- coding: UTF-8 -*-
import os
import MySQLdb
import simplejson
from datetime import date, datetime, time
import sys
import xlrd
import xdrlib
#读取execle表格
def open_execel(fileName):
try:
data = xlrd.open_workbook(fileName)
return data
except Exception,e:
print str(e)
#读取execle表格数据到数据库
def addDataToDB(data):
s = data.sheet_by_index(5) #读取第6个sheet
for row in range(1, s.nrows):
if not s.cell(row,0).value:
break
value=xlrd.xldate_as_tuple(s.cell(row,0).value, data.datemode) #日期格式
date = datetime(*value)
uv= s.cell(row, 1).value
mau = s.cell(row, 2).value
dayNewReg = s.cell(row, 3).value
avgOret = s.cell(row, 4).value
avgSret = s.cell(row, 5).value
mNewAdd = s.cell(row, 6).value
cmReg = s.cell(row,7).value
if not uv:
uv = 0
if not mau:
mau = 0
if not dayNewReg:
dayNewReg=0
if not avgOret:
avgOret = float("%.3f"%0.000)
if not avgSret:
avgSret = float("%.3f"%0.000)
if not mNewAdd:
mNewAdd= 0
if not cmReg:
cmReg = 0