摘要:
import openpyxl filename = 'aaa.xlsx' wb = openpyxl.load_workbook(filename) # 加载表格 wb.save("aaa.xlsx") sh_name = wb.sheetnames # 获取所有sheet sh = wb[sh_ 阅读全文
posted @ 2020-03-15 22:01
__夕颜
阅读(9301)
评论(0)
推荐(0)
摘要:
# 设置单元格背景色from openpyxl import load_workbook from openpyxl.styles import PatternFill, colors excel_address = "openpyxl.xlsx" wb = load_workbook(excel_ 阅读全文
posted @ 2020-03-15 20:40
__夕颜
阅读(5329)
评论(0)
推荐(0)
浙公网安备 33010602011771号