PerlMonks is not a code writing service. You cannot simply give a requirement and say "please send teh codez".

Keeping that in mind, what you will get here are suggestions for what CPAN modules might be relevant to your needs

If you have an Excel file, you can use Spreadsheet::ParseExcel to read in the data. Once you have it, you can use WWW::Mechanize to send the data in the cell to Babelfish to accomplish the translation. Once you have the data back (retrieved using the WWW::Mechanize API), you can store it in a file using Spreadsheet::WriteExcel.

So, you have many small pieces you can work on independently:

  1. Reading in data from Excel (although just saving as CSV and using Text::CSV would be easier)
  2. Taking a string in one language and submitting via HTTP using WWW::Mechanize to Babelfish
  3. Getting that result string and saving it back to Excel using Spreadsheet::WriteExcel (although CSV again would be easier)

The monks here will be happy to help if you have source code that you've tried to get working and can't. Just remember to heed the advice in How do I post a question effectively?

In reply to Re: Translation using GoogleTranslator / Yahoo Babel Fish by Sinistral
in thread Translation using GoogleTranslator / Yahoo Babel Fish by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.