摘要:
import openpyxl filename = 'aaa.xlsx' wb = openpyxl.load_workbook(filename) # 加载表格 wb.save("aaa.xlsx") sh_name = wb.sheetnames # 获取所有sheet sh = wb[sh_ 阅读全文
摘要:
# 设置单元格背景色from openpyxl import load_workbook from openpyxl.styles import PatternFill, colors excel_address = "openpyxl.xlsx" wb = load_workbook(excel_ 阅读全文