I do a voluntary site for a local Snooker/Pool league. The secretary of the league always sends me results by way of an excel spreadsheet, and all rows/columns in a table are populated with data ie: results. When I put it on the web I break it up by manually putting in blank lines, or making lines bold or whatever basically to make it easier to read. We have an archive of 12 years results that we may put on, depending on how easy or difficult it will be.

Is there anyway that I can automate the process of certain cells/rows being bold or certain rows having another blank row below or above them, when importing a table from Excel in Dreamweaver (or after?). I will have to do this 'cosmetic' importing hundreds of times for the archive to look like the rest of the site.

Remember, the important thing is that although there may be many excel spreadsheets the pattern for a particular season or set of seasons will always be the same.

Hope this question makes some sense ?

Thanks



Edited by - snookey on 29 Sep 2005 02:04:31

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I do a voluntary site for a local Snooker/Pool league. The secretary of the league always sends me results by way of an excel spreadsheet, and all rows/columns in a table are populated with data ie: results. When I put it on the web I break it up by manually putting in blank lines, or making lines bold or whatever basically to make it easier to read. We have an archive of 12 years results that we may put on, depending on how easy or difficult it will be.

Is there anyway that I can automate the process of certain cells/rows being bold or certain rows having another blank row below or above them, when importing a table from Excel in Dreamweaver (or after?). I will have to do this 'cosmetic' importing hundreds of times for the archive to look like the rest of the site.

Remember, the important thing is that although there may be many excel spreadsheets the pattern for a particular season or set of seasons will always be the same.

Hope this question makes some sense ?

Thanks


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Set up a CSS file and attach it to your web page that you paste all this data in. That sounds like the simplest. The downside will be that you'll have to learn a little bit about cascading styles sheets if you're not already familiar with it. I'm assuming you aren't, since you're asking this question. <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

With CSS you'll be able to control how your table cells, fonts, colors and all that good stuff are setup. Each time you attach it to your document, it should take care of most of your look that you are seeking.