from openpyxl import Workbook, load_workbook
import xlrd
小数据量
数据量小,并可以确定几列数据
def LittleWriteExcel(path, sheet_name):
wb = Workbook()
sheet = wb.active
sheet.title = sheet_name
raw_data = [["名称","重复度", "缺失值"]]
for row in raw_data:
sheet.append(row)
# 第2行的每个单元格写入对应数据
sheet.cell(row=2, column=1).value = "name_data"
sheet.cell(row=2, column=2).value = "repeated_data"
sheet.cell(row=2, column=3).value = " missing_data"
wb.save(path)
def LittleAddWriteExcel(path, data_dict, sheet_name):
wb = load_workbook(path)
workbook = xlrd.open_workbook(