A German learner, myself. Often annoyed that I have always to look for in dictionary like Google Translator or Linguee for the words in German for their English meanings. Next time I have do that again if I don’t remember the meaning, and again until I keep it in my memory.
I started to my note on a notebook manually, its slow and painful. I need to type the words in the translator and when it gets something, write it down on my notebook. Why not automate this?
Google this for the possibilities in R. I found R package “translateR”, it can read words or text from a dataframe and append the translatedContent. Perfect for me!
Uhmm.. Spend a night I realized its not working for me, I don’t see the translated contents at all. Tried all the methods, with very few irrelevent quesntions found on Stakoverflow. And opend a issue on the ‘translateR’ GitHub repository. Can’t wait, I decided to move on to other solutions.
The ‘translate’ package popped up. The difference is ‘translate’ translates one cell at a time, and I need the whole column to be translated and appended, the function like in ‘translateR’.
At least the ‘translate’ works for me. I wrote a function to have the same function as I wanted in ‘transalteR’, fanyir here we go. Give it a .xlsx file, it can translate and produce PDF.
To use it by yourself, you can read the instructions at the repository at GitHub https://github.com/qifengzhou/fanyir