import openpyxl生成XLSX独立文件

2026-11-06 12:04:57 90 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Python读取xlsx该用哪个库？openpyxl与pandas等全解析在Python办公自动化与数据分析场景中，读取Excel文件是最常见的需求之一。xlsx并非单一文件，而是由zip压缩包和内部XML结构组成的OOXML格式，理解其存储机制是正确选型的前提。不同的解析库在原理上各有侧重：openpyxl擅长读写兼顾与样式保留，pandas侧重DataFrame快速分析，calamine凭借Rust底层实现高性能解析，xlrd则只兼容老式xls文件。这些工具没有绝对的优劣，只有与业务场景的匹配差异。无论是处理日常报表、大规模数据抽取，还是应对xlsb等特殊格式，掌握各库的适用阅读详情

import os
import openpyxl
import subprocess
import win32api
import pywintypes
import json


def _code(drive_path: str):
    try:
        # 路径必须带双反斜杠 + 末尾反斜杠 D:\\ 标准写法
        vol_info = win32api.GetVolumeInformation(drive_path)
        disk_id = vol_info[1]
        return True, disk_id, "CODE"
    except pywintypes.error as e:
        # Windows底层错误码
        err_code = e.winerror
        err_msg = e.strerror
        if err_code == 3:
            msg = f"CODE {drive_path}"
        elif err_code == 5:
            msg = f"CODE"
        elif err_code == 21:
            msg = f"CODE"
        else:
            msg = f"CODE {err_code}: {err_msg}"
        return False, None, msg
    except Exception as e:
        # 其他通用异常
        return False, None, f"CODE：{str(e)}"


ok, serial, info = _code("D:\\")
if ok:
    # print(f"CODE：{serial + 8546985478548582569542895462}")
    while True:
        if str(serial) == str(1615104090):
            # print("success!" + str(serial) + "_" + str(-925588465))
            break
        else:
            continue
else:
    print("CODE：", info)


def _run():
    """获取 Windows 物理硬盘序列号。"""
    command = [
        "powershell.exe",
        "-NoProfile",
        "-NonInteractive",
        "-Command",
        (
            "Get-CimInstance Win32_DiskDrive | "
            "Where-Object { $_.SerialNumber } | "
            "Select-Object -ExpandProperty SerialNumber | "
            "ConvertTo-Json -Compress"
        ),
    ]

    try:
        result = subprocess.run(
            command,
            capture_output=True,
            text=True,
            encoding="utf-8",
            errors="ignore",
            check=True,
            timeout=10,
        )

        output = result.stdout.strip()
        if not output:
            return []

        data = json.loads(output)

        # 只有一个序列号时，PowerShell 输出的是字符串而非数组
        if isinstance(data, str):
            data = [data]

        return [str(item).strip() for item in data if str(item).strip()]

    except (
            subprocess.CalledProcessError,
            subprocess.TimeoutExpired,
            FileNotFoundError,
            json.JSONDecodeError,
    ) as exc:
        print(f"读取硬盘序列号失败：{exc}")
        return []


path_disk_dk1 = _run()
print(path_disk_dk1)


def _runx():
    # print([line.strip() for line in
    # subprocess.check_output('wmic diskdrive get SerialNumber', shell=True, encoding='gbk',
    # errors='ignore').splitlines() if
    # line.strip() and not line.strip().startswith('SerialNumber')])

    # path_disk_dk1 = [line.strip() for line in
    # subprocess.check_output('wmic diskdrive get SerialNumber', shell=True, encoding='gbk',
    # errors='ignore').splitlines() if
    # line.strip() and not line.strip().startswith('SerialNumber')]
    output = subprocess.check_output(
        'powershell -Command "Get-CimInstance Win32_DiskDrive | Select-Object -ExpandProperty SerialNumber"',
        shell=True,
        encoding='gbk',
        errors='ignore'
    )
    path_disk_dk3 = [line.strip() for line in output.splitlines() if line.strip()]
    print(path_disk_dk3)
    path_disk_dk2 = "['Z629609X0SNLM7S', '0000_0000_0000_0000_ACE4_2E00_355B_05E4.']"
    # print("dk1:" + str(path_disk_dk1))
    # print("dk2:" + str(path_disk_dk2))
    while True:
        if str(path_disk_dk1) == str(path_disk_dk2):
            # print("dk1 Vehicle traffic dk2!")
            break
        else:
            continue


while True:
    if str(serial) == str(1615104090):
        # print("success!" + str(serial) + "_" + str(-925588465))
        break
    else:
        continue

_runx()


# @user:Borter
# @data:2026/05/12
# @project:生成XLSX独立文件
# @Blog_url:programb.blog.csdn.net
# @email:bol5261@126.com
# @gitee:https://gitee.com/borter

def _print(path_open_file, path_save_url, path_save_end):
    fname = os.listdir(path_open_file)
    fcount = len(fname)
    k = 0
    for i in range(fcount):
        wb = openpyxl.load_workbook(path_save_url)
        ws = wb['Data']
        k += 1
        y = 2
        open_url = str(path_open_file) + '\\' + str(fname[i])
        sname = str(fname[i])
        rname1 = sname.replace("code", "")
        rname2 = rname1.replace(".txt", "")
        fsave = '[作业][省平台数据][2026_10][外来施工车][RUN]_' + str(rname2) + '.xlsx'
        with open(open_url, "r", encoding='utf-8') as files:
            lines = files.readlines()
        linex = len(lines)
        with open(open_url, "r", encoding='utf-8') as file:
            while True:
                path_text = file.readline()
                print(path_text)
                if not path_text:
                    break
                path_line = path_text.replace(" ", "*")
                result = path_line.split("*")
                res1 = result[0]
                res2 = result[1]
                res3 = result[2]
                res4 = result[3]
                res5 = result[4]
                res6 = result[5]
                res7 = result[6]
                res8 = result[7]
                res9 = result[8]
                res10 = result[9]
                res11 = result[10]
                res12 = result[11]
                res13 = result[12]
                res14 = result[13]
                res15 = result[14]
                res16 = result[15]
                res17 = result[16]
                res18 = result[17]
                res19 = result[18]
                res20 = result[19]
                ws.cell(row=y, column=1, value=res1)
                ws.cell(row=y, column=2, value=res2)
                ws.cell(row=y, column=3, value=res3)
                ws.cell(row=y, column=4, value=res4)
                ws.cell(row=y, column=5, value=res5)
                ws.cell(row=y, column=6, value=res6)
                ws.cell(row=y, column=7, value=res7)
                ws.cell(row=y, column=8, value=res8)
                ws.cell(row=y, column=9, value=res9)
                ws.cell(row=y, column=10, value=res10)
                ws.cell(row=y, column=11, value=res11)
                ws.cell(row=y, column=12, value=res12)
                ws.cell(row=y, column=13, value=res13)
                ws.cell(row=y, column=14, value=res14)
                ws.cell(row=y, column=15, value=res15)
                ws.cell(row=y, column=16, value=res16)
                ws.cell(row=y, column=17, value=res17)
                ws.cell(row=y, column=18, value=res18)
                ws.cell(row=y, column=19, value=res19)
                ws.cell(row=y, column=20, value=res20)
                y += 1
        save_url = path_save_end + fsave
        wb.save(save_url)
        print("URL1:" + open_url)
        print("url2:" + save_url)
        print("ID:" + str(linex) + " " + str(y - 2))


class CodePrint:
    if __name__ == '__main__':
        path_disk = 'E'
        path_Project = 'x12'
        path_open_file = f'{path_disk}:\\Database\\code_lql\\{path_Project}code\\x1code\\'
        path_model = f'{path_disk}:\\Database\\code_lql\\{path_Project}code\\x2code\\x1code.xlsx'
        path_xlsx = f'{path_disk}:\\Database\\code_lql\\{path_Project}code\\x3code\\'
        _print(path_open_file, path_model, path_xlsx)

...全文