文章分类 -  python

python写入excel
摘要：import openpyxlbook = openpyxl.Workbook()sh = book.activesh.title = '工资表'sh1 = book.create_sheet('年龄表-最后')sh2 = book.create_sheet('年龄表-最后后')sh3 = book 阅读全文
posted @ 2021-10-04 16:47 佳佳不是熊猫 阅读(60) 评论(0) 推荐(0)
读取xlsx的sheet
摘要：import xlrdbook = xlrd.open_workbook("/Users/xmtxmt/tmp/ex01.xlsx")print(f"表单数量:{book.nsheets}")print(f"表单名称:{book.sheet_names()}")s1 = book.sheet_by_ 阅读全文
posted @ 2021-10-03 17:33 佳佳不是熊猫 阅读(121) 评论(0) 推荐(0)