python学习笔记（10）xlrd+xlwt+base64，读取excel内容，获取base64码，生成xls文件

import base64
import xlrd
import xlwt

path1=r"C:\Users\xiazhang9\Desktop\用户.xlsx"
path2=r"C:\Users\xiazhang9\Desktop\yonghu.xls"


#获取base64码
def base(name):
    a=base64.b64encode(name.encode("utf-8"))
    return str(a,"utf-8")

base("1")
def readEcl(path1,path2):
    book=xlrd.open_workbook(path1)
    sheet=book.sheet_by_index(0)
    cols=sheet.col_values(0)
    cols=list(set(cols))

    book = xlwt.Workbook(encoding="utf-8")
    sheet = book.add_sheet("name")
    for i in range(0, len(cols)):
        base(cols[i])
        sheet.write(i, 0, base(cols[i]))
    book.save(path2)


readEcl(path1,path2)