Python操作excel

# import xlrd
# book = xlrd.open_workbook("test.xls")
# # sheet  = book.sheet_by_name("sheet1")
# sheet  = book.sheet_by_index(0)
# # book.sheets()  #获取所有sheet页
# print(sheet.cell(0,0).value) #获取某一个单元格的内容
# print(sheet.row_values(0)) #获取整行的数据
# print(sheet.col_values(0)) #获取整列的数据
# print(sheet.nrows) #总共多少行
# print(sheet.ncols) #总共多少列

    xlrd只能读
    xlwt只能写
    xlutils只能修改
    写的时候不能超过65536行
    xls、xlsx

openpyxl
    必须得是xlsx这种的excel
     import openpyxl

    book = openpyxl.load_workbook("test2.xlsx")

    sheet = book["Sheet1"]
    # print(book.sheetnames) #所有sheet页的名字

    # for row in sheet.rows: #获取每行的数据
    #     row_data = [col.value for col in row]
    #     print(row_data)


    # print(sheet.max_row) #多少行
    # print(sheet.max_column) #多少列
    sheet.cell(1,1).value = "id"
    # print(dir(sheet))
    # print(sheet["A1"].value)
    # print(sheet["A2"].value)
    # sheet["A1"] = "编号"
    book.save("test2.xlsx")