import xlwt
#只能寫不能讀
stus = [['姓名', '年齡', '性別', '分數(shù)'],
    ['mary', 20, '女', 89.9],
    ['mary', 20, '女', 89.9],
    ['mary', 20, '女', 89.9],
    ['mary', 20, '女', 89.9]
    ]
book = xlwt.Workbook()#新建一個excel
sheet = book.add_sheet('case1_sheet')#添加一個sheet頁
row = 0#控制行
for stu in stus:
  col = 0#控制列
  for s in stu:#再循環(huán)里面list的值，每一列
    sheet.write(row,col,s)
    col+=1
  row+=1
book.save('stu_1.xls')#保存到當前目錄下

import xlrd
#只能讀不能寫
book = xlrd.open_workbook('stu.xls')#打開一個excel
sheet = book.sheet_by_index(0)#根據(jù)順序獲取sheet
sheet2 = book.sheet_by_name('case1_sheet')#根據(jù)sheet頁名字獲取sheet
print(sheet.cell(0,0).value)#指定行和列獲取數(shù)據(jù)
print(sheet.cell(0,1).value)
print(sheet.cell(0,2).value)
print(sheet.cell(0,3).value)
print(sheet.ncols)#獲取excel里面有多少列
print(sheet.nrows)#獲取excel里面有多少行
print(sheet.get_rows())#
for i in sheet.get_rows():
  print(i)#獲取每一行的數(shù)據(jù)
print(sheet.row_values(0))#獲取第一行
for i in range(sheet.nrows):#0 1 2 3 4 5
  print(sheet.row_values(i))#獲取第幾行的數(shù)據(jù)

print(sheet.col_values(1))#取第一列的數(shù)據(jù)
for i in range(sheet.ncols):
  print(sheet.col_values(i))#獲取第幾列的數(shù)據(jù)

from xlutils.copy import copy
import xlrd
#xlutils:修改excel
book1 = xlrd.open_workbook('stu.xls')
book2 = copy(book1)#拷貝一份原來的excel
# print(dir(book2))
sheet = book2.get_sheet(0)#獲取第幾個sheet頁，book2現(xiàn)在的是xlutils里的方法，不是xlrd的
sheet.write(1,3,0)
sheet.write(1,0,'hello')
book2.save('stu.xls')