|
Public Function EnToCh(rng As String)
Dim xml
Dim URL$, EngSentence$
Set xml = CreateObject("MSXML2.XMLHTTP")
'EngSentence = URLEncodePlus(rng.Text)
'url = "https://translate.google.cn/m?hl=en&sl=enN&tl=zh-CN&ie=UTF-8&prev=_m&q=" & EngSentence
Debug.Print Asc(rng)
aasc = Asc(rng)
If aasc > 64 And aasc < 123 Then
URL = "https://translate.google.cn/m?hl=en&sl=enN&tl=zh-CN&ie=UTF-8&prev=_m&q=" & rng
Else
URL = "https://translate.google.cn/m?sl=zh-CN&tl=en&q=" & GetURL(rng)
End If
With xml
.Open "GET", URL, False
.send
'Sheet1.Cells(2, 3) = .responseText
If InStr(.responseText, "result-container") > 0 Then
EnToCh = Split(Split(.responseText, "result-container"">")(1), "</div><")(0)
End If
End With
End Function
谷歌会经常屏蔽,这个只能对单个单元格进行处理,存在换行就比较麻烦 |
评分
-
1
查看全部评分
-
|