I am not a coder , but I can follow the steps, I am using WP as a Hotel Directory , now I had a patern for all pages , and all the information to fill the patern is in the excel sheet so my question is Is there a way to import the information of the excel sheet to go inside the HTML file? More explanation the HTMl file is for examlpe td CLASS="" HEIGHT="20" WIDTH="175"><strong><font SIZE="2">Property Name:</font></strong></td> <td CLASS="" WIDTH="425">Hotel Name</td> This Hotel Name (in Red ) is in the excel sheet How can I import this information from the excel sheet to its proper place in the HTMl file
I'd save an excel sheet in CSV file ("Save As..." in Excel) and write a simple PHP script to parse that file. Of course you can do it manually in any text editor.
It's a little more complicated than 1 2 3... can you find some office boy who'll input the text for like 6 bucks an hour or something? He can gopher coffee at the office too. It would make more sense to have such a script if you had multiple Excel sheets which needed to be inputted to multiple, similar (same HTML template) pages. Every place where you wanted a piece of text to go, the part you showed with the table stuff (td class="whatever...") would have these variable placeholders to tell the script where to put what. like $param or something. That would take as much work I think as just typing them in the first time (if it only gets typed in once). We use a Perl script to generate the values in our HTML but we've got like a gazillion pages and they make calculations based on what people put in and show the different values in the same places in the HTML so... that would be more work than writing a script.