Convert an Excel file to english

convert.py

import os

from openpyxl import load_workbook
from google.cloud import translate

os.environ["GOOGLE_APPLICATION_CREDENTIALS"] = "/DIRECTORY-TO-YOUR-GOOGLE-KEY/google.json"

translate_client = translate.Client()
target = 'en'

wb = load_workbook(filename='/DIRECTORY/FILE-TO-TRANSLATE.xlsx', read_only=False)

count = 0

for sheet in wb.sheetnames:
    ws = wb[sheet]

    for row in ws.rows:
        for cell in row:
            if not cell.data_type == 's':
                continue

            to_translate = cell.value

            if to_translate:
                translation = translate_client.translate(to_translate, target_language=target)
                cell.value = translation["translatedText"]
                count = count + 1


print(count)
wb.save('/DIRECTORY/OUTPUT/RESULT.xlsx')

requirements.txt

openpyxl
google-cloud-translate