@Wolfsin

def translateBaidu(content, fromLang='en', toLang='zh'):
salt = str(random.randint(32768, 65536))
sign = appid + content + salt + secretKey
sign = hashlib.md5(sign.encode("utf-8")).hexdigest()

try:
paramas = {
'appid': appid,
'q': content,
'from': fromLang,
'to': toLang,
'salt': salt,
'sign': sign
}
response = requests.get(apiurl, paramas)
jsonResponse = response.json() # 得到返回的结果，结果为 json 格式
dst: str = str(jsonResponse["trans_result"]
[0]["dst"]) # 取得翻译后的文本结果
return dst
except Exception as e:
print(e)


def excelTrans(srcFilename=r'/Users/justin/Desktop/FANYI.xlsx', desFilename=r'/Users/justin/Desktop/FANYI1.xlsx',
srcSheet='Sheet1', srcColumn=1, srcRowBegin=1, srcRowEnd=2,
desColumn=1, desSheet='中文品名'):
wb = openpyxl.load_workbook(srcFilename)
ws = wb[srcSheet]
wb2 = Workbook()
ws2 = wb2.create_sheet(title=desSheet)

for i in range(srcRowBegin, srcRowEnd, 1):
result = ws.cell(row=i, column=srcColumn).value
if not (result is None):
ws2.cell(row=i-srcRowBegin+1,
column=desColumn).value = translateBaidu(result)
print(result+"translate is done")

wb2.save(desFilename)


if __name__ == '__main__':
print('translate begin...')
excelTrans()
print('ending...')