# -*- conding:utf-8 -*-__author__ = 'mayi'#How to write to an Excel using xlwt moduleimport xlwt#創(chuàng)建一個(gè)Wordbook對(duì)象，相當(dāng)于創(chuàng)建了一個(gè)Excel文件book = xlwt.Workbook(encoding = "utf-8", style_compression = 0)#創(chuàng)建一個(gè)sheet對(duì)象，一個(gè)sheet對(duì)象對(duì)應(yīng)Excel文件中的一張表格sheet = book.add_sheet("sheet1", cell_overwrite_ok = True)#向表sheet1中添加數(shù)據(jù)sheet.write(0, 0, "EnglishName") #其中，"0, 0"指定表中的單元格，"EnglishName"是向該單元格中寫(xiě)入的內(nèi)容sheet.write(1, 0, "MaYi")sheet.write(0, 1, "中文名字")sheet.write(1, 1, "螞蟻")#最后，將以上操作保存到指定的Excel文件中book.save("name.xls")

# -*- conding:utf-8 -*-__author__ = 'mayi'# How to read from an Excel using xlrd moduleimport xlrd# 打開(kāi)指定路徑中的xls文件，得到book對(duì)象xls_file = "name.xls"#打開(kāi)指定文件book = xlrd.open_workbook(xls_file)# 通過(guò)sheet索引獲得sheet對(duì)象sheet1 = book.sheet_by_index(0)# # 獲得指定索引的sheet名# sheet1_name = book.sheet_names()[0]# print(sheet1_name)# # 通過(guò)sheet名字獲得sheet對(duì)象# sheet1 = book.sheet_by_name(sheet1_name)# 獲得行數(shù)和列數(shù)# 總行數(shù)nrows = sheet1.nrows#總列數(shù)ncols = sheet1.ncols# 遍歷打印表中的內(nèi)容for i in range(nrows):  for j in range(ncols):    cell_value = sheet1.cell_value(i, j)    print(cell_value, end = "/t")  print("")