0

I want to translate the page in a french language but the data is present in html format in a excelsheet. So how can we fetch just the relevent data and translate it and then merge it back in correct format. I have 720 rows in excelsheet in the following format:

<html><head></head><p style="margin: 0px">Review the following steps to complete this questionnaire:</p><p style="margin: 0px">?</p><p style="margin: 0px"><span style="font-weight: bold">1) Answer questions.?</span>Select the appropriate answer to each question. Question specific help text may be available via the?<img src="../images/fieldhelp.gif" title="help" />?icon. If your answer dictates an explanation, a required text box will become available for you to add further information.</p><p style="margin: 0px">?</p><p style="margin: 0px"><span style="font-weight: bold">2) Add Comments.?</span>You may add question specific comments or attach supporting evidence for your answers by clicking on the?<img src="../images/comment_none.gif" title="add comment" />?icon next to each question. Once you have saved the comment, the icon will change to the?<img src="../images/comment.gif" title="view comments" />?icon to show that a comment has been added.</p><p style="margin: 0px">?</p><p style="margin: 0px"><span style="font-weight: bold">3) Change the Status.?</span>You may keep the questionnaire in the In Process status until you are ready to submit it for review. When you have completed the assessment, change the Submission Status to Submitted. This will route the assessment to the proper reviewer. Please note that all values list questions must be answered before submitting the questionnaire.</p><p style="margin: 0px">?</p><p style="margin: 0px"><span style="font-weight: bold">4) Save/Exit the Questionnaire.?</span>You may use either of the two buttons at bottom of the screen to save the questionnaire. The Save and Close?<span id="ques-inst-edit-button"></span>button allows you to save your work and close the questionnaire. The Save and Continue?<span id="ques-inst-savecontinue-button"></span>button allows you to save your work and remain in the questionnaire. The Cancel?<span id="ques-inst-cancel-button"></span>button closes the questionnaire without saving your work.</p></html>
0

Consider first exporting the Excel into a CSV, JSON, or XML and thereafter using AJAX or similar to retrieve and render the content via JavaScript.

Alternately, VBA could be used which shall eliminate the translation of Excel to a more browser-friendly format but compatibility will be limited to Internet Explorer.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .