I am trying to create html, that will ouptut a specific layout and formatting. But i need to input certain data/text from excel cells.

IE the text on the final page would get data from excel to fill the blanks.

This is a <excel ref> Bottle, made from <excel ref>. The contents is filled with <excel ref>

i will then need to make the HTML generate for each row in my exel sheet, to produce html for each row.

I would then like to save each row's html as an html file.

Hope this makes sense, and if anyone can give me some pointers, or insight into how to accomplish this, i would be very greatful.