【python】读取excel文件
#思路：就是先取出表头，然后for循环(len(表头数据长度))，以字典形式将表头和数据一一插入数据库import xlrd
def flask_OpenExcel(file='ceshi.xlsx'):
try:
data = xlrd.open_workbook(file)
return data
#print data
except Exception,e:
print str(e)
def excel_table_byindex(file = 'ceshi.xlsx',colnameindex=0,by_index=0):
data = flask_OpenExcel(file)
#获取表
table = data.sheets()
#获取行数和列数
nrows = table.nrows #行数
ncols = table.ncols #列数
#表.row_values()获取行数据,索引0代表表头
#表.col_values()获取列数据
colnames = table.row_values(colnameindex)#表头行数据
list = []
for rownum in range(1,nrows):
row = table.row_values(rownum)
if row:
app = {}
for i in range(len(colnames)):
app] = row
list.append(app)
return list
if __name__ == "__main__":
tables = excel_table_byindex()
for row in tables:
for key,value in row.items():
print "%s %s"%(key,value)
页:
[1]