Hello! (^_^) I created this tool to help my friends solve a specific problem. Now, I want to share this solution with everyone!
Access the Dofufa API in Google Apps!
Below are three six URL endpoints you can use in Google Spreadsheets (with Google's importXML or importData functions) to convert Chinese to Hanyu Pinyin or Traditional Chinese characters to Simplified Chinese characters. More Functions Available
Suggestions? Find me on Twitter (dofufa)
|
Chinese To Pinyin
Input: c (Chinese characters)
XML Output: <output>pin1 yin1</output>
XML Sample Code with Chinese characters in cell A1:
=importXML("http://g.dofufa.com/cp?c="&A1,"//output")
CSV Output: pin1 yin1
CSV Sample Code with Chinese characters in cell A1:
=importData("http://csv.dofufa.com/cp?c="&A1)
|
|
Chinese To Pinyin with Tonemarks
Input: c (Chinese characters)
XML Output: <output>pīn yīn</output>
XML Sample Code with Chinese characters in cell A1:
=importXML("http://g.dofufa.com/cpt?c="&A1,"//output")
CSV Output: pīn yīn
CSV Sample Code with Chinese characters in cell A1:
=importData("http://csv.dofufa.com/cpt?c="&A1)
|
|
Traditional To Simplified Chinese
Input: c (Chinese characters)
XML Output: <output>简体字</output>
XML Sample Code with Chinese characters in cell A1:
=importXML("http://g.dofufa.com/ts?c="&A1,"//output")
CSV Output: 简体字
CSV Sample Code with Chinese characters in cell A1:
=importData("http://csv.dofufa.com/ts?c="&A1)
|
|
