• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

Creating 3500 html pages


I have 3500 excel records. I need each record saved separately as an html document. Each page would be
appear the same except that the data would be different.
I would like to use my own preset page template

Is there a tool I can use to automate this process
or without cutting, pasting and saving 3500 pages.

Basically, take data from an ASCII or excel file, slot
it into a page template and save it with a unique name with
an html extension.

1 Solution
so you want to turn each excel record (are they spreadsheets?) put into html table format? or...?
What is the format of your records and your template?
I could write you a simple program that will do it.  Send me your template and the excel file and I will see what I can do.
What you can do is that write a dll component using VB to which pass the xls file as argument.In that component you write code to convert the records to html.
PS:-You can access each cell of the excel sheet using VB
If you just need to view them online rather then actually needing the HTML, you might want to implement a dynamic system.  Maybe ASP or something so that it will generate a page for each entry only when a user requests it.  Basically, the user thinks that there are 3500 pages.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now