import urllib.requestimport urllib.parseimport jsonimport pandas as pdimport time
content=0while True: #df = [] file = r'..\data\pos.xls' xlsx = pd.ExcelFile(file)
fin = pd.read_excel(xlsx, 'Sheet1', header=None)
j=0 i=0 df = [] for i in range(0,356): for eachLine in fin[0][j:j+30]:
content=eachLine
url="http://fanyi.baidu.com/v2transapi" data={}
data['from']='zh' data['to']='en' data['query']=content
data['transtype']='translang' data['simple_means_flag']='3' data=urllib.parse.urlencode(data).encode("utf-8")
response=urllib.request.urlopen(url,data)
html=response.read().decode("utf-8")
target=json.loads(html)
tgt=target['trans_result']['data'][0]['dst']
df.append(tgt.strip() + '\n') print(j,':',i,':',tgt)
time.sleep(1)
i=i+1 if i%10==0:
time.sleep(120) if i % 20 == 0:
time.sleep(150) if i % 30 == 0:
time.sleep(170)
j=j+31 time.sleep(10)
w = pd.DataFrame(df)
w.to_excel('..\data\pos1.xls', sheet_name='Sheet1', header=None, merge_cells=False, index=False) print('翻译成功，请查看文件') break
