Fetch data from excel rows and put within html tags

Get Started
1

Hello,

I am not sure if it is possible and if possible then what’s the script/ tool/ program to be used to achieve. Below is what I am trying to achieve.

I have a multilingual site in 5 language, what happens is I get translated data in excel sheet. currently I copy each data and paste in a html file. It is okay for once but not good when have to copy for 5/10 language in to 5/10 html file, much time consuming and boring job. Here only translations changes but row remains same and goes in to html page which has bunch of html tags. What I want to create is automated script to fetch data from excel rows and put within html tags.

just an visual example,

Kindly let me know your thought.

Thanks
Radiant

2

33 views and no response :frowning: this is not possible? please point me to the right direction…

3

Save the file as a CSV. Import it into PHP for example, loop through and apply HTML formatting :slight_smile:

4

You can easily do it with VBScript:
Like this: http://bulevardi.be/?content=scripting&example=exvb2

This is an example of a simple guestbook that stores and retrieves it’s data in an excel file too and puts it visible in html.
It uses VBScript, is only possible in IE. And afaik works offline only, for like intrawebs.

5

Have you tried using the “Save as Web Page” option from within Excel? (It’s on the File menu in my version.)

I’m not sure what whether the resulting web page would meet your requirements, but it might provide a starting point - one from which you can perhaps do some find-and-replace to get the tags you need.

Just a thought.

Mike

6

Yes, it is possible. I don’t know if there is any script that does this because, in this case, I would build it myself, either by creating a macro (this is the option that i would choose because I know VBA) or by exporting and using any other programming language of my preference to loop through the exported file, as philm suggested.