# file_path = r"C:\Users\Administrator.DESKTOP-7IC2USJ\Desktop\ARMASTลูกค้า 3.txt"
# output_file_path = r"C:\Users\Administrator.DESKTOP-7IC2USJ\Desktop\ARMASTลูกค้า 215415.txt"
#
# # 使用TIS-620编码读取文件，并处理可能的编码错误
# with open(file_path, 'r', encoding='TIS-620', errors='replace') as file:
#     content = file.read()
#
# # 直接将内容写入新的UTF-8编码文件
# with open(output_file_path, 'w', encoding='UTF-8') as output_file:
#     output_file.write(content)
#
import pandas as pd
df = pd.read_excel(r"C:\Users\Administrator.DESKTOP-7IC2USJ\Desktop\新建文件夹\tai.xlsx",sheet_name="Products")

output_file_path = r'C:\Users\Administrator.DESKTOP-7IC2USJ\Desktop\新建文件夹\translated_excel_file.csv'  # 替换为你想要保存的文件路径
df.to_csv(output_file_path)
print(f"File has been converted and saved to {output_file_path}")



# import pandas as pd
# from googletrans import Translator
#
# # 初始化翻译器
# translator = Translator()
#
# # 读取Excel文件
# file_path = r"C:\Users\Administrator.DESKTOP-7IC2USJ\Desktop\新建文件夹\tai.xlsx"  # 替换为你的Excel文件路径
# df = pd.read_excel(file_path,sheet_name='Products',engine='openpyxl')
#
# # 定义一个函数来翻译单元格内容
# def translate_text(text, src='zh-cn', dest='th'):
#     try:
#         translated = translator.translate(text, src=src, dest=dest)
#         return translated.text
#     except Exception as e:
#         print(f"Error translating text '{text}': {e}")
#         return text
#
# # 遍历DataFrame并翻译每个单元格的内容
# for column in df.columns:
#     df[column] = df[column].apply(lambda x: translate_text(str(x)) if isinstance(x, str) else x)
#
# # 保存翻译后的DataFrame到新的Excel文件
# output_file_path = r'C:\Users\Administrator.DESKTOP-7IC2USJ\Desktop\新建文件夹\translated_excel_file.xlsx'  # 替换为你想要保存的文件路径
# df.to_excel(output_file_path, index=False)
#
# print("Translation complete and saved to", output_file_path)