How to Convert Hindi Language into English Language in EXcel

Hi Team,

I have a Websites which is having Monthly reports as attachment in Excel with Hindi Language.

Every month I need to navigate to website and download the excel attachment and need to extract/Read the data from Excel and convert it into English language.

Please find the screenshot of downloaded excel with hindi data.

Hi @Latika_Bhavani,

Please provide your input Hindi excel we will try for solution.

This is not solution just possible way

1)Read Hindi excel and kept in datatable
2)Convert datatable to string or string array
3)Pass the string to google translate api like blow code

String word="";
var toLanguage = “hi”;//Hindi
var fromLanguage = “en”;//English
var url = $“https://translate.googleapis.com/translate_a/single?client=gtx&sl={fromLanguage}&tl={toLanguage}&dt=t&q={HttpUtility.UrlEncode(word)}”;
var webClient = new WebClient
{
Encoding = System.Text.Encoding.UTF8
};
var result = webClient.DownloadString(url);

4)we can take the result and write or append in new excel

Regards,
Omkar P

Hi

For this I have used Language Translator and able to covert it from Hindi to English,

Simple workflow attached for Reference.LanguageTranslation.zip (29.2 KB)

Thanks
Latika

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.