Skip navigation
Currently Being Moderated

How to generate web page from Excel spread sheet?

May 4, 2013 8:23 AM

I have a spreadsheet containing a long string of HTML text.  It can be viewied below and each line needs to be one web page.  I also have the same file in a flat text file.

 

Header 1Header 2Header 3
<h3 style="text-align:center;">Minutes of the Annual Meetings of the Brethren: 1778 - 1917</h3><p style="text-align: center;"><a href="images/books/001/220.png" title="Page 220 — Minutes of the Annual Meetings of the Brethren" rel="rokbox[600 905](demo)"><img src="images/books/001/220.png" border="0" alt="Page 220 — Minutes of the Annual Meetings of the Brethren [Click for larger image]" title="Page 220 — Minutes of the Annual Meetings of the Brethren [Click for larger image]" width="500" height="754" /></a><span style="text-align: center; display: block; margin-top: 6px;">Page 220</span></p><p style="display:none;"> </p>
<h3 style="text-align:center;">Minutes of the Annual Meetings of the Brethren: 1778 - 1917</h3><p style="text-align: center;"><a href="images/books/001/221.png" title="Page 221 — Minutes of the Annual Meetings of the Brethren" rel="rokbox[600 905](demo)"><img src="images/books/001/221.png" border="0" alt="Page 221 — Minutes of the Annual Meetings of the Brethren [Click for larger image]" title="Page 221 — Minutes of the Annual Meetings of the Brethren [Click for larger image]" width="500" height="754" /></a><span style="text-align: center; display: block; margin-top: 6px;">Page 221</span></p><p style="display:none;"> </p>

 

I need Dreamweaver CS4 to take this spreadsheet and generate a series of web pages.  The head section will be the same for all the generated HTML files.  A sample page can be viewed here.

 

If I can locate a script that will do this then I can take an extension for a Joomla web site and pass along the series of page to it.  The Joomla extension will then create my articles for me.

 

Cordially,
Wayne

 
Replies
  • Currently Being Moderated
    May 4, 2013 11:41 AM   in reply to A. Wayne Webb

    You might try using Excel and saving as HTML.

     

     

    Nancy O.

     
    |
    Mark as:
  • Currently Being Moderated
    May 4, 2013 4:29 PM   in reply to A. Wayne Webb

    I have no clue where you would find such a script or extension.  This isn't a workflow most people use to create web pages.

     

    In the long run, you'll get cleaner code if you strip out all those inline styles and just copy and paste plain text, one line at a time into a new, HTML document.

     

    Sorry I don't have any shortcuts to offer you.

     

     

    Nancy O.

     
    |
    Mark as:
  • Currently Being Moderated
    May 6, 2013 10:00 AM   in reply to A. Wayne Webb

    >What I need is for DW to take each row and create a page of that row.

     

    DW isn't designed to do that. Do you know VBA? Should be pretty easy to code that within Excel, I would think.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points