import xlrd,xlwt

data = xlrd.open_workbook(‘a.xlsx‘)   #读
table = data.sheets()[0]
data_list = []
data_list.extend(table.row_values(0))
for item in data_list:
    print item
#################
#   写
data =http://www.mamicode.com/ xlwt.Workbook()
table = data.add_sheet(‘b‘)
table.write(0, 1, ‘01‘)
table.write(0, 2, ‘www‘)
data.save(‘b.xls‘)