【Python】-- 文件的读写操作(解决‘utf-8‘ codec can‘t decode byte 0xce in position 0: invalid continuation byte)

本文介绍了如何使用Python的open函数进行文件的打开、创建,以及不同方法如read(), readline(), readlines()读取文件内容。同时讲解了write()和seek()的用法,以及编码问题在文件操作中的注意事项。

一、文件的打开/创建

open()

使用open函数,可以打开一个已经存在的文件,或者创建一个新文件。

语法:open(name,mode,encoding)

其中,name:是要打开的目标文件名的字符串;

          mode:设置打开文件的模式:只读、写入、追加等;

          encoding:编码格式

mode模式描述
r以只读的方式打开文件,文件的指针将会放在文件的开头,这是默认模式。
w打开一个文件只用于写入,如果该文件已存在则打开文件,并从头开始编辑,原有内容会被删除。如果文件不存在,则创建新文件。
a打开一个文件追加内容,如果不存在,则创建并写入。

例:

f = open("D:/1.txt","r",encoding="UTF-8")

二、文件的读取

文件读取有三种方法:

  • read():读取整个文件的内容保存为字符串;
  • readline():逐行读取文件保存为字符串;
  • readlines():读取整个文件内容保存为列表。

1、read()

语法:文件对象.read(num)

其中,num表示从文件中读取的数据的长度(单位字节),没有传入则表示读取所有数据。

例:

f = open("D:/save_date.txt","r",encoding="UTF-8")
print(f.read(10))
print(f.read())
f.close # 关闭文件

2、 readline()

可以按照行的方式把文件中的内容进行一行读取,并且返回一个字符串。

3、readlines()

可以按照行的方式把整个文件中的内容进行一次性读取,并且返回一个列表,其中每一行的数据是一个元素。

例:

f = open("D:/save_date.txt","r",encoding="UTF-8")
print(f.readline())# 一次读取一行内容
print(f.readlines())
f.close # 关闭文件

4、with open

自动关闭文件。

语法:with open(name,mode,encoding)as f:

例:

with open("D:/save_date.txt","r",encoding="UTF-8") as f:
    for line in f:
        print(line)

三、文件的写入

write()

语法:文件对象.write()

直接调用write,内容并未真正写入文件,而是会积攒在内存中,称为缓冲区;

当调用flush方法的时候,内容会真正写入文件。

例:

f = open("D:/save_date.txt","w",encoding="UTF-8")
f.write("111")
f.flush()
f.close()

四、seek()方法

语法:文件对象.seek(offset,whence)

参数offset表示文件指针移动的偏移量,可选参数whence表示从哪个位置移动文件指针:

  • whence=0,表示从文件起始位置移动
  • whence=1,表示从当前位置移动
  • whence=2,表示从文件结尾处移动

whence的默认值是0,即文件指针默认从文件起始位置移动。因此seek(0)表示将文件指针移动到文件起始位置,seek(0,2)表示文件指针移动到文件结尾处。注意当以文本文件模式“t”打开文件时,只能从文件开头移动指针,即whence必须为0

提示:汉字偏移量为2

五、注意

  • 写入文件不说明编码格式则文件内容汉字乱码,而读文件说明编码格式报错
  • 写入文件不说明编码格式则文件内容汉字乱码,读文件也不说明编码格式正常读出
  • 写入文件说明编码格式则文件内容正常,读文件也不说明编码格式乱码读出
  • 写入文件说明编码格式则文件内容正常,而读文件说明编码格式正常读出
  • 手动创建文件输入内容,而读文件不说明编码格式则乱码读出
  • 手动创建文件输入内容,读文件说明编码格式则正常读出

例:

#手动创建2.txt,加编码格式正常读出
file = "2.txt"
f = open(file,'r',encoding="UTF-8")
line = f.read()
print(line)
f.close()
//写入文件没有说明编码格式,而读取文件说明了,则报错
file = "3.txt"
f = open(file,'w')
f.write("我爱1")
f.close()
f = open(file,'r',encoding="UTF-8")
line = f.read()
print(line)
f.close()

报错内容:'utf-8' codec can't decode byte 0xce in position 0: invalid continuation byte 


#!/usr/bin/env python # -*- coding: utf-8 -*- import os import re import sys import argparse import xlwt from collections import defaultdict # 分区名称映射表(前缀 → 友好名称) PARTITION_NAME_MAP = { '02_': 'system', '03_': 'vendor', '04_': 'product', '05_': 'odm', '06_': 'my_product', '07_': 'my_engineering', '08_': 'my_stock', '09_': 'my_heytap', '10_': 'my_company', '11_': 'my_carrier', '12_': 'my_region', '13_': 'my_preload', '14_': 'data', '15_': 'my_bigball', '16_': 'my_manifest', '17_system_dlkm': 'system_dlkm', '17_vendor_dlkm': 'vendor_dlkm', '17_cache': 'cache', '18_': 'system_ext' } def parse_du_file(file_path): """解析du命令输出文件并转换为MB""" data = {} try: with open(file_path, 'r') as f: for line in f: if 'Permission denied' in line or 'No such file' in line or not line.strip(): continue match = re.match(r'(\d+\.?\d*)\s*([KMG]?)[Bb]?\s+(.*)', line.strip()) if match: size, unit, path = match.groups() size = float(size) # 单位转换到MB if unit == 'K': size = size / 1024.0 elif unit == '': size = size / (1024 * 1024.0) elif unit == 'M': pass elif unit == 'G': size = size * 1024.0 data[path] = round(size, 4) except IOError as e: print("警告: 无法读取文件 {}: {}".format(file_path, str(e))) return data def extract_file_prefix(filename): """提取文件前缀""" if filename.startswith('17_'): return filename.replace('.txt', '') match = re.match(r'^(\d+_)', filename) return match.group(1) if match else "other_" def is_main_partition_file(filename, prefix): """检查是否为主分区文件""" if prefix.startswith('17_'): return True expected_name = prefix + PARTITION_NAME_MAP[prefix] + ".txt" return filename == expected_name def parse_lpdump_file(file_path): """解析 lpdump 输出文件,获取各分区大小和super物理分区大小""" sector_size = 512 # 每个扇区大小为 512 字节 partition_sizes = {} try: with open(file_path, 'r') as f: lines = f.readlines() in_super_layout = False super_find =False super_size = 0.0 # 初始化super物理分区大小 for line in lines: if "Super partition layout:" in line: in_super_layout = True continue if not in_super_layout or not line.strip(): continue # 使用正则匹配 Size 行 match = re.search(r'(?<!\S)Size:\s*(\d+)\s+bytes', line, re.IGNORECASE) if match: try: size_bytes = int(match.group(1)) if super_size == 0.0: super_size = size_bytes / float(1024 * 1024) # 转换为 MB print ("super 分区大小:%.2f MB" % super_size) except Exception as e: print ("无法解析 super 分区大小:%s" % str(e)) continue match = re.search(r'super:\s*(\d+)\s*.. (\d+):\s*([a-zA-Z0-9_]+)_a\s*\((\d+)\s+sectors\)', line) if match: name = match.group(3) + '_a' size_sectors = int(match.group(4)) # 直接使用括号内的数值 size_mb = round(size_sectors * sector_size / (1024 * 1024), 4) partition_sizes[name] = size_mb # 特别提取 super 分区的大小 if name == 'super_a': super_size = size_mb except Exception as e: print("解析 lpdump 文件出错: %s" % e) return partition_sizes, super_size def generate_dual_report(folder1, folder2, output_xlsx, is_os_project, upgrade_generations, maintenance_generations, reserve_per_generation, commercial_max_usage): """生成双机对比报告""" folder1_name = os.path.basename(os.path.normpath(folder1)) folder2_name = os.path.basename(os.path.normpath(folder2)) for folder in [folder1, folder2]: if not os.path.exists(folder): print("错误: 目录不存在 - %s" % folder) return "目录 %s 不存在,请检查路径" % folder if not os.path.isdir(folder): print("错误: 路径不是目录 - %s" % folder) return "%s 不是有效目录" % folder # 初始化数据结构 machine1_main_data = {} machine2_main_data = {} machine1_all_files = defaultdict(dict) machine2_all_files = defaultdict(dict) # 新增:解析 lpdump 文件 machine1_lpdump, machine1_super_size = parse_lpdump_file(os.path.join(folder1, '18_lpdump.txt')) machine2_lpdump, machine2_super_size = parse_lpdump_file(os.path.join(folder2, '18_lpdump.txt')) # 收集数据 for folder_path, main_dict, all_dict in [ (folder1, machine1_main_data, machine1_all_files), (folder2, machine2_main_data, machine2_all_files) ]: print("处理目录: %s" % folder_path) try: for filename in os.listdir(folder_path): if not filename.endswith('.txt'): continue prefix = extract_file_prefix(filename) if prefix == '01_' or prefix not in PARTITION_NAME_MAP: continue file_path = os.path.join(folder_path, filename) partition_name = PARTITION_NAME_MAP[prefix] file_data = parse_du_file(file_path) all_dict[filename] = file_data if is_main_partition_file(filename, prefix): print("解析主分区文件: %s" % file_path) main_dict[prefix] = file_data except OSError as e: print("目录访问错误: %s" % str(e)) return "无法访问目录 %s: %s" % (folder_path, str(e)) # 创建Excel工作簿 try: wb = xlwt.Workbook(encoding='utf-8') # ====== 定义样式变量 ====== header_style = xlwt.easyxf('font: bold on') title_style = xlwt.easyxf('font: bold on, height 280; align: wrap on, vert centre') normal_style = xlwt.easyxf() added_style = xlwt.easyxf('pattern: pattern solid, fore_colour light_green;') removed_style = xlwt.easyxf('pattern: pattern solid, fore_colour rose;') summary_style = xlwt.easyxf('font: bold on, color blue;') wrap_style = xlwt.easyxf('align: wrap on, vert centre') # 备注列样式 # ====== 创建总览Sheet页 ====== ws_overview = wb.add_sheet('总览') current_row = 0 # 写入总览标题 ws_overview.write_merge( current_row, current_row, 0, 5, "存储使用总览(仅主分区文件)", title_style ) current_row += 1 # 写入文件夹名称 ws_overview.write(current_row, 1, folder1_name, header_style) ws_overview.write(current_row, 2, folder2_name, header_style) current_row += 1 # 写入表头(增加备注列) headers = ['分区', '总大小(MB)', '总大小(MB)', '差值(MB)', '标记', '备注(增大TOP3)'] for col, header in enumerate(headers): ws_overview.write(current_row, col, header, header_style) current_row += 1 # 存储各分区汇总数据 overview_data = [] total_machine1 = 0.0 total_machine2 = 0.0 # 按分区顺序处理数据 for prefix in sorted(PARTITION_NAME_MAP.keys()): partition_name = PARTITION_NAME_MAP[prefix] # 跳过data分区 if partition_name == 'data': continue # 使用 lpdump 提供的大小替代原来的 du 总和 key = partition_name + '_a' size1 = machine1_lpdump.get(key, 0.0) size2 = machine2_lpdump.get(key, 0.0) diff = round(size1 - size2, 4) # 更新总计 total_machine1 += size1 total_machine2 += size2 # 确定标记样式 if diff > 0: mark = "增加" style = added_style elif diff < 0: mark = "减少" style = removed_style else: mark = "无变化" style = normal_style # 计算分区中增大的大于5MB的路径 top_notes = [] if diff > 0: # 只在分区增大时计算TOP路径 path_diffs = [] all_paths = set(machine1_main_data.get(prefix, {}).keys()) | set(machine2_main_data.get(prefix, {}).keys()) for path in all_paths: size1_path = machine1_main_data.get(prefix, {}).get(path, 0.0) size2_path = machine2_main_data.get(prefix, {}).get(path, 0.0) path_diff = size1_path - size2_path if path_diff > 5: # 只记录增大小于5MB的路径 path_diffs.append((path, path_diff)) # 按增大值降序排序 path_diffs.sort(key=lambda x: x[1], reverse=True) for i, (path, diff_val) in enumerate(path_diffs): # 截断过长的路径名 if len(path) > 50: path = "..." + path[-47:] top_notes.append("%d. %s: +%.2fMB" % (i+1, path, diff_val)) # 保存分区数据 overview_data.append({ 'name': partition_name, 'machine1': size1, 'machine2': size2, 'diff': diff, 'style': style, 'mark': mark, 'notes': "\n".join(top_notes) if top_notes else "无显著增大路径" }) # 写入行数据到总览页(增加备注列) print("写入总览页: %s, 测试机大小: %.2f MB, 对比机大小: %.2f MB" % (partition_name, size1, size2)) # 调试输出 ws_overview.write(current_row, 0, partition_name, style) ws_overview.write(current_row, 1, size1, style) ws_overview.write(current_row, 2, size2, style) ws_overview.write(current_row, 3, diff, style) ws_overview.write(current_row, 4, mark, style) ws_overview.write(current_row, 5, overview_data[-1]['notes'], wrap_style) # 使用已定义的wrap_style current_row += 1 # 添加空行 current_row += 1 # 写入总计行 total_diff = total_machine1 - total_machine2 if total_diff > 0: total_mark = "总增加" total_style = added_style elif total_diff < 0: total_mark = "总减少" total_style = removed_style else: total_mark = "无变化" total_style = normal_style ws_overview.write(current_row, 0, "总计", header_style) ws_overview.write(current_row, 1, total_machine1, header_style) ws_overview.write(current_row, 2, total_machine2, header_style) ws_overview.write(current_row, 3, total_diff, header_style) ws_overview.write(current_row, 4, total_mark, header_style) ws_overview.write(current_row, 5, "", header_style) # 备注列留空 # 判断是否满足预留条件 cr = 0 #商业化预留 current_row += 1 my_preload1 = machine1_lpdump.get('my_preload_a', 0.0) if is_os_project: required_space = total_machine1 + upgrade_generations * reserve_per_generation + maintenance_generations * 200 + commercial_max_usage*1024 - my_preload1 cr = commercial_max_usage*1024 - my_preload1 else: required_space = total_machine1 + upgrade_generations * reserve_per_generation + maintenance_generations * 200 space_difference = machine1_super_size - required_space reserved_space = machine1_super_size - total_machine1 symbol = ">" if required_space > machine1_super_size: status = "不满足" status_style = removed_style print("预留空间不足!当前占用: %.2fMB | 预留空间: %.2fMB | Super大小: %.2fMB | 还差 %.2fMB" % (total_machine1, reserved_space, machine1_super_size, abs(space_difference))) else: status = "满足" status_style = added_style symbol = "<" print("预留空间充足!当前占用: %.2fMB | 预留空间: %.2fMB | Super大小: %.2fMB | 剩余 %.2fMB" % (total_machine1, reserved_space, machine1_super_size, space_difference)) # 写入判断结果 ws_overview.write(current_row, 0, "预留判断", header_style) ws_overview.write(current_row, 1, "", normal_style) ws_overview.write(current_row, 2, "", normal_style) ws_overview.write(current_row, 3, "", normal_style) ws_overview.write(current_row, 4, status, status_style) ws_overview.write(current_row, 5, "当前占用: %.2fMB | 预留空间: %.2fMB | Super大小: %.2fMB" % (total_machine1, reserved_space, machine1_super_size), wrap_style) current_row += 1 ws_overview.write(current_row, 0, "判断公式", header_style) ws_overview.write(current_row, 5, "预留所需大小: %.2fMB = 当前占用: %.2fMB + 升级预留: %.2f*%.2f + %.2f*200 + 商业化预留:%.2f %s super大小:%.2f" % (required_space, total_machine1, upgrade_generations,reserve_per_generation,maintenance_generations,cr,symbol,machine1_super_size), wrap_style) # 设置备注列宽度(100字符) ws_overview.col(5).width = 256 * 100 # ====== 为每个文件创建单独的Sheet页(保持不变) ====== # 获取所有唯一的文件名(两个文件夹的并集) all_filenames = sorted(set(machine1_all_files.keys()) | set(machine2_all_files.keys())) for filename in all_filenames: # 提取文件前缀 prefix = extract_file_prefix(filename) # 跳过无效前缀 if prefix not in PARTITION_NAME_MAP: continue # 获取分区名称 partition_name = PARTITION_NAME_MAP[prefix] # 创建Sheet页名称(文件名不带扩展名) sheet_name = filename.replace('.txt', '') if len(sheet_name) > 31: # Excel sheet名称长度限制 sheet_name = sheet_name[:31] # 创建Sheet页 ws = wb.add_sheet(sheet_name) # print("创建文件Sheet页: %s" % sheet_name) # 当前行指针 current_row = 0 # 写入分区标题 title = "分区: %s - 文件: %s" % (partition_name, filename) ws.write_merge( current_row, current_row, 0, 5, title, title_style ) current_row += 1 # 写入文件夹名称 ws.write_merge(current_row, current_row, 0, 1, folder1_name, header_style) ws.write_merge(current_row, current_row, 2, 3, folder2_name, header_style) ws.write(current_row, 4, "差异(M)", header_style) ws.write(current_row, 5, "标记", header_style) current_row += 1 # 写入表头 headers = ['路径', '大小(M)', '路径', '大小(M)', '差异(M)', '标记'] for col, header in enumerate(headers): ws.write(current_row, col, header, header_style) current_row += 1 # 获取文件数据 data1 = machine1_all_files.get(filename, {}) data2 = machine2_all_files.get(filename, {}) # 获取所有路径(合并两个文件夹的路径) all_paths = sorted(set(data1.keys()) | set(data2.keys())) # 初始化变化统计数据 total_increase = 0.0 # 增大总和 total_decrease = 0.0 # 减小总和 total_added = 0.0 # 新增文件总和 total_removed = 0.0 # 去除文件总和 # 写入数据行 for path in all_paths: size1 = data1.get(path, 0.0) size2 = data2.get(path, 0.0) # 计算差值 diff = size1 - size2 # 确定标记和样式 if size1 == 0 and size2 > 0: mark = "除去" cell_style = removed_style total_removed += size2 elif size1 > 0 and size2 == 0: mark = "新增" cell_style = added_style total_added += size1 else: if diff > 0: mark = "增大" cell_style = added_style total_increase += diff elif diff < 0: mark = "减小" cell_style = removed_style total_decrease += abs(diff) else: mark = "相同" cell_style = normal_style # 写入行数据 # folder1列 if size1 > 0: ws.write(current_row, 0, path, cell_style) ws.write(current_row, 1, size1, cell_style) else: ws.write(current_row, 0, "", cell_style) ws.write(current_row, 1, "", cell_style) # folder2列 if size2 > 0: ws.write(current_row, 2, path, cell_style) ws.write(current_row, 3, size2, cell_style) else: ws.write(current_row, 2, "", cell_style) ws.write(current_row, 3, "", cell_style) # 差异和标记列 ws.write(current_row, 4, diff, cell_style) ws.write(current_row, 5, mark, cell_style) current_row += 1 # 添加文件汇总行 file_total1 = sum(data1.values()) file_total2 = sum(data2.values()) file_diff = file_total1 - file_total2 # 写入汇总行 ws.write(current_row, 0, "文件汇总", header_style) ws.write(current_row, 1, file_total1, header_style) ws.write(current_row, 2, "", header_style) ws.write(current_row, 3, file_total2, header_style) ws.write(current_row, 4, file_diff, header_style) ws.write(current_row, 5, "", header_style) current_row += 1 # 添加变化分类统计行 message = ( u"%s路径下: " u"减小%.2fM " u"增大%.2fM " u"新增文件%.2fM " u"减少文件%.2fM" ) % ( partition_name, total_decrease, total_increase, total_added, total_removed ) ws.write_merge( current_row, current_row, 0, 5, message, summary_style ) # 保存文件 wb.save(output_xlsx) return "对比报告已成功生成: %s" % output_xlsx except Exception as e: import traceback traceback.print_exc() return "生成Excel文件时出错: %s" % str(e) def generate_single_report(folder, output_xlsx, is_os_project=False, upgrade_generations=0, maintenance_generations=0, reserve_per_generation=0, commercial_max_usage=0): """单机拆解模式""" folder_name = os.path.basename(os.path.normpath(folder)) added_style = xlwt.easyxf('pattern: pattern solid, fore_colour light_green;') removed_style = xlwt.easyxf('pattern: pattern solid, fore_colour rose;') if not os.path.exists(folder): print("错误: 目录不存在 - %s" % folder) return "目录 %s 不存在,请检查路径" % folder if not os.path.isdir(folder): print("错误: 路径不是目录 - %s" % folder) return "%s 不是有效目录" % folder # 初始化数据结构 machine_data = {} all_files = defaultdict(dict) # 解析 lpdump 文件 lpdump_data, super_size = parse_lpdump_file(os.path.join(folder, '18_lpdump.txt')) my_preload_size = lpdump_data.get('my_preload_a', 0.0) # 收集数据 try: for filename in os.listdir(folder): if not filename.endswith('.txt'): continue prefix = extract_file_prefix(filename) if prefix == '01_' or prefix not in PARTITION_NAME_MAP: continue file_path = os.path.join(folder, filename) partition_name = PARTITION_NAME_MAP[prefix] file_data = parse_du_file(file_path) all_files[filename] = file_data if is_main_partition_file(filename, prefix): machine_data[prefix] = file_data except OSError as e: print("目录访问错误: %s" % str(e)) return "无法访问目录 %s: %s" % (folder, str(e)) # 创建Excel工作簿 try: wb = xlwt.Workbook(encoding='utf-8') # ====== 定义样式变量 ====== header_style = xlwt.easyxf('font: bold on') title_style = xlwt.easyxf('font: bold on, height 280; align: wrap on, vert centre') normal_style = xlwt.easyxf() summary_style = xlwt.easyxf('font: bold on, color blue;') wrap_style = xlwt.easyxf('align: wrap on, vert centre') # 备注列样式 # ====== 创建总览Sheet页 ====== ws_overview = wb.add_sheet('总览') current_row = 0 # 写入总览标题 ws_overview.write_merge( current_row, current_row, 0, 4, "存储使用总览", title_style ) current_row += 1 # 写入表头(增加备注列) headers = ['分区', '总大小(MB)', '标记', '差值(MB)', '备注(增大TOP3)'] for col, header in enumerate(headers): ws_overview.write(current_row, col, header, header_style) current_row += 1 # 存储各分区汇总数据 overview_data = [] total_machine = 0.0 # 按分区顺序处理数据 for prefix in sorted(PARTITION_NAME_MAP.keys()): partition_name = PARTITION_NAME_MAP[prefix] # 跳过data分区 if partition_name == 'data': continue # 使用 lpdump 提供的大小替代原来的 du 总和 key = partition_name + '_a' size = lpdump_data.get(key, 0.0) # 更新总计 total_machine += size # 记录标记为无变化 mark = "无变化" style = normal_style # 计算分区中增大的大于5MB的路径 top_notes = [] path_diffs = [] all_paths = set(machine_data.get(prefix, {}).keys()) for path in all_paths: size_path = machine_data.get(prefix, {}).get(path, 0.0) path_diffs.append((path, size_path)) # 按增大值降序排序 path_diffs.sort(key=lambda x: x[1], reverse=True) for i, (path, diff_val) in enumerate(path_diffs): # 截断过长的路径名 if len(path) > 50: path = "..." + path[-47:] top_notes.append("%d. %s: %.2fMB" % (i+1, path, diff_val)) # 保存分区数据 overview_data.append({ 'name': partition_name, 'machine': size, 'mark': mark, 'style': style, 'notes': "\n".join(top_notes) if top_notes else "无显著增大路径" }) # 写入行数据到总览页 ws_overview.write(current_row, 0, partition_name, style) ws_overview.write(current_row, 1, size, style) ws_overview.write(current_row, 2, mark, style) ws_overview.write(current_row, 3, "", style) current_row += 1 # 添加空行 current_row += 1 # 写入总计行 ws_overview.write(current_row, 0, "总计", header_style) ws_overview.write(current_row, 1, total_machine, header_style) ws_overview.write(current_row, 2, "", header_style) ws_overview.write(current_row, 3, "", header_style) ws_overview.write(current_row, 4, "", header_style) # 判断是否满足预留条件 cr = 0 #商业化预留 current_row += 1 if is_os_project: required_space = total_machine + (upgrade_generations * reserve_per_generation) + (maintenance_generations * 200) + (commercial_max_usage*1024) - my_preload_size cr = (commercial_max_usage*1024) - my_preload_size else: required_space = total_machine + upgrade_generations * reserve_per_generation + maintenance_generations * 200 space_difference = super_size - required_space reserved_space = super_size - total_machine symbol = ">" if required_space > super_size: status = "不满足" status_style = removed_style print("预留空间不足!当前占用: %.2fMB | 预留空间: %.2fMB | Super大小: %.2fMB | 还差 %.2fMB | 需求空间:%.2fMB" % (total_machine, reserved_space, super_size, abs(space_difference),required_space)) else: status = "满足" status_style = added_style symbol = "<" print("预留空间充足!当前占用: %.2fMB | 预留空间: %.2fMB | Super大小: %.2fMB | 剩余 %.2fMB | 需求空间:%.2fMB" % (total_machine, reserved_space, super_size, space_difference,required_space)) print("total_machine: %.2fMB | upgrade_generations: %.2fMB | reserve_per_generation: %.2fMB | commercial_max_usage: %.2fMB | my_preload_size:%.2fMB" % (total_machine, upgrade_generations, reserve_per_generation, commercial_max_usage,my_preload_size)) # 写入判断结果 ws_overview.write(current_row, 0, "预留判断", header_style) ws_overview.write(current_row, 1, "", normal_style) ws_overview.write(current_row, 2, status, status_style) ws_overview.write(current_row, 3, "", normal_style) ws_overview.write(current_row, 4, "当前占用: %.2fMB | 预留空间: %.2fMB | Super大小: %.2fMB" % (total_machine, reserved_space, super_size), wrap_style) current_row += 1 ws_overview.write(current_row, 0, "判断公式", header_style) ws_overview.write(current_row, 4, "预留所需大小: %.2fMB = 当前占用: %.2fMB + 升级预留: %.2f*%.2f + %.2f*200 + 商业化预留:%.2f %s super大小:%.2f" % (required_space, total_machine, upgrade_generations,reserve_per_generation,maintenance_generations,cr,symbol,super_size), wrap_style) # 设置备注列宽度(100字符) ws_overview.col(4).width = 256 * 100 # ====== 为每个文件创建单独的Sheet页(保持不变) ====== # 获取所有唯一的文件名 all_filenames = sorted(set(all_files.keys())) for filename in all_filenames: # 提取文件前缀 prefix = extract_file_prefix(filename) # 跳过无效前缀 if prefix not in PARTITION_NAME_MAP: continue # 获取分区名称 partition_name = PARTITION_NAME_MAP[prefix] # 创建Sheet页名称(文件名不带扩展名) sheet_name = filename.replace('.txt', '') if len(sheet_name) > 31: # Excel sheet名称长度限制 sheet_name = sheet_name[:31] # 创建Sheet页 ws = wb.add_sheet(sheet_name) # print("创建文件Sheet页: %s" % sheet_name) # 当前行指针 current_row = 0 # 写入分区标题 title = "分区: %s - 文件: %s" % (partition_name, filename) ws.write_merge( current_row, current_row, 0, 3, title, title_style ) current_row += 1 # 写入文件夹名称 ws.write_merge(current_row, current_row, 0, 1, folder_name, header_style) ws.write(current_row, 2, "差异(M)", header_style) ws.write(current_row, 3, "标记", header_style) current_row += 1 # 写入表头 headers = ['路径', '大小(M)', '差异(M)', '标记'] for col, header in enumerate(headers): ws.write(current_row, col, header, header_style) current_row += 1 # 获取文件数据 data = all_files.get(filename, {}) # 获取所有路径(合并两个文件夹的路径) all_paths = sorted(set(data.keys())) # 写入数据行 for path in all_paths: size = data.get(path, 0.0) # 标记为无变化 mark = "无变化" cell_style = normal_style # 写入行数据 ws.write(current_row, 0, path, cell_style) ws.write(current_row, 1, size, cell_style) ws.write(current_row, 2, "", cell_style) ws.write(current_row, 3, mark, cell_style) current_row += 1 # 添加文件汇总行 file_total = sum(data.values()) # 写入汇总行 ws.write(current_row, 0, "文件汇总", header_style) ws.write(current_row, 1, file_total, header_style) ws.write(current_row, 2, "", header_style) ws.write(current_row, 3, "", header_style) current_row += 1 # 添加变化分类统计行 message = ( u"%s路径下: " u"新增文件%.2fM" ) % ( partition_name, file_total ) ws.write_merge( current_row, current_row, 0, 3, message, summary_style ) # 保存文件 wb.save(output_xlsx) return "单机报告已成功生成: %s" % output_xlsx except Exception as e: import traceback traceback.print_exc() return "生成Excel文件时出错: %s" % str(e) def load_config(config_path): import configparser config = configparser.ConfigParser() config.read(config_path) return config if __name__ == "__main__": # 创建参数解析器 config = load_config('config.ini') # 解析参数 mode = config.get('MODE', 'mode', fallback='dual') if mode == 'dual': print("运行双机对比模式...") result = generate_dual_report( config.get('PARAMETER', 'folder1'), config.get('PARAMETER', 'folder2'), config.get('PARAMETER', 'output'), config.getboolean('PARAMETER', 'is_os_project'), config.getint('PARAMETER', 'upgrade_generations'), config.getint('PARAMETER', 'maintenance_generations'), config.getfloat('PARAMETER', 'reserve_per_generation'), config.getfloat('PARAMETER', 'commercial_max_usage') ) elif mode == 'single': print("运行单机拆解模式...") result = generate_single_report(config.get('PARAMETER', 'folder1'), config.get('PARAMETER', 'output'), config.getboolean('PARAMETER', 'is_os_project'), config.getint('PARAMETER', 'upgrade_generations'), config.getint('PARAMETER', 'maintenance_generations'), config.getfloat('PARAMETER', 'reserve_per_generation'), config.getfloat('PARAMETER', 'commercial_max_usage') ) print(result) 这个是现在的脚本,下面是config内容,分析报错原因[MODE] mode = single [PARAMETER] folder1 = 测试 folder2 = 对比 output = dongfeng.xlsx is_os_project = True upgrade_generations = 2 maintenance_generations = 3 reserve_per_generation = 700 commercial_max_usage = 2.2 V27960021@dg03podv27960021kj4p:~/存储/dongfeng/测试$ python storage.py 运行单机拆解模式... super 分区大小:12704.00 MB 预留空间不足!当前占用: 10824.00MB | 预留空间: 1880.00MB | Super大小: 12704.00MB | 还差 811.80MB | 需求空间:13515.80MB total_machine: 10824.00MB | upgrade_generations: 2.00MB | reserve_per_generation: 700.00MB | commercial_max_usage: 2.20MB | my_preload_size:1561.00MB Traceback (most recent call last): File "storage.py", line 707, in generate_single_report title = "分区: %s - 文件: %s" % (partition_name, filename) UnicodeDecodeError: 'ascii' codec can't decode byte 0xe5 in position 0: ordinal not in range(128) 生成Excel文件时出错: 'ascii' codec can't decode byte 0xe5 in position 0: ordinal not in range(128)
最新发布
11-22
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

四月天行健

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值