Click here for Selenium Basic Version
I created a tool to easily translate a foreign language pasted into Excel with Chrome Driver and DeepL. No special configuration is required, and no update of Chrome Driver is needed.
I am currently working in a patent-related field and am using a search system to search for patent documents.
The patent documents that are output as search results are not only in Japanese but also in foreign languages such as English, and we sometimes read foreign language patent documents to understand the technical contents.
However, the translation accuracy of the translation tools provided is low, and it takes time to understand the translation results of foreign language patent documents.
The idea is to provide a translation tool that can compare the translated text with the original text with high accuracy by displaying the original text in a foreign language and the translated text translated by DeepL side by side.
- Microsoft Windows 10 or Microsoft Windows 11
- Google Chrome
- Microsoft Excel 2016 or Microsoft Excel 2019
- Chrome Driver
-
1.SimpleTranslator zip file ← Click to download.
-
Unzip the zip file downloaded in step 1 above, and open SimpleTranslator.xlsm in the SimpleTranslator folder.
-
Select the language selection combo box.
-
Select the target language.
-
Select the radio button to choose the display order of "Translated Text → Source Text" or "Source Text → Translated Text".
How to use it in Web articles (For how to use it in patent documents and PDF, please skip this section and go to the following sections.)
-
Trace the English text displayed on the sample page with your mouse to copy it.
-
Right-click on sheet A2 in Excel, and select the second icon from the left under Paste Options.
-
Press the "Shaping button" to fill in the blank lines.
-
Press the "Translate (HTML)" button.
-
The "Save As" dialog box will appear.
-
Enter a name and save the file. In this case, enter "sample" and click the "Save button".
-
The translation will start and a progress bar will appear.
-
When the translation is complete, the browser will open and output the translation results.
-
The translation results will be created in HTML format in a directory in the same location as the application.