有没有高手教教我怎么把两列Excel数据变成mdx文件

技术交流与词典编修
,
13

直接让chatgpt写了个python文件，把xlsx和mdx名字换成你的，下载python
运行pip install openpyxl pymdict
然后运行脚本就好了

from openpyxl import load_workbook
from pymdict import MDXWriter  # pip install pymdict

# 1. 读取 Excel 文件
excel_path = "your_file.xlsx"  # 你的 Excel 文件路径
wb = load_workbook(excel_path, read_only=True)
ws = wb.active  # 取第一个工作表

# 2. 提取 A列和C列数据
entries = []
for row in ws.iter_rows(min_row=2):  # 从第2行开始，跳过表头
    word = row[0].value  # A列
    definition = row[2].value  # C列
    if word and definition:
        entries.append((str(word).strip(), str(definition).strip()))

# 3. 生成 MDX
mdx_path = "output.mdx"
writer = MDXWriter(
    title="我的词典",
    description="从Excel生成的mdict词典",
    encoding="UTF-8"
)

for headword, body in entries:
    writer.add_entry(headword, body)

writer.write(mdx_path)

print(f"✅ 转换完成，文件已保存为: {mdx_path}")
2 个赞