from openpyxl import load_workbook
INPUT_FILE = "/Users/apple/Downloads/دانلودها/پارسال-فیک- دریا پلنر copy/monthnames.xlsx"
import pandas as pd
import os
def to_unicode(value):
if pd.isna(value):
return ""
value = str(value) # هیچ strip نکن
return ",".join(str(ord(c)) for c in value)
excel_path = INPUT_FILE
df = pd.read_excel(excel_path, header=0, dtype=str)
output_path = os.path.splitext(excel_path)[0] + "_output432.txt"
with open(output_path, "w", encoding="utf-8", newline="") as f:
for _, row in df.iterrows():
p = to_unicode(row.iloc[0])
en1 = "" if pd.isna(row.iloc[1]) else str(row.iloc[1])
en2 = "" if pd.isna(row.iloc[2]) else str(row.iloc[2])
a1 = to_unicode(row.iloc[3])
a2 = to_unicode(row.iloc[4])
line = (
f"{p},|||,"
f"{en1},|||,"
f"{en2},|||,"
f"{a2},|||,"
f"{a1},|||"
)
f.write(line + "\n")
print("Done.")
print(output_path)