Export excel --> html - How to clean html?

BITM@D · April 10th, 2004, 01:25 AM

Well, it's a price list that comes to me direct from the wholesaler. I'm looking for an easy way to get that information (in a reasonably attractive format) onto the site. I also need a way to repeat the process at least monthly. Perhaps there's a better way?

jmichna · April 10th, 2004, 08:42 AM

Quote:

Originally posted by BITM@D
Well, it's a price list that comes to me direct from the wholesaler. I'm looking for an easy way to get that information (in a reasonably attractive format) onto the site. I also need a way to repeat the process at least monthly. Perhaps there's a better way?

Learn ASP, you will be able to put the database (spreadsheet) on the server, create a DSN to link the spreadsheet info, and create some relatively simple code (to do the data formating and import the records) will import the data from the spreadsheet. Whenever the spreadsheet info is updated, your web page will be automatically updated. Probably the simplest book I've come across is "ASP for Dummies" (from the yellow & black "... for Dummies" series). I'll bet you could self-teach yourself everything you'd need in less than five days.

BITM@D · April 10th, 2004, 10:52 PM

Thanks for the suggestion.

I'll look around for an asp programer. I don't have the time or the inclination to learn a new language unless someone sells a ready to go solution that anyone is aware of.

Siliconjunkie · April 11th, 2004, 12:04 AM

http://www.serverwatch.com/tutorials...le.php/1493331
http://www.4guysfromrolla.com/webtech/022801-1.shtml

omalleytrading · April 12th, 2004, 10:18 AM

Okay, try this. It's the VB code for a macro you can add to your Excel file:

Sub Export2HTML()
Dim Printstring As String
Dim r As Long
Dim c As Long
Dim WebpageName As Variant
Dim WebpageFile As String

WebpageName = Application.GetSaveAsFilename( _
fileFilter:="Web pages (*.htm), *.htm")
If WebpageName = False Then Exit Sub
WebpageFile = Replace(WebpageName, ".html", "")
WebpageFile = Replace(WebpageFile, ".htm", "")
WebpageFile = WebpageFile & ".htm"
Open CStr(WebpageFile) For Output As #1
Print #1, "<HTML>"
Print #1, "<BODY>"
Print #1, "<TABLE align=left border=1 cellPadding=2 cellSpacing=1 width=""100%"">"
Print #1, "<TBODY>"
For r = Selection(1).Row To _
Selection(1).Row + Selection.Rows.Count - 1
Print #1, "<TR>"

For c = Selection(1).Column To _
Selection(1).Column + Selection.Columns.Count - 1
Print #1, "<TD vAlign=top>" & Cells(r, c).Text & "</TD>"
Next

Print #1, "</TR>"
Next
Print #1, "</TBODY></TABLE>"
Print #1, "</BODY>"
Print #1, "</HTML>"
Close #1

ActiveWorkbook.FollowHyperlink WebpageFile
End Sub

BITM@D · April 12th, 2004, 09:58 PM

Cool, thanks. Though I'm not quite sure what to do with it. Can you explain the basic steps? I have zero macro or vb script experience. I write my own html and edit some javascripts I use but that's about it.

In any case, I'll copy the script and ask a few guys at work if they know what to do with it. Thanks for the work though. I'll look at it some more and see if I can learn anything about this code. It looks intersting.

ShawnD1 · April 18th, 2004, 09:16 AM

damn, misread something...

sorry, ignore this

BITM@D · April 18th, 2004, 09:15 PM

Well, I worked out how to record and run a Macro and it worked out just fine (once I worked out that you have to highlight the section you want to output first). Thanks Omalley'.

Looks kind of plain though. I suppose it's the formatting that adds all that weight.

a271828 · January 10th, 2007, 02:46 PM

2Hey ALL -- you should learn some Unix/Linux tools.
Then you have plenty of ways to convert CSV to html table in less that 3 min.

jmichna · January 10th, 2007, 02:54 PM

Quote:

Originally Posted by a271828

2Hey ALL -- you should learn some Unix/Linux tools.
Then you have plenty of ways to convert CSV to html table in less that 3 min.

Welcome to TechIMO... BTW, did you realize you are replying to a thread that is almost 3 years old? Also, I'm sure Unix\Linux tools are wonderful, but why not just write a script that might take a few minutes and accomplish what you need to?