python 遍历读写excel

# -*- coding:utf8

import xdrlib, sys
import xlrd
from zhudb import *
from zhu_outlets_class import *
from zhu_telecom_class import *
from datetime import datetime

def open_excel(file=u"D:\zhu\\project\\ots\\100个国外网站.xlsx"):
    data = xlrd.open_workbook(file)
    return data


# 根据索引获取Excel表格中的数据   参数:file：Excel文件路径     colnameindex：表头列名所在行的所以  ，by_index：表的索引
def excel_table_byindex(file=u"D:\zhu\\project\\ots\\100个国外网站.xlsx", colnameindex=0, by_index=0):
    data = open_excel(file)
    table = data.sheets()[by_index]
    nrows = table.nrows  # 行数
    ncols = table.ncols  # 列数
    colnames = table.row_values(colnameindex)  # 某一行数据
    listd = {}
    for rownum in range(1, nrows):
        row = table.row_values(rownum)
        if row:
            app = {}
            for i in range(len(colnames)):
                app[colnames[i]] = row[i]
            # list.append(app)
            listd[app[u"域名"]]=app
    return listd

def main():
    tables = excel_table_byindex()
    for rowkey in tables:
        print rowkey
        row=tables[rowkey]
        for onek in row:
            print "\t",onek,row[onek]

if __name__ == "__main__":
    main()