Translation error while using python package "googletrans"

Question

I want to fix the below code, it should translate the words located in column A in the excel called "translation.xlsx", but it gives me an error
Also it should give me the output/result(translated words) in the same excel(translation.xlsx") in column B.

code is here

import openpyxl
from googletrans import Translator

loc = r"C:\Users\userid\Desktop\translation.xlsx"

gs = Translator.translate()

wb = openpyxl.load_workbook(loc)
sheet = wb.active

for i in range(2, sheet.max_row + 1):
    original = sheet.cell(row=i, column=1).value
    translated = gs.translate(original, 'de')
    sheet.cell(row=i, column=2).value = translated

wb.save(loc)

Error:

Traceback (most recent call last):
  File "c:\Users\userid\translation.py", line 8, in <module>
    gs = Translator.translate()
TypeError: translate() missing 2 required positional arguments: 'self' and 'text'

It's a TypeError, not translation error. You want gs to be instance of Translator class, so it has to be gs = Translator() — buran
– buran, Commented Oct 8, 2020 at 17:57

Dharman · Accepted Answer · 2020-10-08 18:03:59Z

1

You're trying to use the function translate() with the Translator class itself, not an instance of it.

Try:

gs = Translator()

edited Oct 8, 2020 at 18:03

Dharman♦

33.9k27 gold badges105 silver badges157 bronze badges

answered Oct 8, 2020 at 17:58

Makonede

4601 gold badge6 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Translation error while using python package "googletrans"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related