# -*- coding: utf-8 -*-
import xdrlib ,sys
import xlrd
def open_excel(file= 'abs.csv'):
try:
data = xlrd.open_workbook(file)
return data
except Exception,e:
print str(e)
def excel_table_byname(file= 'abs.csv', colnameindex=0, by_name=u'Sheet1'):
data = open_excel(file)
table = data.sheet_by_name(by_name)
nrows = table.nrows
colnames = table.row_values(colnameindex)
list =[]
for rownum in range(0, nrows):
row = table.row_values(rownum)
if row:
app = []
for i in range(len(colnames)):
app.append(row[i])
list.append(app)
return list
def main():
tables = excel_table_byname()
for row in tables:
print row
if __name__=="__main__":
main()
声明:本文为原创,作者为 对弈,转载时请保留本声明及附带文章链接:http://www.duiyi.xyz/c%e5%ae%9e%e7%8e%b0%e9%9b%b7%e9%9c%86%e6%88%98%e6%9c%ba-70/